CIT 0573 - Database Management System & Megah Supermarket System - IT Assignment Help

Assignment Task -                
 

Answer all questions

You are required to develop a database for “Megah Supermarket System”. Currently, there are 4 entities for this system which are employee, customer, product, and purchase. DBA plays an important role throughout this task.

A. Draw an ERD based on entities given above. Make sure all entities    

     connected                                

B. Use SQL command to CREATE Database, table and INSERT a value 

•   manually using Microsoft access
•  Use appropriate data type and field size.
• Insert data for each table created with MAX row = 5 data
• Create SQL command (query) to run the following task

i) View data

ii) Update data

iii) Delete data

iv) Sorting data

v) Like operator

C.  Explain the important roles of DBA.

D.  Documentation