Given the Miniworld below: i. Draw a fully labelled Crow’s Foot ERD for the miniworld below. Include all the entities, relationships, optionalities and multiplicities and make sure that you identify...

1 answer below »
Given the Miniworld below: i. Draw a fully labelled Crow’s Foot ERD for the miniworld below. Include all the entities, relationships, optionalities and multiplicities and make sure that you identify all the primary and foreign keys. (10 Marks) ii. Convert the ERD to a relational Database Schema. (6 Marks) iii. Implement the Relational Database Schema using Oracle SQL*Plus. (20 Marks) (a) Use at least one sequence (b) List of your SQL DDL commands (with the necessary integrity and domain constraints). (c) Populate the database. Sample tuples for each relation (for each relation about 3 records). iv. Add some advanced features including (a) Create 2 Views (involving two different relations and with different limits to modifications) (b) Create 2 different procedures (c) Create 2 different synonyms (d) Create 2 different triggers (e) Index two of your tables USIU-Africa Page 2 of 2 Prof. Patrick Kanyi Wamuyu (f) Allow the user system to use and to allow other users to manipulate records in any of your project tables. He should also allow other users to access your tables. v. Create an Access Control (Authorization) Matrix for the users of your tables. (4 Marks)
Answered 23 days AfterNov 13, 2021

Answer To: Given the Miniworld below: i. Draw a fully labelled Crow’s Foot ERD for the miniworld below. Include...

Neha answered on Dec 07 2021
108 Votes
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here