Database Development

Running head: DATABASE DEVELOPMENT
Database Development
Name of the Student:
Name of the University:
Author note

1
DATABASE DEVELOPMENT
Table of Contents
P1 Comparison and Contrast in between the different type of database models.......................2
P2 Produce a design for a relational database management system to meet client requirements
....................................................................................................................................................4
Current Issues in the system...................................................................................................4
Functional Requirements.......................................................................................................4
Non-functional Requirements................................................................................................5
ER Diagram............................................................................................................................5
P3 Develop a fully functional system which meets client and system requirements, using an
open source language (with an application software e.g. MySQL with front end Microsoft
Access).......................................................................................................................................7
User Interface (MS Visio)......................................................................................................7
Database Management System Development........................................................................8
System Development (MS Access)........................................................................................8
Screenshots of all SQL statements.........................................................................................9
Database Tables and Data (MS SQL Server Studio)...........................................................12
Database Queries..................................................................................................................14
P4 Test the system for functionality and performance.............................................................18
Required Queries..................................................................................................................18
Test Plan...............................................................................................................................18
P5 Demonstrate the tools available in the system to monitor and optimise system
performance, and examine the audit logs.................................................................................21
Demonstration of the tools available for monitoring and optimizing the system
performance..........................................................................................................................21
Demonstration of the tools available for examining the audit log.......................................21
P6 Demonstrate the tools available in the system to manage security and authorisations......22
Bibliography.............................................................................................................................23
Appendix..................................................................................................................................25

2
DATABASE DEVELOPMENT
P1 Comparison and Contrast in between the different type of database
models
ER
Database
Relational
database
Hierarchic
al database
Network
Database
Object
oriented
Database
Object-
relational
Database
Structure The
structure
of ER
database
provides
relation
among
the entity
steps
within a
database.
In
relational
database
structure
for every
attributes
within a
relationshi
p or entity
there are
specific set
of values
that are
allowed.
The
structure
of
hierarchica
l database
is
consisting
tree like
structure.
Here data
are
connected
with
another
using
links.
The
network
database
structures
as each of
the record
so that
each
record
consists
multiple
child and
parent
record.
This
actually
structures
as a
generalise
d graph.
Structure
of object
oriented is
consisting
a model
which is
having
informatio
n which
are
represente
d by the
objects.
Object-
relational
database is
structured
as having
subtypes
which will
reuse all
the
attributes
which
consists
additional
attributes
specific for
that
subtype.
Functional
ity
Important
functional
ity of ER
database
Main
functionali
ty of
relational
The main
functionali
ty of
hierarchica
Network
database
provides
the
The object
oriented is
having the
functionali
Through
using the
object
oriented

3
DATABASE DEVELOPMENT
is
debuggin
g or
designing
relational
database.
database is
managing
storage,
organizati
on and
security of
data.
l database
is
providing
a high
availabilit
y and
performan
ce.
functionali
ty of
ladder
affect
which
restricts
the
database
from
finding
any type
of
relationshi
p that is
outside of
the
category
of it.
ty of
concurrenc
y,
recovery
and
transaction
.
relational
database a
bridge is
built
between
object
oriented
modelling
technique
and
relational
database.
Filtering Filtering
the ER
database
is quite
simple
where
user can
do it
through
GUI.
Custom
filter can
be used in
the
relational
database
for finding
some
specific
data.
Filtering in
the
hierarchica
l database
can be
done in
two ways
which are
branch
selection
and level
selection.
Sort and
filtering
group need
to be
accessed
for the
filtering
process of
the
network
database.
Relationshi
p
All the
relationsh
ip within
Within the
relational
database
Hierarchic
al database
is having
Relationsh
ip within
the
Dynamic
type of
relationshi
Relationshi
p of the
object

4
DATABASE DEVELOPMENT
the entity
relationsh
ip
database
is
presented
through
graphical
representa
tion.
there are
mainly
three
relationshi
p which
are one-to-
one, one-
to-many
and many-
to-many.
two
relationshi
p which
are one-to-
one and
one-to-
many.
network
database
are arcs
type in
nature
which
distinguish
es it with
others.
p is used
in the
object
oriented
database.
relational
database is
similar
with
relational
database
where
relationship
s are the
one-to-one,
one-to-
many and
many-to-
many.
Design For the
designing
of entity
relationsh
ip
database
symbols
and the
connector
s are
used.
Through
this
design
physical
structure
of the
database
is
The design
of
relational
database
models
data and
informatio
n within a
set of
tables. In
this table
each of the
row
represents
the record
while
columns
represents
the data
The design
of
hierarchica
l database
is actually
an
embedded
type of
database
that is
used for
the mobile
systems.
The design
of the
network
model is
able to
solve the
problem
related
with the
model
which is
actually
lack of
flexibility.
This
design
allow
every child
to have
Design of
object
oriented
database is
consisting
the feature
of re-
usability.
Re-
usability
means
new
classes can
be created
from
existing
classes.
Design of
the object
relational
database is
actually
influenced
by the
support
need for the
declarative
type of
operations
within a
transaction
al system.

5
DATABASE DEVELOPMENT
reflected. attribute. multiple of
parents.
P2 Produce a design for a relational database management system to meet
client requirements
Current Issues in the system
The current issues in the Emanuel Car Rental Company is that all the procedures in
the organization take place manually. Hence a lot of issues are being identified in the current
system and the analysis of the current issues in the system are provided below:
Functional Requirements
The Functional requirements for the Emanuel Car Rental Company are described
below:
 The clients to the system should be able to register themselves to the system and
update the details about their cars.
 Additionally customers would be able to register to the system and make bookings
 The details of the bookings made by the customers should be recorded in the system
 The details of the payments are required to be recorded in the system.
 Additionally, the details of the invoice are required to be recorded in the system.
Non-functional Requirements
The non-functional requirements for the Emanuel Car Rental System has been
described below:
 The system should be available to customers at all time. The customer might need the
services at any time and hence they would be able to make at their time of need.
 The system should be scalable so that the additional data if required can be added to
the system.
 Additionally, the system that is to be developed in a manner that the organization for
whom the system is being developed doesn’t have to spend much on the maintenance.
ER Diagram
First normal form: