Database Design and Development

Running head: DATABASE DESIGN AND DEVELOPMENT
Database Design and Development
Name of the Student:
Name of the University:
Author Note

1
DATABASE DESIGN AND DEVELOPMENT
Executive Summary:
This report has been used for the description of the main procedures and data storing facility for
a college. In addition to this, the report includes various type of illustration that has been
included in the report so that the procedures in the college can be understood very easily. The
report also contains the conceptual designs of the system and the also the database design which
is to be implemented for the organization.

2
DATABASE DESIGN AND DEVELOPMENT
Table of Contents
Introduction......................................................................................................................................3
ERD.................................................................................................................................................3
Normalization..................................................................................................................................4
Database tables, keys, other fields, and Data...................................................................................4
Form.................................................................................................................................................7
Queries.............................................................................................................................................7
Query 1........................................................................................................................................7
Query 2........................................................................................................................................8
Query 3........................................................................................................................................9
Report............................................................................................................................................10
Conclusion.....................................................................................................................................10
Bibliography..................................................................................................................................11

3
DATABASE DESIGN AND DEVELOPMENT
Introduction
The development of the database has been done for the college students. The report has
been used here for the description of the same. In addition to this, the report also provides the
details of the database and the designs and the illustrations of the database that would be useful
to the readers. The report contains the Entity Relationship diagram, the database designs and the
queries for supporting the discussions in the report.
ERD
The ER Diagram has been used here to describe the details of the Entity and the attributes
used in the system are described in this report. The relationship in between the entities are also
described in the report.