Question

Project Definition - Describe the type of problem you wish to address with a database:

Let's say, an online video game or movie rental system.

A. Describe the concern or problem you will try to address with a small database

B. Provide examples of the current (possibly hypothetical) approach - include actual or

mock-ups of relevant forms, reports, lists, etc.

C. Discuss how your approach should eliminate Delete/Update/Insert problems and help

manage this issue in the future.

Any help will be greatly appreciated. Thank you!

Answer 1

A. Concern or problem addressed with database :

Removal of repeated data.
Multiple table links and dependency simplified.
Easier identification of data with help of unique id.
Quicker audit and easier management using database administration tools
Easy to write simple programs to generate reports out of the database.
B. Example of current approach :

Restaurant management system where all details are managed manually.
Area managers, deck managers, their reporting servers and cleaners information are stored and tracked manually.
Pay and salary management for employees are done through manual approach by tracking individually.
Adding a database that has primary key and foreign key link makes it easy to track reporting and pay for all employees of the restaurant.
C. Approach eliminating issues in data/ database :

Adding trigger conditions that make entries in other related tables when making entry in one single table.
Database automatically removes and stops adding of duplicate data when primary key is declared and used.
Foreign key dependancy makes manual updation on linked tables more easier.
Data :
Employee :
Name, Employee id(Primary key),Department, Type of employement

Payroll :

Name, Employee id(Foreign key), Current pay, taxes, deduction, Mode of payment

Reporting :

Name, Employee id(primary key), reporting to , Reporting to employee id(foreign key)