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.

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

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
Using the Entities and Attributes you created for your business from the week 1 discussions. Show...
Using the Entities and Attributes you created for your business from the week 1 discussions. Show the tables and relationships resulting from your model in the form of an E/R diagram. You can use PPT, VISIO or any other graphical modeling tool to create your ER diagram. Some of the entities and attributes that I believe my company should have would be: Employees: First Name, Last Name, Employee Address, Employee Phone Number, Employee ID Number, Date of Birth, Social Security...
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....
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...
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...
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,...
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)....
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...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT