Database Management for Business ISY1002/ISY103.

Hi I am not completely aware about this assignment, please read everything of this task and let me know if you understand what to do in this Is it possible to get this practical done or we need some software for this ?

Database Management
for Business
ISY1002/ISY103

Introduction
 The assignment is based upon the
database design and implementation
of AMC system.
 All features given in the assignment
are giving the extreme knowledge
e.g. Database Normalization,
Database Queries etc.

Implemented Features of MYSQL
 Database Queries
 Database Normalization
 Reverse Engineering
 Mapping the un-normalized database
to normalized database

Logical Design
 The logical design of the database is
also built in the assignment.
 The ER diagram is created which is
showing the important data in the
form of entities and relationship in
between them.

Physical Design
 The physical design of AMC database
is implemented in MYSQL.
 The MYSQL is a very powerful
database management system which
provides features to manage data in
normalized form.

Normalized Data
 The data in normalized form is very
attractive and effective. To make the
data into third normalized form
following rules have to be followed-
 There is no repeated group in the
table.
 Every table has primary key.

 All fields in the table depends upon
the primary key only.
 There is no transitive dependency in
any table.
 These are the rules of third
normalizations.

RDBMS Features
 MYSQL is the RDBMS and the database is
implemented in the MYSQL.
 The data is stored in the form of relations.
 All relations are connected with each other.
 There are three types of database
relationships in between the relations-

 one-to-many
 Many-to-many
 One-to-one

Benefits
 The assignment has given the good
opportunity to learn the all important
features of the database.
 It is giving the complete knowledge
to develop the database from
scratch.

Thank You!