Database

1. Topic: shop 2. Design database conceptual model using CASE tool PowerDesigner (ER model) a. At least 5 entities b. 1:1, 1:N, N:M and unary relationships c. Different attributes data types (date, float, integer, text) d. constraints and data validation rules 3. Generate logical data model in the tool and explore and describe the changes in model 4. Specify database management system MS Access and generate database physical model. 5 Generate the SQL script file from generated database physical model. 6. Generate database in MS Access. 7. Verify the generated database correspondence to initially designed conceptual model 8. Create data input masks, captions, validation rule and drop down menus in MS Access 9. Input sample data (at least 10 records in each table)