Student ID: Student Name:.

please read the uploaded file and go trough the whole SQL process it will explain how to do it. there is no word limitation in it .

Database Management
for Business
Student ID:
Student Name:

Introduction
 The assignment is based upon the
Australian Manufactring Company’s
database.
 The database design and
implementation is accomplished in
the assignment.
 The logical and physical design of
database are implemented in the

Logical Design
 The logical design is the base of
every database.
 It shows the requirement of the
database.
 It shows the flow of processes and
data into the system.

Physical Design
 The physical design is based upon
the logical design.
 The physical database for AMC is
implemented in MYSQL database.
 Different queries are generated in
AMC database.

Advantage
 The assignment has so many good
features and there are number of
advantages by doing this
assignment-
 Learned the use of logical design.
 Learned to generate complex SQL
queries.
 Learned the use of reverse
engineering

Thank You !