Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a new table that will be used to track employee location. The attributes associated with the table: employee id, location id, location description, street

Create a new table that will be used to track employee location. The attributes associated with the table: employee id, location id, location description, street address, city, state, zipcode. Create a new table the attributes listed above. Please identify the primary key. It has a relationship with employees. Provide SQL statement

Books Authors AuthorlD FirstName LastName YearBom Authors ConditionID ConditionName Description 0c AuthorlD TitleID Publisher Description ConditionlD 1 1 BooksOrders Positions PositionlD JobDescrip Customers CustomerlD FirstName LastName EmployeelD LastName Address1 Addres2 Address1 Addres2 DeliveryDate PaymentlD OrderStatus FormOfPayment PaymentID PaymentDescrip StatusDescip

Authors AuthorlD FirstName LastName YearBom YearDied Description 1 BooksAuthors AuthorID TitleID Customers Customer D FirstName LastName Phone Address1 Address2 City State Zip OrderStatus StatusID Status Descip 00 Books TitlelD Title Publisher PubDate Edition Cost SRP ConditionID Sold BooksOrders OrderD TitlelD Orders OrderlD CustomerlD EmployeelD Amount OrderDate DeliveryDate PaymentID StatusID 00 FormOfPayment PaymentID Payment Descrip Authors ConditionID ConditionName Description Employees Employee D FirstName LastName Address1 Address2 City State Zip Phone DOB HireDate PositionID 00 1 Positions Position D Title Job Descrip

Step by Step Solution

3.37 Rating (153 Votes )

There are 3 Steps involved in it

Step: 1

A Employee Location Attributes employe id location id location descript... 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

Document Format ( 2 attachments)

PDF file Icon
60997ad84469d_29721.pdf

180 KBs PDF File

Word file Icon
60997ad84469d_29721.docx

120 KBs Word File

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

Macroeconomics

Authors: Charles I. Jones

3rd edition

978-0393123944, 393123944, 393923908, 978-0393923902

More Books

Students also viewed these Databases questions

Question

1. What is the function of commercial tax services?

Answered: 1 week ago

Question

Explain why self-acceptance is important for high self-esteem.

Answered: 1 week ago