DRAWING E/R DIAGRAM ANDRELATIONAL SCHEMA Example 2: UNIVERSITYConsider the following set of requirements for a UNIVERSITY database that is used tokeep track of students' transcripts.a) The university keeps track of each student's name, student number, SocialSecurity number, current address and phone number, permanent address andphone number, birth date, sex, class (freshman, sophomore, ., graduate), majordepartment, minor department (if any), and degree program (B.A., B.S., .,Ph.D.). Some user applications need to refer to the city, state, and ZIP Code of thestudent's permanent address and to the student's last name. Both Social Securitynumber and student number have unique values for each student.b) Each department is described by a name, department code, office number, officephone number, and college. Both name and code have unique values for eachdepartment.c) Each course has a course name, description, course number, number of semesterhours, level, and offering department. The value of the course number is uniquefor each course.d) Each section has an instructor, semester, year, course, and section number. Thesection number distinguishes sections of the same course that are taught duringthe same semester/year; its values are 1, 2, 3, ., up to the number of sectionstaught during each semester.e) A grade report has a student, section, letter grade, and numeric grade (0, 1, 2, 3,or 4).

It is defined as the logical view of the system from data perspective which consists of these…

Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students' transcripts. a) The university keeps track of each student's name, student number, Social Security number, current address and phone number, permanent address and phone number, birth date, sex, class (freshman, sophomore, ., graduate), major department, minor department (if any), and degree program (B.A., B.s., ., Ph.D.). Some user applications need to refer to the city, state, and ZIP Code of the student's permanent address and to the student's last name. Both Social Security

Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students' transcripts. a) The university keeps track of each student's name, student number, Social Security number, current address and phone number, permanent address and phone number, birth date, sex, class (freshman, sophomore, ., graduate), major department, minor department (if any), and degree program (B.A., B.s., ., Ph.D.). Some user applications need to refer to the city, state, and ZIP Code of the student's permanent address and to the student's last name. Both Social Security

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Q: Question 6 In order to make it easier to compare the relation scheme diagram to the UML diagram, we…

A: In order to make it easier to compare the relation scheme diagram to the UML diagram, we (check all…

Q: When working with database entity relationship modeling, should the cardinality between entities be…

A: Cardinality: The maximum or minimum number of elements allowed on each side of the relationship in…

Q: What type of relationship in the conceptual model is converted to an entity in the logical database…

A: Conceptual ERD models the business objects that should exist in a system and the relationships…

Q: Create an airline database. Customers and their bookings must be kept in the database, as well as…

A: Answer

Q: Design an E-R diagram for a database for an airlines system. The database must keep track of…

A: Among the so-called passenger service systems (PSS) are the airline reservation systems (ARS), which…

Q: How does a typical transaction identifier look like in a dimensional model?

A: In a dimensional model, a typical transaction identifier is a unique identifier assigned to each…

Q: Can you please help me in how I can turn the Entity Relationship diagram into a Logical Database…

A: An Entity-Relationship (ER) diagram is a visual representation of the entities (objects or concepts)…

Q: Database and design ERD diagram with notions Attached is the requirements in the first photo and I…

Q: Describe the most common way in which relationships in an E-R diagram are expresses in a…

A: ER diagram ER diagram is defined as the interconnection of entities and attributes how they are…

Q: Crow-foot symbol in a crow-foot diagram is depicted on a side of entity which is one only…

A: 1) Crow’s foot notations illustrate the relationship between entities in a crow’s foot diagram. 2)…

Q: Suppose you are going to design an instant messaging application called Telegraph. Telegraph is…

A: It is defined as a collection of information that is organized so that it can be easily accessed,…

Question

DRAWING E/R DIAGRAM AND

RELATIONAL SCHEMA

