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...
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.
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...
A certain airport authority wants to organize some of the data associated with the airport. The...
A certain airport authority wants to organize some of the data associated with the airport. The relevant information is as follows: Every airplane has a registration number and each airplane is of a specific model The airport accommodates a number of airplane models and each model is identified by a model number and has a capacity and weight Each airplane has an owner identified by name and contact phone number. A number of technicians work at the airport. You need...
A certain airport authority wants to organize some of the data associated with the airport. The...
A certain airport authority wants to organize some of the data associated with the airport. The relevant information is as follows: Every airplane has a registration number and each airplane is of a specific model The airport accommodates a number of airplane models and each model is identified by a model number and has a capacity and weight Each airplane has an owner identified by name and contact phone number. A number of technicians work at the airport. You need...
Draw the E-R diagram (5 pts) and petri-net (7 pts) for the following requirements in a...
Draw the E-R diagram (5 pts) and petri-net (7 pts) for the following requirements in a college library: There are two types of books: regular and reserved, and two types of users: students and faculty members. A student can check out a regular book for 1 month, while a faculty member can borrow one for 2 months. A late return will incur a fine measured by the number of days. A reserved book can be checked out by any user...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT