Overview:
Create a database to keep track of how many students graduate with their first intended major.
Purpose and Objective:
The database will allow college administrators to track students initial major. This will help college officials decide how best to prepare students for their goals and to follow students into their careers. If there are majors where graduation rates are low it can help administrators making a decision that how to better serve students, make modifications to the curriculum or change standards of acceptance into the program.
Diagram Tool:
ER Assistant
Database:
Oracle 10g, using Nova.
Hardware and Software:
UMUC server system (Nova). Operating system is UNIX.
DDL and DML:
SQL (Structured Query Language) will be used for the DDL and DML. For my DDL scripts, use SQL to translate the information captured in my ER diagram (created in ER Assistant) into database table creation scripts. For DML scripts, use SQL to insert rows of data into database tables.