Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q1. Determine whether the following operations will succeed or not on the Barnes_Nobles database. If the operation fails, explain why. Assume that all the records
Q1. Determine whether the following operations will succeed or not on the Barnes_Nobles database. If the operation fails, explain why. Assume that all the records in each table have been shown (refer to the accompanying file). If you make any assumptions, specify them. a) Inserting a new employee record with the following data: emp_id: B-T850214 fname: Helen lname: Bennett job_id: 14 job_lvl: 202 pub_id: 1756 hire_date: 2023020600:00:00 b) Inserting a new publisher with the following data: pub_id: 1622 pub_name: Lausanne Books city: Lausanne state: country: Switzerland c) Deleting the record of Livia Karsen from the Author table. d) Deleting the third record from the Sale table. e) Updating publisher id of 'Binnet \& Hardley' from 0877 to 1877 in the Publisher table. f) Changing job_id of new hires from 1 to 0 in the Job table. Q2. Using MySQL Workbench, Draw.io, or an ER tool of your choice create a logical EntityRelationship diagram that illustrates the Barnes_Nobles database. Q3. Identify an entity with a multi-valued attribute. Then use your tool of choice to draw the appropriate logical ER model for the entity and the multi-valued attribute. Q4. Considering the relationship between at least five entities, use an ER diagram to show how the entities are related. Identify the primary keys and foreign keys (if any) of all entities. Determine, at least, five attributes for each entity. Q5. Find examples for each of the following cases and draw them using Draw.io (or a software of your choice). Use examples other than those given in class or on Isidore. a) Disjoint total specialization b) Non-disjoint total specialization c) Disjoint partial specialization d) Non-disjoint partial specialization Author Title Barnes_Nobles Database Tables Employee Publisher Store Barnes_Nobles Database Tables Sale Authorshin Job
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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