store staff 1(0) 1(0) customer 1(0) has has has 1(0) phone phone_id 1-1(1) country_code M-1(1) 1(0) phone_number M-1(1) phone_type M-1(0) 1(0) The diagram uses Sakila naming conventions. Follow the Sakila conventions for your table and column names: • All lower case • Underscore separator between root and suffix • Foreign keys have the same name as referenced primary key Write CREATE TABLE and ALTER TABLE statements that: 1. Implement the entity as a new phone table. 2. Implement the has relationships as foreign keys in the Sakila customer, staff, and store tables. 3. Remove the existing phone column from the Sakila address table. Step 2 requires adding a foreign key constraint to an existing table. Ex:

store staff 1(0) 1(0) customer 1(0) has has has 1(0) phone phone_id 1-1(1) country_code M-1(1) 1(0) phone_number M-1(1) phone_type M-1(0) 1(0) The diagram uses Sakila naming conventions. Follow the Sakila conventions for your table and column names: • All lower case • Underscore separator between root and suffix • Foreign keys have the same name as referenced primary key Write CREATE TABLE and ALTER TABLE statements that: 1. Implement the entity as a new phone table. 2. Implement the has relationships as foreign keys in the Sakila customer, staff, and store tables. 3. Remove the existing phone column from the Sakila address table. Step 2 requires adding a foreign key constraint to an existing table. Ex:

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Q: Convert to normalization

A: Given that, The given database tables are: Person, Employee, Department, Invoice, Customer, Supplier…

Q: 2.1 In Tables A,B,C identify the primary key(s), secondary key(s) and the foreign key(s). If a table…

A: 2.1 In Tables A,B,C identify the primary key(s), secondary key(s) and the foreign key(s). If a table…

Q: Dete Adess Year of_death Purchase date Number_of entais Nane Year of Jath Code Times eted Number…

A: we need to convert given E-R diagram to Relational schema. For N: M relation we have created a New…

Q: Normalize the following unnormalized table using the three normalization rules and describe each…

A: Dear Student, The three normalization rules are nothing but the normal form conversion of the table,…

Q: Convert the following ER diagram into relational schema

Q: If the functional dependencies are consistent with the above relation, put TRUE. If they are not,…

A: functionally dependent defines the relationship between attributes, how they are related. A-> B…

Q: i) manufacturer → model Answer: i) MID — сараcity Answer: iii) model → capacity Answer: iv) MID →…

Q: access databases Normalization Exercise Represent this table as a collection of tables in 3NF:…

A: The key for the given relation is (StudentNumber, CourseNumber) The partial functional dependency…

Q: Course • Courseld CourseCode CourseName Capacity Instructorld 3815 ENGL862 American Literature 75 2…

A: The question requires us to write a SQL query that will return the details of instructors who teach…

Q: Based on the diagram. 30.Display the name of the passengers whose tickets include only one flight.

A: The above question is solved in step 2 :-

Q: customer (customer_id, first_name, last_name, customer_email, customer_address, city,…

A: customer (customer_id, first_name, last_name, customer_email, customer_address, city,…

Q: Normalize the following unnormalized table using the three normalization rules and describe each…

A: The given is a single table where a set of attributes are added. The requirement is to normalize the…

Question

4.13 LAB - Implement strong entity (Sakila)
Implement a new strong entity phone in the Sakila database. Attributes and relationships are shown in the following diagram:
store
staff
●
1(0)
●
1(0)
customer 1(0)
has.
has
has.
phone
phone_id 1-1(1)
country_code M-1(1)
1(0) phone_number M-1(1)
phone_type M-1(0)
1(0)
The diagram uses Sakila naming conventions. Follow the Sakila conventions for your table and column names:
. All lower case
• Underscore separator between root and suffix
Foreign keys have the same name as referenced primary key
Write CREATE TABLE and ALTER TABLE statements that:
1. Implement the entity as a new phone table.
2. Implement the has relationships as foreign keys in the Sakila customer, staff, and store tables.
3. Remove the existing phone column from the Sakila address table.
Step 2 requires adding a foreign key constraint to an existing table. Ex:
1(0)
ALTER TABLE customer
ADD FOREIGN KEY (phone_id) REFERENCES phone (phone_id)
ON DELETE SET NULL
ON UPDATE CASCADE;
Specify data types as follows:
• phone_id, phone_number, and country_code have data type INT.
phone_type has date type VARCHAR(12) and contains strings like 'Home', 'Mobile', and 'Other'.
Apply these constraints:
• NOT NULL constraints correspond to cardinalities on the diagram above.
• Foreign key actions are SET NULL for delete rules and CASCADE for update rules.
Specify a suitable column as the phone table primary key.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

Create the table that results from EMPLOYEE PRODUCT DEPT I am unsure of what to do here. I f the column DEPTNAME is in both tables do I put the column twice? Please explain what to do in this case and provide the result.
database programming
Tables: department, dept_emp, dept_manager, employees, salaries, titles department (columns): dept_no, dept_name dept_emp (columns): emp_no, dept_no, from_date, to_date dept_manager (columns): emp_no, dept_no, from_date, to_date employees (columns): emp_no, birth_date, first_name, Last_name, gender, hire_date salaries (columns): emp_no, salary, from_date, to_date titles (columns): emp_no, title, from_date, to_date a) Your task is to write a SQL query to find count of employee who does not have a manager in the above given table schema?
drow ER deigram for this table
Customer_ID Customer_Name Order_ID Order_Date Product_Name Quantity 101 Alice 1 2023-09-01 Laptop 2 101 Alice 1 2023-09-01 Mouse 1 102 Bob 2 2023-09-02 Monitor 1 102 Bob 2 2023-09-02 Keyboard 1 103 Carol 3 2023-09-03 Laptop 1 103 Carol 3 2023-09-03 Speaker 2 For the following tables, identify the following functional dependencies where ( ? → Customer_Name). (Customer_ID → Customer_Name ). (Customer_ID, Order_ID → Customer_Name ). (Customer_ID, Order_ID, Order_Date → Customer_Name ). (Order_ID → Customer_Name ).
Please refer to the following diagram for Q19 to Q20. PERSON PK P_ID P_LNAME P_FNAME ΕMPLOYΕ P_ID EMP_HIRE_DATE STUDENT P ID STUDY ΜAIOR PK, FK1 PK, FK1 19. Which of the following statements is/are true? (1) A Person must be either a Student or an Employee. (2) A Person can neither be a Student nor an Employee. (3) A Person must be a Student or an Employee or both. a. (1) only b. (3) only c. (1) and (2) only d. (1), (2) and (3).
How many times has each language been used in films? Return the value for all six languages. Display: language name and the number of films