Question

Exercise 2 - A UNIVERSITY A university consists of several faculties. Within each faculty there are...

Exercise 2 - A UNIVERSITY

A university consists of several faculties. Within each faculty there are several departments. Each department may run a number of courses. All teaching staff is attached to departments, each staff member belonging to a unique department. (Note: see how many meanings you can assign to this ambiguous sentence). Every course is composed of sub-courses. Some sub-courses are part of more than one course. Staff may teach on many sub-courses and each sub-course may be taught by a number of staff.

Draw an entity-relationship model for this example. Show both cardinalities and optionalities. Put a question mark where the degree is not clear from the text. Don't assume anything; rather, write a list of questions you would have to find answers to in order to complete the model.

Engineering   Computer-Science   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Exercise 2

An Entity relationship model of the UNIVERSITY database is as follows:

Entity

Entities are represented by rectangles. The UNIVERSITY database contains the following entities.

  • Faculty
  • Department
  • Course
  • Subcourse
  • Teaching staff

Attribute

An attribute describes the characteristics of an entity. Attributes are represented by ellipses. The UNIVERSITY database contains the attributes of each entity.

Relationships:

  • Each department may run a number of courses.
  • Staff may teach on many subcourses and each subcourse may be taught by a number of staff.
  • All teaching staff are attached to departments.
  • Some subcourses are part of more than one course.


Explanation:

ER Diagram:

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A University wants to create an ER Diagram for its business model in the blank space...
A University wants to create an ER Diagram for its business model in the blank space provided below It provides the following business rules. All the relationship and cardinalities need to be shown properly based on the business rules given below. Any assumptions you make should be clearly mentioned. Students can take many courses but will need to take at least one course. Courses will have at least one but likely many students. Student can rent up to 3 books...
Draw the scenario using Chen notation In a university, department offer courses. Department has instructors who...
Draw the scenario using Chen notation In a university, department offer courses. Department has instructors who teach courses. For a course, the instructor may or may not have a teaching assistant. Each department has a department name, a department code, 1-4 phone numbers, and an address. ◦ Each course has a course number (e.g., INFO605), a section number (e.g., 900), a title, a course type (e.g., online), and units. Each instructor has an instructor ID, first name, last name, gender,...
A university is a very busy place with a lot of students and also a lot...
A university is a very busy place with a lot of students and also a lot of employees to keep the system running perfectly. All people in the university have basic information like name, address, email and phone number. Employees at the university have extra information like employee-id and salary. There are also faculty and staff who are employees at the university. Each faculty has a designation and is assigned to a specific college and has number of courses taught....
The Enormous State University History Department offers three courses—Ancient, Medieval, and Modern History—and the chairperson is...
The Enormous State University History Department offers three courses—Ancient, Medieval, and Modern History—and the chairperson is trying to decide how many sections of each to offer this semester. The department is allowed to offer 49 sections total, there are 5,400 students who would like to take a course, and there are 65 professors to teach them. Sections of Ancient History have 100 students each, sections of Medieval History hold 50 students each, and sections of Modern History have 200 students...
The Enormous State University History Department offers three courses—Ancient, Medieval, and Modern History—and the chairperson is...
The Enormous State University History Department offers three courses—Ancient, Medieval, and Modern History—and the chairperson is trying to decide how many sections of each to offer this semester. The department is allowed to offer 48 sections total, there are 5,400 students who would like to take a course, and there are 64 professors to teach them. Sections of Ancient History have 100 students each, sections of Medieval History hold 50 students each, and sections of Modern History have 200 students...
Design an E-R diagram to model a college described below: ● There are several departments in...
Design an E-R diagram to model a college described below: ● There are several departments in a college, and each of them has a unique name, one or more telephone numbers, and an address. ● Each department gives some number of courses. Each course has a course number which can be used to identify a course only inside of the same department. Each course has its schedule and a certain number of credits. Each course is held in some location...
Design ER diagram to capture the information below and explain fully your answer: The University has...
Design ER diagram to capture the information below and explain fully your answer: The University has to create a database. In design stage the committee formed the following description: “The research activity at the University is organized as series of projects: Each project has project number, budget, funding organization, staring date and completion date. Each project has a PI who is full time faculty at the university. Each project has only one PI, but can have one or more Co-PI...
Develop an application to support course administration. Read the following detailed description of this application, and...
Develop an application to support course administration. Read the following detailed description of this application, and complete the tasks listed below. *. A course has a unique course number and title, and is assigned to one or more areas of the Computer Science program. Each course has an instructor, at least one teaching or research assistant, an online conference whiteboard, a time (interval), and a capacity (maximum number of participants). A course need not be offered each term, but the...
You are designing a dormitory administration system. The university has several dorms, each has many rooms....
You are designing a dormitory administration system. The university has several dorms, each has many rooms. A dorm is identified by its dorm ID. Besides, a dorm has a dorm name, street address, city, state, and zipcode. Each room is identified by a combination of dorm ID and room number. Besides, a room has number of beds, and monthly rent. The diagram should specify entities, identifiers, attributes, relationship types (identifying or non-identifying), and cardinalities (MAX and min on each side)....
You are asked to design a database to support a Instant Recruitment System of casual staff...
You are asked to design a database to support a Instant Recruitment System of casual staff for a school. The major business requirements are summarised below in the Mini Case: An Instant Recruitment System. You are asked to develop a detailed Entity-Relationship model for this mini case. Your ER model should consist of a detailed ER diagram integrated with itemised discussions on the features of the entities and relationships and all the assumptions you made where applicable. The ER diagram...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT