Question

A university is made up of students and professors.  Students enroll in classes.  Professors teach classes.  Each student has...

A university is made up of students and professors.  Students enroll in classes.  Professors teach classes.  Each student has a unique student ID number, a name, phone number, and a major.  Each professor has a unique employee ID number, a name, phone number, and department name.  Draw an ER (Entity-Relationship) Diagram for this scenario.  Include the proper symbols and connecting lines for all entities, attributes, and relationships.

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

Homework Answers

Answer #1

If you have any questions comment down. Please don't simply downvote and leave. If you are satisfied with answer, please? upvote thanks

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 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....
UC State University is developing a homework database to track assignments, classes, professors, and departments (History,...
UC State University is developing a homework database to track assignments, classes, professors, and departments (History, English, etc). Each professor, the homework database must produce their first name, middle initial, last name, title (Mrs,etc), email address, and telephone number. Each course has one professor and the homework database should save a meeting time, room number, description, and name. Each assignment has assigned date, due date, and assignment description. This homework app must also remember which course has which assignment and...
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)....
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,...
The database is to handle the bookings in a company that arranges one-day guided group tours...
The database is to handle the bookings in a company that arranges one-day guided group tours from the different hotels in a resort town to various destinations. Specific details are: Every hotel is described by: A unique hotel name, address, and phone number. Every destination is described by: A unique destination name, and type. Every guide is described by: A unique guide id, name, and all the languages that he/she speaks. Every tour is described by: A date, number of...
You are hired to design a database for a fitness center. As the fitness center is...
You are hired to design a database for a fitness center. As the fitness center is expanding with more than one branch, they want to create a database to keep track of its customers, facilities and employees. Each branch has a unique id and address (building number, street, district, and city). A branch may have more than one facility (e.g. swimming pool, spa, etc.). Each facility must belong to only one branch, and the information for a facility is name...
Consider the following description below: In a company, each employee belongs to one department. One of...
Consider the following description below: In a company, each employee belongs to one department. One of the employees of a department is the Head of Department. Each department occupies one or more offices. An office can be occupied by no department or by one department. An employee is identified by an id and has a name. A department is identified by its name. An office is identified by its office number. Draw a class diagram for the above scenario to...
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...
Complete ER Diagrams for each scenario given (ignore the fact that the problem says "class diagram"...
Complete ER Diagrams for each scenario given (ignore the fact that the problem says "class diagram" - do an ER diagram like we've been doing in class).   8.99 (do a, b, and c) 8.99 a. Draw a class diagram, showing the relevant classes, attributes, operations, and relationships for each of the following situations (if you believe that you need to make additional assumptions, clearly state them for each situation): a. A company has a number of employees. The attributes of...
a gymnastic school with hundreds of students. It needs a database to track all the different...
a gymnastic school with hundreds of students. It needs a database to track all the different classes that are being offered, who is assigned to teach each class, and which students attend each class. Also, it is important to track the progress of each student as they advance. Design a database for the following requirements: Students are given a student number when they join the school. This is stored along with their name, date of birth, and the date they...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT