Answered step by step
Verified Expert Solution
Question
1 Approved Answer
State the relationships between the tables to show the constraints imposed in the database. We will make use of the data contained in GlocerySale schema
State the relationships between the tables to show the constraints imposed in the database.
We will make use of the data contained in GlocerySale schema within the Imban- 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. 3 GlocerySales Tables > CustOrder > Customer Employee Orderline > Product CustOrder 123 Orderld int Order Date datetime Order Number nvarchar(10) 123 Customerld int Customer 123 Custid int ac FirstName nvarchar(40) LastName nvarchar(40) nvarchar(40) Ate Country nvarchar(40) ac Phone nvarchar(20) 123 EmpID int mc City Employee 123 Employeeld int ate LastName nvarchar(20) ane FirstName nvarchar(20) nec Title nvarchar(30) 123 Reports To int Birth Date datetime Hire Date datetime nec Address nvarchar(70) nvarchar(40) 206 State nvarchar(40) - Country nvarchar(40) nec PostalCode nvarchar(10) ac Phone nvarchar(24) ac Fax nvarchar(24) nvarchar(60) C City E int Orderline 123 Itemld int 123 Orderld 123 Productid int 123 UnitPrice decimal(12,2) 123 Quantity Product 123 Prodid int nec ProductName nvarchar(50) 123 Supplierld int 123 UnitPrice decimal(12,2) nec Package nvarchar(30) 123 Is Discontinued bit ne Email int We will make use of the data contained in GlocerySale schema within the Imban- 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. 3 GlocerySales Tables > CustOrder > Customer Employee Orderline > Product CustOrder 123 Orderld int Order Date datetime Order Number nvarchar(10) 123 Customerld int Customer 123 Custid int ac FirstName nvarchar(40) LastName nvarchar(40) nvarchar(40) Ate Country nvarchar(40) ac Phone nvarchar(20) 123 EmpID int mc City Employee 123 Employeeld int ate LastName nvarchar(20) ane FirstName nvarchar(20) nec Title nvarchar(30) 123 Reports To int Birth Date datetime Hire Date datetime nec Address nvarchar(70) nvarchar(40) 206 State nvarchar(40) - Country nvarchar(40) nec PostalCode nvarchar(10) ac Phone nvarchar(24) ac Fax nvarchar(24) nvarchar(60) C City E int Orderline 123 Itemld int 123 Orderld 123 Productid int 123 UnitPrice decimal(12,2) 123 Quantity Product 123 Prodid int nec ProductName nvarchar(50) 123 Supplierld int 123 UnitPrice decimal(12,2) nec Package nvarchar(30) 123 Is Discontinued bit ne Email intStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started