Question: 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

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
To create a new table that tracks employee locations we need to set up a table with the attributes s... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
60997ad84469d_29721.pdf
180 KBs PDF File
60997ad84469d_29721.docx
120 KBs Word File
