Database Design and Implementation for AMC System, ISY1002/ISY103

This assignment provides a comprehensive solution for a database project centered around the Australian Manufacturing Company (AMC) system, addressing the requirements of the ISY1002/ISY103 course. The solution encompasses the entire database design and implementation process, starting with the creation of an Entity-Relationship (ER) diagram using Crow's Foot notation to visually represent the system's entities and their relationships. Following the ER diagram, the assignment focuses on database normalization, detailing the steps to achieve the third normal form (3NF) and justifying the design choices. The solution further includes the creation of a relational schema, outlining the table structures and attributes. The physical design and implementation of the database in MySQL are also highlighted, including the use of MySQL features. The assignment emphasizes the benefits of the implemented design, such as improved data organization and the ability to efficiently execute database queries. The provided solution covers key database concepts like normalization, RDBMS features, and database relationships, offering a practical guide for students to understand and implement database systems from scratch.

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!