Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Analyze a collection of incorrectly designed relational schemas listed below. Please note, that all relational schemas are in 1 NF . If you do not
Analyze a collection of incorrectly designed relational schemas listed below. Please note,
that all relational schemas are in NF If you do not remember what does it mean please
refer to CSIT lecture slides.
ORDER customer# order# orderdate, part# quantity
A relational table ORDER contains information about the parts ordered by the customers
customer# An order is uniquely identified by an order number order# A part is
identified by a part number part# An order consists of one or more parts. An order is
submitted by a customer on a given day orderdate A quantity of each part is
determined an attribute quantity.
STUDENTstudentnumber, fullname, degree, totalcredits
required
A relational table STUDENT contains information about the students. A student is
described by a student number studentnumber and full name fullname Each
students is enrolled in one degree attribute degree An attribute totalcredits
required contains information about the total number of credits that must be collected
by a student to get a degree.
CONNECTION origincity,
addressofbusstationinorigincity,
destinationcity,
addressofbusstationindestinationcity,
ticketprice
A relational table CONNECTION contains information about the bus connections provided
by a transportation company. A description of a bus connection from an origin city
origincity to a destination city destinationcity includes an address of
bus station at an origin city addressofbusstationinorigincity and
an address of bus station at a destination city addressofbusstationin
destinationcity and ticket price ticketprice Assume that each city has
one bus station.
SUBMISSIONsubjectcode, assignment# student# fullname,
submittedfile
A relational table SUBMISSION contains information about the submissions of
assignments implemented by the students. A description of an assignment consists of a
subject code subjectcode assignment number assignment# and a path to a
submitted file submittedfile The submitted files are stored in a different location.
Each submission consists of one file. A student is described by a student number
student# and full name fullname
Use a method of row insertions explained in a presentation Database Design Quality to find the redundancies in the relational tables. Insert into the relational tables with the schemas headers listed above from to rows to demonstrate the redundancies.
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