Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I will post question 3 times and hopefully its done by one expext since they linked Scenario Boscon City Campus is a distance-learning institute of
I will post question 3 times and hopefully its done by one expext since they linked
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 changesStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started