group: Recitation 3
Suppliers = {
SupplierId:number, CompanyName:string, ContactName:string, ContactTitle:string, Adress:string, City:string, Region:string, PostalCode:string, Country:string, Phone:number, Fax:number, HomePage:string
123 , 'Kims Food' , 'Kim' , 'Chief' , 'bovägen' , 'Stockholm', 'Skåne' , '234 44' , 'Sweden' , 3424234 , 13432425 , 'www.kim.se'
333 , 'Olivers Låda' , 'Olive' , 'Lådansvarig' , 'hemma' , 'Göteborg', 'Uppland' , '666 66' , 'Sweden' , 5433221 , 44443232 , 'www.låda.se'
007 , 'Johans Bilar' , 'Johan' , 'Säljare' , 'sveavägen' , 'Stockholm', 'Svelland' , '921 80' , 'Sweden' , 6534234 , 6754432 , 'www.wromwrom.se'
}
Categories = {
CategoryID:number, CategoryName:string, Description:string, Picture:string
321 , 'Fruits' , 'fruties' , 'fruit.jpg'
828 , 'Other' , 'this is all the other stuff' , 'err404.jpg'
}
Products = {
ProductID:number, ProductName:string, SupplierID:number, CategoryID:number, QuantityPerUnit:number, UnitPrice:number, UnitsInStock:number, UnitsOnOrder:number, ReorderLevel:number, Discontinued:number
1 , 'Lingonberry' , 123 , 321 , 2 , 12 , 42 , 2 , 2 , 2
2 , 'Låda' , 333 , 828 , 3 , 10 , 100 , 1000 , 4 , 6
3 , 'Bil' , 007 , 828 , 1 , 30000 , 3000 , 0 , 5 , 0
}
Order_Details = {
OrderID:number, ProductID:number, UnitPrice:number, Quantity:number, Discount:number
55 , 1 , 1 , 2 , 1
33 , 3 , 4 , 1 , 0
45 , 2 , 1 , 5 , 0.5
11 , 2 , 2 , 1 , 0
}
Employees = {
EmployeeID:number, LastName:string, FirstName:string, Title:string, TitleOfCourtesy:string, BirthDate:string, HireDAte:string, Adress:string, City:string, Region:string, PostalCode:string, Country:string, HomePhone:number, Extension:string, Photo:string, Notes:string, ReportsTo:string
6289 , 'Ytterberg' , 'Kim' , 'Chief' , 'Lady' , '11/23/31' , '11/02/12' , 'bovägen' , 'Stockholm', 'Skåne' , '123 33' , 'Sweden' , 23112412 , 'Kevin' , 'kim.jpg' , 'awesome' , 'No one'
6666 , 'Paro' , 'Johan' , 'Dörrvakt' , 'Dude' , '40/30/00' , '90/50/10' , 'Hemma' , 'Stockholm', 'Moon' , '123 33' , 'Sweden' , 23002412 , 'N/A' , 'johan.jpg' , 'sometimes a pleb' , 'oliver the grandmaster of the uinverse'
0007 , 'Anteros' , 'Oliver' , 'Cricet Circus' , 'Grandmaster of the Universe' , '00/00/00' , '01/00/00' , 'Everywere' , 'N/A', 'N/A' , '000 00' , 'N/A' , 00000000 , 'N/A' , 'nightsky.jpg' , 'you wont ever see me coming' , 'the sun'
}
Orders = {
OrderID:number, CustomerID:number, EmployeeID:number, OrderDate:string, RequiredDate:string, ShippedDate:string, ShipVia:string, Freight:string, ShipName:string, ShipAdress:string, ShipCity:string, ShipRegion:string, ShipPostalCode:string, ShipCountry:string
55 , 2480 , 6289 , '27/02/02' , '28/02/02' , '28/02/02' , '66' , 'dunno' , 'MobyDick' , 'skansen' , 'Stockholm' , 'Skåne' , '123 33' , 'Sweden'
45 , 2480 , 0007 , '27/02/02' , '28/02/02' , '28/02/02' , '66' , 'dunno' , 'MobyDick' , 'skansen' , 'Stockholm' , 'Skåne' , '123 33' , 'Sweden'
11 , 1010 , 6666 , '21/42/02' , '08/31/93' , '10/44/00' , '33' , 'yes' , 'lol' , 'Mars' , 'Mars' , 'Mars' , '444 44' , 'N/A'
33 , 1231 , 6666 , '21/42/02' , '08/31/93' , '10/44/00' , '33' , 'yes' , 'lol' , 'Mars' , 'Mars' , 'Mars' , '444 44' , 'N/A'
}
Customers = {
CustomerID:number, CompanyName:string, ContactName:string, ContactTitle:string, Adress:string, City:string, Region:string, PostalCode:string, Country:string, Phone:number, Fax:number
2480 , 'EA' , 'Fridolf' , 'Head' , 'rollvägen' , 'Lund' , 'Skåne' , '246 33' , 'Sweden' , 2312312 , 12312312
1010 , 'Alien' , 'Arghg' , 'Head&Toung' , 'strashipenterprise' , 'N/A' , 'N/A' , '123 33' , 'N/A' , 00012110 , 393923919
1231 , 'Alien' , 'Arghg' , 'Head&Toung' , 'strashipenterprise' , 'N/A' , 'N/A' , '123 33' , 'N/A' , 00012110 , 393923919
}
Shippers = {
ShipperID:number, CompanyName:string, Phone:number
66 , 'BoatyMcBoatface' , 23501023
33 , 'We Fly Your Shit' , 23111111
}