Database Design And Development - Assignment

Running head: DATABASE DESIGN
Database Design
Name of the Student
Name of the University

DATABASE DESIGN1
Table of Contents
Answer to Question 1: 2
Answer to Question 2: 2
2.1 Functional Dependency: 2
2.2 Transaction is not in 3NF: 3
2.3 Decomposition: 3
Answer to Question 3: 3
Answer to Question 4: 5
Answer to Question 5: 6
Bibliography: 8

DATABASE DESIGN2
Answer to Question 1:
Figure 1: Relational Schema Mapping
(Source: Created by Author)
The candidate key (primary key) is defined within the doctor table is RegNo. The
patientID is the candidate key of Patient table. The AppointmentID is the candidate key of
appointment table.
All the tables are presently in third normal form. In the figure 1 it has been shown that the
tables do not have any dependency except than fully functional dependency. All the attributes are
in atomic form, there is no multivalued attribute.
Answer to Question 2:
2.1 Functional Dependency:
The proposed CustID is partially dependent on the OrderID. If the real word database
implementations are considered then it can be found that the orderID depends on the CustID, not
the other way. It can be stated that based on theoretical knowledge that the proposed database is
correct but it not practically logical.