Example 2: UNIVERSITY
Consider the following set of requirements for a UNIVERSITY database that is used to
keep track of students' transcripts.
a) The university keeps track of each student's name, student number, Social
Security number, current address and phone number, permanent address and
phone number, birth date, sex, class (freshman, sophomore, ., graduate), major
department, minor department (if any), and degree program (B.A., B.S., .,
Ph.D.). Some user applications need to refer to the city, state, and ZIP Code of the
student's permanent address and to the student's last name. Both Social Security
number and student number have unique values for each student.
b) Each department is described by a name, department code, office number, office
phone number, and college. Both name and code have unique values for each
department.
c) Each course has a course name, description, course number, number of semester
hours, level, and offering department. The value of the course number is unique
for each course.
d) Each section has an instructor, semester, year, course, and section number. The
section number distinguishes sections of the same course that are taught during
the same semester/year; its values are 1, 2, 3, ., up to the number of sections
taught during each semester.
e) A grade report has a student, section, letter grade, and numeric grade (0, 1, 2, 3,
or 4).

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1 Introduction to ER Diagram

VIEW

Step 2 Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

What two pitfalls must we avoid when designing a schema with an ER diagram? redundancy incompleteness atomic design complex data types
I am learning ER diagrams learning one, many, one and only, zero or one, one or many, and zero or many for the cardinality rules to create databases with. Question: How can I make plans for a ProResume database and turn them into an ER diagram? Also, what ER diagram tools might you know of that are possibly free and nice to use with MySQL? This is the plan I have thus far; ENTITIES Employers: These will be the companies or organizations that are hiring. Attributes: Employer ID, Company Name, Location, Contact Information Customers: These will be the Job Applicants or Candidates. Attributes: Customer ID, Name, Contact Information, Education, Experience References: These will be the references from customers. Attributes: Reference ID, Name, Contact Information, Relationship to Customer Skills: Will be software and hardware skill of the customer. Attributes: Skill ID, Skill Name, Proficiency Level Employment Positions: These will be…
Draw an E-R diagram based on the following relational design.SeniorTeachers(teacherId, name, dept, division)TeachingAssistants(teacherId, name, dept, division).# These can be currently registered students who are employed part-time as teaching assistants,# or they can be PhD students who are employed full-time.Programmes(programmeCode, programmeName, dept, director)director → SeniorTeachers.teacherIdCourses(courseCode, courseName, credits, level, dept, division, ownedBy)ownedBy → Programmes.programmeCode# level is one of “first cycle” or “second cycle”.programmeCourses(programme, academicYear, studyYear, course, courseType)programme→ Programmes.programmeCodecourse → Courses.courseCode# studyYear is “1” or “2” for Master’s programmes and “1”, “2” or “3” for Bachelor’s programmes.# courseType is one of: “compulsory”, “compulsory-elective” or “elective”.# Programmes can include different courses in different academic years.# The same course could have a different courseType in different…
Draw three sequence diagrams for three use cases in the use case diagram attached. Please draw the sequence diagram similar to the attatched second photo.
Swing Jazz Club ERD Problem Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information. Remember the ERD will eventually turn into the design for a database from a top down view. Make sure you resolve any many to many conflicts. Label an identifier or primary key and all pertinent attributes given. If an attribute is not readily apparent from the user information, then make one up that makes sense for the particular entity. Therefore, all entities should end up with at least an identifier and another attribute that makes sense. You may use any of the approaches shown by the book, though the ER-Model and Crow’s foot are the most common. Make sure you show entities, relationships, cardinality, and optionality. Swing Jazz Club The Swing Jazz Club teaches swing and jazz dancing and offers both private and group lessons. Swing Jazz charges $60 dollars per hour for a private lesson and $10 dollars per hour for a group lesson.…
Draw an E-R diagram based on the following relational design.SeniorTeachers(teacherId, name, dept, division)TeachingAssistants(teacherId, name, dept, division).# These can be currently registered students who are employed part-time as teaching assistants,# or they can be PhD students who are employed full-time.Programmes(programmeCode, programmeName, dept, director)director → SeniorTeachers.teacherIdCourses(courseCode, courseName, credits, level, dept, division, ownedBy)ownedBy → Programmes.programmeCode# level is one of “first cycle” or “second cycle”.programmeCourses(programme, academicYear, studyYear, course, courseType)programme→ Programmes.programmeCodecourse → Courses.courseCode# studyYear is “1” or “2” for Master’s programmes and “1”, “2” or “3” for Bachelor’s programmes.# courseType is one of: “compulsory”, “compulsory-elective” or “elective”.# Programmes can include different courses in different academic years.# The same course could have a different courseType in different…