Skip to content
  • Home
  • News
  • Sample Code
  • How To
  • Tutorial
  • Assignment Help!

Student Assignment Help

Assignment Solution @ Assignment Help on Fiverr.com

  • Home
  • News
  • Sample Code
    • C/C++ Sample Code
      • C in Linux
        • Linux Kernel Module
      • C in Windows
    • Java Sample Code
    • Python Sample Code
    • New Jersey Standard ML (SML/NJ)
    • Oracle Sample Code
    • Database Analysis and Design Sample
  • How To
    • HTML-XML-CSS
    • Java
    • MySQL
    • Oracle
    • Linux RedHat
  • Tutorial
    • System Analysis and Design
    • Data Flow Diagram DFD
    • Database Analysis and Design
    • C/C++ Language
    • WordPress
      • WordPress Basic
      • WordPress Security
  • Assignment Help!

Homework 5: Normalization

Posted on 2018-12-182018-12-18 By Presto Bear No Comments on Homework 5: Normalization

Download Solution: Click to Download Solution
Solution File Name: HomeWk5-Normalization-recheck_2CCC1BBB.docx
Unzip Password: prestobear.com

1.Problem 1(20 pts)
This exercise asks you to convert business statements into functional dependencies.
Product_Repair(serialNumber, type, versionNum, capacity, repairInvoiceID, repairDate, partNum, partType, partDescription)
Write a functional dependency for each of the following statements:
• serialNumber of a product determines its type and versionNum
• product type and version determines its capacity
• a product may be repaired many times, but never more than once on a given date. For each repair, there is a repair invoice. One invoice only records the repair for one product. A product may contain many parts that needed to be repaired on one repair invoice.
• for a component part, its type and description are unique for a partNum

2. Problem 2 (40 pts)
Consider the following relation
patientDrug(patientID, patientName, drugNum, drugName, Dosage, MethodOfAdministration, unitPerDay, startDate, endDate)

Given the functional dependencies that you have identified (see the practice exercise 9 key if yours is incorrect) , please
• identify the key of the table,
• then explain what normal form this relation is, and why
• Normalize it to 3NF. Please do not jump directly to the final decomposition. You need to show what 2NF this relations can be decomposed to (if it is not in 2NF), and then ifurther decomposition is needed to make all resultant relations 3NF relations.

3. Problem 4(40 pts)
carRental(customerID, customerName, customerAddress,carNum, carModel, carMake, carYear, carType, dailyRate, weeklyRate, monthlyRate, rentalDate, returnDate)
And the following functional dependecies:
customerID–> (customerName, customerAddress)
carNum –>(carModel, carMake, carYear, carType)
carType –>(dailyRate, weeklyRate, monthlyRate)
(customerID, carNum, rentDate)–> returnDate
o Find the key of the table. Explain why you chose it.
o what normal form is the relation in? Why?
o normalize the relation to 3NF. State the reason behind each decomposition. Again Do not jump directly to the final decomposition of R. You need to show the process of decomposing R into each appropriate normal form and explain why such decomposition is needed. For instance, if R is not in 2NF, decompose it into 2NF. If the resultant relations are not in 3NF, explain why and decompose further until 3NF

Assignment Help!!!
Database Analysis and Design Sample

Post navigation

Previous Post: BISI 3500 Data Mining
Next Post: Normalization – Practice Exercise 9

Leave a Reply Cancel reply

You must be logged in to post a comment.

Assignment Help!!!

Key Posts

  • Chapter 5 – Crow’s Foot Notation
  • [SOLVED] Could not find this item. This is no longer located
  • Linux command to get Tomcat PID
  • Case Study: Entity Relationship Diagram (ERD) for Student Registration System
  • Sample Java Program for Triangle
Assignment Help!!!

Recent Posts

  • Windows 10: How to start Command Prompt as Admin and Terminate a process
  • Java How to Trust all Email Server
  • [Solved]: Windows 10 100% Disk Usage
  • Weddings, Parties, Everything Catering Services System
  • CSC/CPE 3350 Lab 4 Part 1 – Recursive File Search
  • Zayed University
  • Kitchen Gadgets
  • Food Ordering System
  • Investment bank XYZ Ltd
  • CSC/CPE 3350 Lab 3 – The Falcon Shell
  • CSC/CPE 3350 Lab 2
  • Analyzing Cost and Benefit: Campus Bikes
  • Emirates Top Auto Parts
  • Sports News
  • Workington Council
Assignment Help!!!

Copyright © 2022 Student Assignment Help.