Question

Design an E-R diagram to model a college described below: ● There are several departments in...

Design an E-R diagram to model a college described below:

● There are several departments in a college, and each of them has a unique name, one or more telephone numbers, and an address.

● Each department gives some number of courses. Each course has a course number which can be used to identify a course only inside of the same department. Each course has its schedule and a certain number of credits. Each course is held in some location in the campus, and uses 1 or more textbooks.

● Students are identified by their SSN, other information such as name, date of birth, and age are also recorded. Each student belongs to one department. Students take courses, and get scores for the courses they are taking.

● Each course is instructed by one and only one professor. Professors are also identified by their SSN, other information such as name, date of birth and age are still recorded. Each professor belongs to one or more departments. Draw an E-R diagram for the database. Primary keys should be specified in the diagram.

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

Homework Answers

Answer #1

Thank you. Please give an upvote. If any queries or changes needed please comment will respond ASAP!!!!

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
Design ER diagram to capture the information below and explain fully your answer: The University has...
Design ER diagram to capture the information below and explain fully your answer: The University has to create a database. In design stage the committee formed the following description: “The research activity at the University is organized as series of projects: Each project has project number, budget, funding organization, staring date and completion date. Each project has a PI who is full time faculty at the university. Each project has only one PI, but can have one or more Co-PI...
. Design an ER-diagram for a bank that implements the following requirements. The database you design...
. Design an ER-diagram for a bank that implements the following requirements. The database you design should store information about customers, accounts, branches and employees • Customer: Customers are identified by their SSN. For each customer we store a name, multiple phone numbers (one or more), and an occupation. • Account: Accounts are identified by an account number and the branch they belong to. For each account we store a balance and the type of account (e.g., savings). – An...
1.Consider the following (normalized) relational model (primary keys are underlined, foreign keys are in italics). EMPLOYEE(SSN,...
1.Consider the following (normalized) relational model (primary keys are underlined, foreign keys are in italics). EMPLOYEE(SSN, ENAME, EADDRESS, SEX, DATE_OF_BIRTH, SUPERVISOR, DNR) S U P E R V I S O R : foreign key refers to SSN in EMPLOYEE, NULL value allowed D N R : foreign key refers to DNR in DEPARTMENT, NULL value not allowed DEPARTMENT(DNR, DNAME, DLOCATION, MGNR) MGNR: foreign key refers to SSN in EMPLOYEE, NULL value not allowed PROJECT(PNR, PNAME, PDURATION, DNR) DNR: foreign...
Draw an ER Diagram for the following enterprise: A publication (which is either a book or...
Draw an ER Diagram for the following enterprise: A publication (which is either a book or a recording, but not both) is identified by its catalog number, and it additionally has a title. Every publication is produced by a publisher on some date, where the date consists of a month and a year. A publisher, identified by name, has offices in one or more cities. A publisher may be owned by another publisher. A publisher may own several other publishers....
A company consists of departments and employees. A department has responsibility for zero, one or more...
A company consists of departments and employees. A department has responsibility for zero, one or more projects. A company has: name, address and telephone. A department has name. A project has name. An employee has name, address, a social security number (SSN) and is participating in zero, one or more projects. Let the E-R diagram show: entities with attributes, relationships (with names) between the entities and cardinalities for the relationships.                               CR[15 Marks] Transform the E-R model into Relational model.
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...
Requirements: Based on the following information, draw an E-R diagram and a set of relations in...
Requirements: Based on the following information, draw an E-R diagram and a set of relations in 3rd normal form. Please indicate any assumptions that you have made. Wally Los Gatos, owner of Wally’s Wonderful World of Wallcoverings, has hired you as a consultant to design a database management system for his chain of three stores that sell wallpaper and accessories. He would like to track sales, customers, and employees. After an initial meeting with Wally, you have developed a list...
A University wants to create an ER Diagram for its business model in the blank space...
A University wants to create an ER Diagram for its business model in the blank space provided below It provides the following business rules. All the relationship and cardinalities need to be shown properly based on the business rules given below. Any assumptions you make should be clearly mentioned. Students can take many courses but will need to take at least one course. Courses will have at least one but likely many students. Student can rent up to 3 books...
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...
Exercise 2 - A UNIVERSITY A university consists of several faculties. Within each faculty there are...
Exercise 2 - A UNIVERSITY A university consists of several faculties. Within each faculty there are several departments. Each department may run a number of courses. All teaching staff is attached to departments, each staff member belonging to a unique department. (Note: see how many meanings you can assign to this ambiguous sentence). Every course is composed of sub-courses. Some sub-courses are part of more than one course. Staff may teach on many sub-courses and each sub-course may be taught...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT