Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Graph Database Modeling With Neo4j

Authors: Ajit Singh

2nd Edition

B0BDWT2XLR, 979-8351798783

More Books

Students also viewed these Databases questions