Database

/in /by

Database

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 

  1. Install the DBMS.
  2. Tune the setup variables according to the hardware, software and usage conditions.
  3. Create the database and the tables. (Every table must have a primary key, which uniquely identifies rows in the table and validation rule).
  4. Establish relationships between tables.
  5. Load the data into the tables.
  6. Create at least three forms (splash screen and Main switchboard are optional).
  7. Create at least four transaction requirement Queries
  8. Create data views and reports.

Note

Attach are references