Database Management System Project

DATABASE
MANAGEMENT SYSTEM

TABLE OF CONTENTS
INTRODUCTION................................................................................................................................3
MAIN BODY.......................................................................................................................................3
Part 1.....................................................................................................................................................3
A set of relations mapped from E-R diagram.............................................................................3
Design database management using MS Access-.......................................................................4
Database table-............................................................................................................................6
Queries Design..........................................................................................................................10
Part 2...................................................................................................................................................13
E-R model on the car rental activity, with three relations Customer, Rental and Car..............13
Database design and implementation using MYSQL (structural query Language).................13
CONCLUSION..................................................................................................................................25

INTRODUCTION
Database is a collection of data and information which helps for update, delete, inserts
and manage data in the form tables. Data base manage system is important for organization to
manage the entire business process effectively and efficiently. Database manager provide the
information to their user and they have ability to manage read, write operations in business
operations and functions. This assignment will discuss about database that is implementations
occurred with the help of MS Access. This report will describe 3rd normal form to create
relationship between tables. Further, it also describes to database design with the help of
MYSQL server.
MAIN BODY
PART 1
A set of relations mapped from E-R diagram
1

Design database management using MS Access-
Normalization- Normalization is a database design technique used for creating database tables in
proper manner and it will reduce the dependency and redundancy of data and information in
database management system. It shows the relationship between the tables and data.
There are various types of Normalization techniques useful in database management system
which are discussed below:
1NF (Normal Form)
 Each and every table should contain single value.
 Each record needed to be unique.
2NF (Normal Form)
2nd Normal form is following satisfy the conditions such as:
 It will create table with the help of 1NF.
 All non-key attributes are fully functioned dependent on primary key.
3NF (Normal Form)
3rd Normal form has no transitive functional dependency.
2

Consider a Car Rental database, which contain many tables. To show functional
dependency in database we take 3 tables: CUSTOMER, INSURANCE, CAR where in
CUSTOMER table contains customer details, in CAR table contains vehicle detail and in
INSURANCE table contains insurance details of vehicles and the person who owns the vehicle.
In this case, there need to link these tables in order to get insurance of car. The way to do
this is via foreign key. There is a column in INSURANCE table that points to or references a
corresponding column (called primary key) is CUSTOMER and CAR parent table i.e.
customer_id and car_reg_no. Suppose in CUSTOMER table Clay Jennson with customer_id 151
wants an insurance of car where reg_no 93484OPY whose detail stored in INSURANCE table
for create an insurance for particular customer.
3

Now 3NF dictates that in INSURANCE table, the information hold about customer
should Customer_id and reg_no is that foreign key and references to identifies the customer who
owns the car with Customer_id (151) and reg_no (93484OPY) i.e. Clay Jennson. No other data
of CUSTOMER ansand CAR table stored in INSURANCE table. This ensuring that there is no
duplication of information, which turns queries run much more efficiently and shows functional
dependency 3NF.
Database table-
4