Create a new table that will be used to track employee location. The attributes

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

Explanation / Answer

A: Employee Location:
Attributes: employe id, location id, location description, street address, city, state, zip code .

SQL Statement to create table Employee Location:
Primary Key: employe_id

CREATE TABLE Employee_Loc(employee_id INT PRIMARY KEY,location_id INT,location        VARCHAR(25),location_description VARCHAR(60),street_address VARCHAR(100),city VARCHAR(20),state VARCHAR(20),zipcode INT);

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.