NanduriSiri_MidtermSQL_DM
docx
keyboard_arrow_up
School
Georgia State University *
*We aren’t endorsed by this school
Course
4810
Subject
Information Systems
Date
Dec 6, 2023
Type
docx
Pages
5
Uploaded by johndoejohndoe975
SIRI NANDURI
DATA MODELS NEXT PAGE:
Publix bakery on Atlanta Highway makes the best cakes. They have hired you to build a database
about the different cakes they can bake, the bakers and the clients that come to them with their
cake orders.
The Publix bakery can make different types of decorated cakes they cater to different occasions. For
instance they can make Wedding and Special occasion type such as "Something Blue", "Extreme
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Chocolate" as well as Theme type cakes like "Disney princess happily ever after", "Finding Dory
fantastic adventure". There have several types and many cakes under each type that can be baked
by the bakery. Every cake has a description and the main ingredients i.e. chocolate ganache,
strawberry icing, etc, that are part of the cake.
The bakery hires bakers to bake the cakes and they would like to store information about the name
of the baker, their contact information such as their phone number, the shift they work and the pay-
scale of the baker.
Clients come to the Publix bakery to have cakes baked. Publix would like to to store information
about the client, including their name and their contact information such as their phone number.
Clients can have many cakes baked by the bakery.
Publix would like to store information about the baker that baked the cake, the specific cake that
was baked, the client that requested the cake, the size of the cake, the date the cake was ordered,
the date the cake is to be delivered, whether there was a deposit put down on the cake and any
special instructions for the cake.
Create a data model that best represents the above scenario.
The Athens Clarke County airport plans to become a major hub of commercial and
regional air traffic and would like to track information about a new airport service it is
considering opening and has requested you to build them a data model that tracks the
following information.
The airport has many departure gates and information about the gates including their
number and location in the airport are stored. Several carriers that operate from the
airport. The airport would like to track the name of the carrier, its operating address and
contact information for the individual in charge of the carrier in the airport.
Carriers can fly several routes that originate or terminate at the local airport and the
airport would like to store information about the route including the duration it takes to fly
the route and the origination and destination airports.
Carriers can fly routes several times during the day and that route can be flown by
several carriers. The airport would like flight date and time stored in the database as well
as the gates at the airport that specific flights leave and land at.