Question

home / study / engineering / computer science / computer science questions and answers / consider...

home / study / engineering / computer science / computer science questions and answers / consider the following set of requirements for a university database that is used to keep track ...

Question: Consider the following set of requirements for a UNIVERSITY database that is used to keep track o...

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, permanent address and phone, birthdate, 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 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, and college. Both name and code have unique values for each department. Each department has a faculty as a Chair to manage it.

(c) Each course has a course name, description, course number, number of semester hours, level, and offering department. The value of course number is unique for each course.

(d) Each section has an instructor, semester, year, course, and section number. The section number distinguishes different 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,

4 for F, D, C, B, A, respectively).

(f) The database keeps track of each faculty’s name, faculty ID, SSN, address, email and office location.

(g) Each course section will have a faculty assigned as instructor.

(h) Each College controls several departments. Each College is described by a name, college ID and college office location. A faculty assigned as a Dean to manage a college.

Draw an ER diagram based on the requirement described here.

Homework Answers

Answer #1

Hi,

Please find the ERD diagram below:

There are a lot of entities in the diagram. The columns are not shown.
Add the attributes for the tables with oval shapes for each table.

Note that some are composite attributes like
For example: studentName can be broken into firtName,LastName etc.

Primary Keys

Underline the primary keys.

  • SNumber is the primary key for the student.
  • DCode for the Department.
  • CollegeID for College.
  • CName for Course
  • facultyID for Faculty
  • StudentNumber,Semester,Year for Section. It's a partial key.

----------------------

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Consider the following set of requirements for a UNIVERSITY database that is used to keep track...
Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students’ transcripts. This is similar but not identical to the database shown in Figure 1.2: 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...
14.19. Suppose that we have the following requirements for a university database that is used to...
14.19. Suppose that we have the following requirements for a university database that is used to keep track of students’ transcripts: a. The university keeps track of each student’s name (Sname), student number (Snum), Social Security number (Ssn), current address (Sc_addr) and phone (Sc_phone), permanent address (Sp_addr) and phone (Sp_phone), birth date (Bdate), sex (Sex), class (Class) (‘freshman’, ‘sophomore’, … , ‘graduate’), major department (Major_code), minor department (Minor_code) (if any), and degree program (Prog) (‘b.a.’, ‘b.s.’, … , ‘ph.d.’). Both...
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,...
Can you please give me an example of an EER modeling diagram for the following description:...
Can you please give me an example of an EER modeling diagram for the following description: Consider a database in which weekly schedule of instructors is stored. For each instructor, name, title (Dr., Prof., Ms., Mr… ) email address, office phone number, semester, the day of week, time slot (e.g. 8 to 9, or 10:30 to 11:30…), availability of the instructor (lecture or lab or office hours), the location that instructor is available/ busy (class room number, lab number, office...
Draw an entity-relationship diagram that describes the following business environment. The city of Chicago, IL, wants...
Draw an entity-relationship diagram that describes the following business environment. The city of Chicago, IL, wants to maintain information about its extensive system of high schools, including its teachers and their university degrees, its students, administrators, and the subjects that it teaches. Each school has a unique name, plus an address, telephone number, year built, and size in square feet. Students have a student number, name, home address, home telephone number, current grade, and age. Regarding a student’s school assignment,...
SQL Data: you can just copy paste it into mysql to. CREATE DATABASE University;USE University; CREATE...
SQL Data: you can just copy paste it into mysql to. CREATE DATABASE University;USE University; CREATE TABLE Student (  sid INT PRIMARY KEY,  name VARCHAR(20) NOT NULL,  address VARCHAR(20) NOT NULL,  major CHAR(2)); CREATE TABLE Professor (  pid INT PRIMARY KEY,  name VARCHAR(20) NOT NULL,  department VARCHAR(10) NOT NULL); CREATE TABLE Course (  cid INT PRIMARY KEY,  title VARCHAR(20) NOT NULL UNIQUE,  credits INT NOT NULL,  area VARCHAR(5) NOT NULL); CREATE TABLE Transcript (  sid INT,  cid INT,  pid INT,  semester VARCHAR(9),  year YEAR,  grade CHAR(1) NOT NULL,  PRIMARY KEY (sid, cid, semester, year),  FOREIGN KEY (sid) REFERENCES Student...
Using LucidChart. Draw an entity - relationship diagram that describes the following business environment. The city...
Using LucidChart. Draw an entity - relationship diagram that describes the following business environment. The city of Chicago, IL, wants to maintain information about its extensive system of high schools, including its teachers and their university degrees, its students, administrators, and the subjects that it teaches. Each school has a unique name, plus an address, telephone number, year bu ilt, and size in square feet. Students have a student number, name, home address, home telephone number, current grade, and age....
Complete and correct answer is required to give full credit,thank you Consider the following set of...
Complete and correct answer is required to give full credit,thank you Consider the following set of requirements for an airline database that is used to keep track of flights, passengers, employees etc. for an airline. You will be graded not only on the correctness and completeness of the design but also on its quality. 1)     It is important to keep track of each passenger's name, address, phone number and meal preference (values could be vegetarian, sea-food, italian, anything). At times, it...
Read the following scenario and answer the question below: The Faculty Commons, a faculty run organization,...
Read the following scenario and answer the question below: The Faculty Commons, a faculty run organization, maintains a library of hard-to-find books on pedagogy and these books are available for faculty to borrow. The Faculty Commons would like to track this loan process including the books, the date a book is loaned out, the date a book is due to be returned, and the actual date the book is returned. One faculty member may borrow many books and one book...
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....
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT