Assignment: DBMS Implementation
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
The following are steps for the implementation:
i. Install the DBMS.
ii. Tune the setup variables according to the hardware, software and usage conditions.
iii. Create the database and the tables. (Every table must have a primary key, which uniquely identifies rows in the table and validation rule).
iv. Establish relationships between tables.
v. Load the data into the tables.
vi. Create at least three forms (splash screen and Main switchboard are optional).
vii. Create at least four transaction requirement Queries
viii. Create data views and reports.
Format your assignment according to the following formatting requirements:
i) The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
ii) The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
iii) Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.