Limited Time OfferFLAT 20% off & $20 bonus sign up. Order Now
New! Hire Essay Assignment Writer Online and Get Flat 20% Discount!!Order Now
The business rules derived from the case study are;
The following assumptions are made on top of the derived business rules;
Normalization occurs in 3 steps
Following the three levels of normalization, the following relations are derived from the Entity Relationship Diagram.
Course (courseID,name,cost)
Teaching_staff (staffID,name,family,dob,phone,address,degree)
Staff_courses (staffCourseID,staffID,courseID)
Instruments (instrumentID,name,manufacturer_name,quantity)
Lesson_instruments (lesson_instr_ID,lessonID,instrumentID)
Lessons (lessonID, coursed, duration, date)
Students (studentID,name,postalAddress,dob,contactNO)
Payments (paymentID,studentID,couseID,status,datePaid)
Course_enrollment (enrollmentID, studentID, courseID)
All relations are in 3NF because no transitive dependencies exist in any relation. This can be shown by showing the functional dependency in each relation where every non-key attribute depends on a key attribute or on the primary key of the relation
All relations have functional dependencies existing between the attributes.
(coursed)à(name,cost)
(staffID)à(name,family,dob,phone,address,degree)
Staff_courses relation
(staffCourseID)à(staffID,courseID)
instruments relation
(instrumentID)à(name,manufacturer_name,quantity)
Lesson_instruments relation
(lesson_instr_ID)à(lessonID,instrumentID)
Lessons relation
(lessonID)à(coursed, duration, date)
students relation
(studentID)à(name,postalAddress,dob,contactNO)
payments relation
(paymentID)à(studentID,couseID,status,datePaid)
Enrollment relation
(enrollmentID)à(studentID, courseID)
From the set of functional dependencies shown above all the relations are in 3NF because there is no transitive dependency present in any relation.
Czenky, M. (2010). Normalization based on dependency diagram. Teaching Maths and Computer Science, 1-121. Retrieved May 3, 2017, from http://tmcs.math.unideb.hu/load_doc.php?p=188&t=doc
Watt, A. (n.d.). Database Design:Chapter 11 Functional Dependencies. Retrieved May 3, 2017, from https://opentextbc.ca/dbdesign/chapter/chapter-11-functional-dependencies/
Watt, A. (n.d.). Database Design:Chapter 12 Normalization. Retrieved May 3, 2017, from https://opentextbc.ca/dbdesign/chapter/chapter-12-Normalization/
No matter how close the deadline is, you will find quick solutions for your urgent assignments.
All assessments are written by experts based on research and credible sources. It also quality-approved by editors and proofreaders.
Our team consists of writers and PhD scholars with profound knowledge in their subject of study and deliver A+ quality solution.
We offer academic help services for a wide array of subjects.
We care about our students and guarantee the best price in the market to help them avail top academic services that fit any budget.
15,000+ happy customers and counting!