Database Project (Database Normalization, ERD, Access Implementation and Basic Questions)

By Hassnain Jamil -

I- Short Answer Questions: Answer the questions briefly. 


  1. Explain briefly referential integrity
  2. Using a sentence each, based on your understanding of database design, list 2 advantages of using a database system in comparison with using traditional electronic file processing systems
  3. Distinguish between the primary key, candidate key, and surrogate key
  4. In the following relation, which tracks payments made out to payees,        Payment (Payment-Num, Payment-Amount, Payee-ID, Payee-Name, Payee-Address), the functional dependencies are:  Payment-Num - Payment-Amount, Payee-ID, Payee-Name, Payee-Address Payee-ID - Payee-Name, Payee-Address. Please explain why this relation is subject to insertion anomaly and deletion anomaly 




II- Suppose you are the database analyst designing a database for a swim team league called Water Fun League (WFL): 

First, WFL wants to keep track of the swim teams in the league and their swimmers. Each swim team has an official name and a captain. A team is made up of many swimmers.  WFL tracks each swimmer’s name, address, phone number, and date of birth.  A swimmer can be a member of only one team.

Second, WFL wants the database to keep track of the swim meets it holds. WFL has a numbering system for each swim meet. A swim meet also has an official name (such as “Father’s Day Swim Meet”), and the time and location are announced as soon as available. All teams in the league can compete at each meet.

A meet consists of a variety of events (e.g., Men’s 50m freestyle, Women’s 100m butterfly, so on and so forth). The league keeps the League Record for each event as well as the corresponding national amateurs’ record as a reference.  A swimmer can compete in multiple events at a swim meet.

Please design an ER diagram for the WFL database. Save it as XXXWFL.erd. Make any assumption you may need. STATE THEM CLEARLY. • The ER diagram must include the necessary entity classes and all attributes specified in the description.• Identifiers for all entity classes must be shown clearly. • Relationships must be named, with cardinalities clearly shown.

III- The following is the ERD for Garden Glory, a partnership that provides gardening and yard maintenance services to individuals and organizations. Covert the data model into a relational database design for Garden Glory (using MS Access). Save the database as XXXGardenGlory.accdb.   IV- A small hair salon keeps the customer appointment information using the following file: 

Appointments (Stylist-ID, Stylist-Name, Date, Timeslot, Customer-ID, Customer-Name, Customer-Phone, Type-of-Service)
The following dependencies hold true:

Stylist-ID - Stylist-NameCustomer-ID -Customer-Name, Customer-PhoneStylist-ID, Date, Timeslot - Stylist-Name, Customer-ID, Customer-Name, Customer-Phone, Type-of-Service

You are required to normalize the above schema to 3NF in a step-wise manner.  At each step, clearly list all the relations in the schema, and show the primary key and foreign keys of each relation. You also need to draw an arrow from FK to its “parent” PK as shown in the examples we discussed in class.

STEP 1: How can you make the Appointments relation conform to 1NF?
STEP 2: Is your answer to Step 1 in 2NF? Why or Why not? Please articulate the reason(s). If not, normalize the schema to 2NF.
STEP 3: Is your answer to Step 2 in 3NF? Why or Why not? Please articulate the reason(s). If not, normalize the schema to 3NF.
STEP 4: Is your answer to Step 3 in BCNF?  Please articulate the reason(s). If not, normalize the schema to BCNF.


Buy now

CONTACT DETAILS

For any other questions or other tasks please feel free to contact me
via email: mhassnainjamil@gmail.com
via WhatsApp: +92-324-7042178
via skype: hassnainjamil1

Comments

Post a Comment

Popular posts from this blog

[SOLVED] Tape for a Turing Machine using Doubly-linked List in Java with full source code

By Anonymous -
Tape for a Turing Machine (Doubly-linked List) Short exercise in which you will code part of an existing project. In this case, you will be working with a doubly-linked list. To make this topic more interesting, the list that you work on will be part of a Turing Machine. A Turing Machine is a kind of very simple, abstract computing device that was introduced in the 1930's by Alan Turing as a way of studying computation and its limitations. The classes that you need for the lab are in a package named turing. You will define a new class named Tape in this package. You can find the Java source in the code directory. You should copy this directory into an Eclipse project. There will be errors, since the existing classes depend on the Tape class, which you have not yet written. Don't forget the Javadoc comments. A Class for Turing Machine Tapes A Turing machine works on a "tape" that is used for both input and output. The tape is made up of little squares called cell
Read more

[SOLVED] Branch Coverage, Statement Coverage and Path Coverage | Java Unit Testing

By Anonymous -
Create a directory called “TestClassValue” Hereafter, we call this directory <dir>. Create a Java class com.work.sample.FlawedClass in directory <dir>/src. (The actual path will obviously reflect the package structure.) 100% Branch Coverage & 100% Statement Coverage Add to the class a method called flawedMethodl that contains a division by zero fault such that it is possible to create a test suite that achieves 100% branch coverage and does not reveal the fault every test suite that achieves 100% statement coverage reveals the fault. Conversely, if you were able to create the method, then create two JUnit test classes com.work.sample.FlawedClassTestBCl and com.work.sample.FlawedClassTestSCl for class FlawedClass as follows: FlawedClassTestBCl should achieve 100% branch coverage of flawedMethodl and not reveal the fault therein. FlawedClassTestSCl should achieve 100% statement coverage of flawedMethodl and reveal the fault therein. Both classes should be
Read more

[SOLVED] Buggy Search And Sort Buy Reporting with Java source code

By Anonymous -
Report The Bug From The Following Source Code: import java.util.Arrays; /** * This class looks like it's meant to provide a few public static methods for * searching and sorting arrays. It also has a main method that tests the * searching and sorting methods. *  * TODO: The search and sort methods in this class contain bugs that can cause * incorrect output or infinite loops. Use the Eclipse debugger to find the bugs * and fix them */ public class BuggySearchAndSort { public static void main(String[] args) { int[] A = new int[10]; // Create an array and fill it with random ints. for (int i = 0; i < 10; i++) { A[i] = 1 + (int) (10 * Math.random()); } int[] B = A.clone(); // Make copies of the array. int[] C = A.clone(); int[] D = A.clone(); System.out.print("The array is:"); printArray(A); if (contains(A, 5)) { System.out.println("This array DOES contain 5."); } else { System.out.println("This array DOES NOT contain 5."
Read more