Question

Please see images for the database info.

1. Specify, in your own language, the project requirement; identify the different types of users; and different views from different user groups.

2. For #2, at least two user groups and a user view for each user group. Also, the following steps are for each user groups/user views until step 8

3. Illustrate your data modeling by using ER model.

4. Use a document of your own, determine the attributes; use your own knowledge, determine the functional dependencies.

5. Illustrate the physical-level design process, list the tables, identify the keys, and list the special restrictions that programs must enforce.

6. Normalize all the tables at least into 3NF.

7. Merge your databases into one. Build a small database in Access or other DBMS based on the design.

8. Populate your database

9. Implement, using SQL OR QBE, a set of queries that can be used by users in different user groups (refer to 2).

Answer 1

IF YOU HAVE ANY DOUBTS COMMENT BELOW I WILL BE THERE TO HELP YOU

RATE THUMBSUP PLEASE

ANSWER:

EXPLANATION:

U can use different types of job groups like

Mechanic,salesman,client ,etc .

Here for example salesman will sells product with column as

Date,value and commission.

Same can be linked to client having client id ,phone number,

Address, etc .

Client buys things based on price, date and value .

U can relate these things in details using the below ER diagram.

Name Number Employee ISA Does Mechanic Salesmah Description Price Date NumberRepairlob Date Buys Sells Value enValue Parts Cost Work Repairs Car seller buyer Year Client Manufacturer Model Name Phone Address

RATE THUMBSUP PLEASE

THANKS