Question: Answer no 2. I will post question 3 times, hopefully is answered by one expect since they linked Scenario Boscon City Campus is a distance-learning

Answer no 2. I will post question 3 times, hopefully is answered by one expect since they linked

Answer no 2. I will post question 3 times, hopefully is answered

Scenario Boscon City Campus is a distance-learning institute of higher learning. Its Information Technology department has two main diploma courses, Diploma in Systems Development and Diploma in Network Systems. Each course has several semester modules. There is only one Academic Quality Manager (AQM) for each course. And each module is managed by an educator who can manage other modules from either of the two diploma courses. From the student's side, a student can only enrol for one course from the IT department, and the student is expected to enrol in all the modules of the course. Use the information above to attempt the following. Submit only a pdf document. 1. Use the information from above and your knowledge of databases to determine all the database entities of the IT department of the Boscon City Campus. For each of the entities, summarize the information that the entity stores and all the attributes of the entity. 2. Determine the business rules of the database for the IT department. 3. Hence, draw an Entity Relationship Model of the system database. Write a summary of any assumptions you made in your design (where appropriate). Include any changes or modifications made to the requirements stated above. Justify those changes

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!