Question
Consider a conceptual schema given below. ALCOHOLIC AlcoholPercent PUB Serves DrinkName DrinkVol DRINK ID PubName ID PubAddress price SERVES NON-ALCOHOLIC SugarPercent Supervises 0..1 Orders
Consider a conceptual schema given below. ALCOHOLIC AlcoholPercent PUB Serves DrinkName DrinkVol DRINK ID PubName ID PubAddress price SERVES NON-ALCOHOLIC SugarPercent Supervises 0..1 Orders A WAITER Date, DrinkNumber ORDERS SpecialInstruction Takes 1.. fName ID1 IName ID1 DOB ID1 0.. CUSTOMER CustomerName CustomerMobile ID Your task is to perform a step of logical database design, i.e. to transform a conceptual schema given above into a collection of relational schemas. For each relational schema clearly list the names of attributes, primary key, candidate keys (if any), and foreign keys (if any). Where applicable, assume, that superset method must be used to implement a generalization.
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 StartedRecommended Textbook for
Introductory Statistics
Authors: Prem S. Mann
8th Edition
9781118473986, 470904100, 1118473981, 978-0470904107
Students also viewed these Programming questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App