answersLogoWhite

0

The Silicon Valley university database stores details about university students, courses, the semester a student took a particular course (and his mark and grade if he completed it), and what degree program each student is enrolled in. The database is a long way from one that'd be suitable for a large tertiary institution, but it does illustrate relationships that are interesting to query, and it's easy to relate to when you're learning SQL. We explain the requirements next and discuss their shortcomings at the end of this section.

Consider the following requirements list:

  • The university offers one or more programs.
  • A program is made up of one or more courses.
  • A student must enroll in a program.
  • A student takes the courses that are part of her program.
  • A program has a name, a program identifier, the total credit points required to graduate, and the year it commenced.
  • A course has a name, a course identifier, a credit point value, and the year it commenced.
  • Students have one or more given names, a surname, a student identifier, a date of birth, and the year they first enrolled. We can treat all given names as a single object-for example, "John Paul."
  • When a student takes a course, the year and semester he attempted it are recorded. When he finishes the course, a grade (such as A or B) and a mark (such as 60 percent) are recorded.
  • Each course in a program is sequenced into a year (for example, year 1) and a semester (for example, semester 1).

The ER diagram derived from our requirements is shown in Figure 4-12. Although it is compact, the diagram uses some advanced features, including relationships that have attributes and two many-to-many relationships.

In our design:

  • Student is a strong entity, with an identifier, student_id, created to be the primary key used to distinguish between students (remember, we could have several students with the same name).
  • Program is a strong entity, with the identifier program_id as the primary key used to distinguish between programs.
  • Each student must be enrolled in a program, so the Student entity participates totally in the many-to-one EnrollsIn relationship with Program. A program can exist without having any enrolled students, so it participates partially in this relationship.

Figure 4-12. The ER diagram of the university database

  • A Course has meaning only in the context of a Program, so it's a weak entity, with course_id as a weak key. This means that a Course is uniquely identified using its course_id and the program_id of its owning program.
  • As a weak entity, Course participates totally in the many-to-one identifying relationship with its owning Program. This relationship has Year and Semester attributes that identify its sequence position.
  • Student and Course are related through the many-to-many Attempts relationships; a course can exist without a student, and a student can be enrolled without attempting any courses, so the participation is not total.
  • When a student attempts a course, there are attributes to capture the Year and Semester, and the Mark and Grade.
User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

University management system ER diagram?

university management system


ER diagram for a university management system?

This is not available


What are the differences between EER diagrams and ER diagrams?

Extended ER diagram is a variant of ER diagram. EER include ER diagram + hierarichal concept. Extended ER diagram is also called Enhance ER diagram(EER).


What is an example of an ER diagram for an admission system?

An example of an ER diagram for an admission system could include entities such as Student, Course, Department, and Instructor. The Student entity would have attributes like student ID and name, while the Course entity would have attributes like course ID and title. Relationships would be established between entities, such as a student enrolling in a course, which would be represented by a many-to-many relationship between Student and Course entities. The ER diagram would visually represent these entities, attributes, and relationships to illustrate the structure of the admission system.


Drow a er diagram of a supermarket?

supermarket (ER-Diagram)


An ER diagram for a website?

I 'm need ER diagram for websit news


Where can you find an ER diagram on online shopping?

ER Diagram of online shopping


How can you make Er diagram of online shopping?

Er diagram of on line shopping


How do you draw a ER diagram for an automobile industry?

How do you draw a ER diagram for a automobile industry?


How do you draw the ER Diagram for online tour site?

draw the er diagram for tours


How do you draw the ER diagram of bus reservation?

You also can draw your ER diagram by so many ways. A software called Edraw is a better software to draw the ER diagram. This one has some ready-to-use ER diagrams templates conceptdraw.com/How-To-Guide/er-diagram


Examples of ER diagram for car company?

what is example of ER diagram for rental car company ?