Part 2: Database retrieval using SQL

We will make use of the data contained in GlocerySale schema within the lmban-teaching.database.windows.net. Please refer to Lecture 1 slides for instructions on how to access the server via DBeaver if you have not accessed it already.

Start by exploring the contents of the tables understanding the meaning of the attributes of each table.

v GlocerySales Employee v BB Tables Customer 123 Employeeld int ABC LastName nvarchar(20) BCustOrder 123 Custld int CustOrder ABC FirstName nvarchar(20) Customer 123 Orderld int ADC FirstName nvarchar(40) ABC Title nvarchar(30) ADC LastName nvarchar(40) > Employee OrderDate datetime 123 Reports To int ABC City nvarchar(40) . . . . OrderLine ABC OrderNumber nvarchar(10) BirthDate datetime > ABC Country nvarchar(40) int HireDate > EB Product 123 Customerld datetime ABC Phone nvarchar(20) ADC Address nvarchar(70) 123 EmpID int ADC City nvarchar(40) ADC State nvarchar(40) OrderLine Product ADC Country nvarchar(40) 123 Itemld int 123 Prodid int ADC PostalCode nvarchar(10) 123 Orderld int ROC ProductName nvarchar(50) ABC Phone nvarchar(24) 123 Productld int 123 Supplierld int ADC Fax nvarchar(24) 123 UnitPrice decimal(12,2) 123 UnitPrice decimal(12,2) ADC Email nvarchar(60) 123 Quantity int ADC Package nvarchar(30) 123 Is Discontinued bit