Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 int

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management For Public Health And Not For Profit Organizations

Authors: Steven A. Finkler

3rd Edition

0136070736, 978-0136070733

Students also viewed these Accounting questions

Question

DeterminetheMLEof and identifywhenitiswell-defined.

Answered: 1 week ago