Why did I get ERROR 1050 (42S01) at line 1: Table 'address' already exists? What am I
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Related Book For
Cost management a strategic approach
ISBN: 978-0073526942
5th edition
Authors: Edward J. Blocher, David E. Stout, Gary Cokins
Posted Date:
Students also viewed these databases questions
-
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...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
apple company: 1.what are key characteristics of the industry? 2. where is the company in its life cycle?
-
Assume that total output is determined by this formula: Number of workers productivity = total output (Output per worker) (a) If the workforce is growing by 1 percent but productivity doesn't...
-
Below are transactions for Wolverine Company during 2021. 1. On December 1, 2021, Wolverine receives $4,000 cash from a company that is renting office space from Wolverine. The payment, representing...
-
A tension test was performed on a steel specimen having an original diameter of 12.5mm and gage length of 50mm. Using the data listed in the table, plot the stress-strain diagram, and determine...
-
Yount Co. has equipment that cost $50,000 and that has been depreciated $22,000. Record the disposal under the following assumptions. (a) It was scrapped as having no value. (b) It was sold for...
-
When management understands the overall cost structure of a company ,they are in a better position to identify possible cost reductions without negatively affecting the quality of products sold or...
-
Which series has the highest beta. BraveNewCoin Liquid Index for Bitcoin 1D BNC Trading Brave Ne Yellow Green Blue Orange
-
Krissy McLain is a physician with her own practice. She has developed contracts with several large employers to perform routine exams, fitnessforduty exams, and initial screening of onthejob...
-
How does Le Chatelier's principle explain the behavior of equilibrium systems?
-
The journal entry to record a business asset that was sold in QuickBooks 1. Land 1 million dollars 2. Building 200,000.00 3. Accumulated Depreciation 42,000 4. Selling Expenses 92,000 5. Gain on sale...
-
Hokey Pokey Pte Ltd (HPPL) produces baseball bats, and adopts a standard costing system for control purposes. The following standard cost has been developed: Direct materials Direct labour Variable...
-
The fallacy of arguing that a claim must be true merely because a substantial number of people believe it is known as... appeal to the poeple O hasty generalization appeal to authority appeal to...
-
Reflecting on your current work industry or one that you want to get into, what website analytics do you feel would provide the best information and why? Can you share examples?
-
(a) Calculate the Moon's mass given the acceleration due to gravity at the north pole is 1.625 m/s2 and the radius of the Moon at the pole is 1,736 km. M. calculated kg %3D (b) Compare this with the...
-
2. Assume a person bends forward to lift a load "with his back" as shown in Figure P12.42a. The person's spine piv- ots mainly at the fifth lumbar vertebra, with the principal supporting force...
-
The following information pertains to the Petrie Company: Prime costs ................$180,000 Conversion costs ............. 215,000 Direct materials used ............. 95,000 Beginning work in...
-
Factory overhead includes a variety of costs that vary greatly with respect to the production process. What is the best way to choose an appropriate cost driver when applying factory overhead?
-
Are all fixed costs indirect? Explain.
-
Most countries in Europe do not have stringent laws to protect whistleblowers. True/false
-
In view of significant financial losses to investors, corporate fraud does not really affect the U.S. economy and investor confidence. True/false
-
The National Crisis Inquiry Report (2011) concluded that the financial crisis was unavoidable. True/false
Study smarter with the SolutionInn App