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

Transcribed Image Text:

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

Answer rating: 100% (QA)

A Employee Location Attributes employe id location id location descript... View the full answer