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.
Keep in mind that you are going to present your DBMS at the final project presentation day.
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. Format your write-up in an APA-style essay an include APA-style references (if applicable). You do not need to include a title page for this assignment. Grammar, spelling, and quality will influence your grade.
