Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Why did I get ERROR 1050 (42S01) at line 1: Table 'address' already exists? What am I doing wrong? Home O8 https://learn.zybooks.com/zybook/DAT_380_56255883/chapter/5/section/7 =zyBooks My library
Home O8 https://learn.zybooks.com/zybook/DAT_380_56255883/chapter/5/section/7 =zyBooks My library > DAT/380: Advanced Database Architecture home > 5.7: LAB - Implement supertype and subtype entities (Sakila) Q Search X 55 Content / DAT/380: Advanced DX zy Section 5.1 - DAT/380: Advance X zy Section 5.7 - DAT/380: Advance X 5.7 LAB - Implement supertype and subtype entities (Sakila) Refer to the customer and staff tables of the Sakila database. These tables have many columns in common and represent similar entities. Convert the customer and staff entities into subtypes of a new supertype person: address belongs to 1(1) M(0) coursehero.com/profile/BaronAX + person_id first_name last_name email active last_update person staff person_id picture username password customer person_id create_date works at 1(1) M(0) All columns are NOT NULL. The person_id columns have data type SMALLINT UNSIGNED. The last_update and create_date columns have data type TIMESTAMP. The picture column has data type BLOB. All other columns have data type VARCHAR (20). 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 store Implement supertype and subtype entities as person, customer, and staff tables with primary key person_id. Implement attributes as columns: Implement the dependency relationships between subtype and supertype entities as foreign keys: The person_id columns of customer and staff become foreign keys referring to person. Specify CASCADE actions for both relationships. Implement the belongs to and works at relationships as foreign keys: belongs to becomes an address_id foreign key in person referring to address. works_at becomes a store_id foreign key in staff referring to store. Specify RESTRICT actions for both relationships. B 90% EzyBooks catalog ? Help/FAQ ENG 1 Trung Tran 10:54 AM 12/23/2022
Step by Step Solution
There are 3 Steps involved in it
Step: 1
The error message ERROR 1050 42S01 Table address already exists indicates that you are attempting to create a table named address that already exists ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started