Final project is to develop a database from the ground up, including the conceptual modeling design, entity relationship diagram (ERD), logical modeling design, relational schema, physical modeling de
::Database Management System (DBMS) Implementation::
The implementation phase is where you install the Database Management System (DBMS) on the required hardware, optimize the database to run best on that hardware and software platform, and create the database and load the data. The initial data could be either new data or existing data imported from your SQL scripts. You also establish database objects this week and give the users that you've identified access applicable to the database requirements.
The following are steps for the implementation assignment:
Install the DBMS.
Tune the setup variables according to the hardware, software and usage conditions.
Create the database and the tables. (Every table must have a primary key, which uniquely identifies rows in the table and validation rule).
Establish relationships between tables.
Load the data into the tables.
Create at least three forms (splash screen and Main switchboard are optional).
Create at least four transaction requirement Queries. (from week 5).
Create data views and reports.
If it is necessary for your DBMS, all transactions can be handled by SQL scripts. Submit a document report essay with screenshots and any additional files.
