A company database needs to store information about employees (identified by ssn, with salary and phone as attributes), departments (identified by dno, with dname and budget as attributes), and children of employees (with name and age as attributes). Employees work in departments; each department is managed by an employee; a child must be identified uniquely by name when the parent (who is an employee; assume that only one parent works for the company) is known. We are not interested in information about a child once the parent leaves the company. Draw an ER diagram that captures this information.

A company database needs to store information about employees (identified by ssn, with salary and phone as attributes), departments (identified by dno, with dname and budget as attributes), and children of employees (with name and age as attributes). Employees work in departments; each department is managed by an employee; a child must be identified uniquely by name when the parent (who is an employee; assume that only one parent works for the company) is known. We are not interested in information about a child once the parent leaves the company. Draw an ER diagram that captures this information.

Principles of Information Systems (MindTap Course List)

12th Edition

ISBN:9781285867168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter5: Database Systems And Applications

Section: Chapter Questions

Problem 4PSE: Using a graphics program, develop an entity-relationship diagram for a database application for an...

See similar textbooks

Similar questions

Draw an E-R diagram for the description below. Suppose that you are asked to model a database including all pharmaceutical companies, their drugs, and all pharmacies. Each pharmaceutical company is identified by its name and has a phone number. For each drug, the trade name (e.g., Acetaminophen) and formula must be recorded. Each drug is sold by only one pharmaceutical company, and the trade name identifies a drug uniquely from among the products of that company. If a pharmaceutical company stops production, we do not need to keep track of its products any longer. Each pharmacy has an identifier name, address, and phone number. Each pharmacy sells several drugs. A drug could be sold at several pharmacies, and the price could vary from one pharmacy to another.
Suppose you are asked to design a club database system based on the following information. Each student has a unique student id, a name, and an email; each club has a unique club id, a name, a contact telephone number, and has exactly one student as its president. Each student can serve as a president in at most one of the clubs, although he/she can be the members of several clubs. Clubs organize activities and students can participate in any of them. Each activity is described by a unique activity id, a place, a date, a time and those clubs that organize it. If an activity is organized by more than one club, different clubs might contribute different activity fees.QuestionDraw an E-R diagram for the system according to the above description.
A taxi company would like to provide an online service for customers to book a trip and for taxi drivers to check their upcoming trips. A database needs to be created to store customer data (name, address, email, telephone number) and trip information (pick up and drop off address and pick up time and date). Furthermore, your database should contain driver information (name and license plate). Each trip must be assigned to exactly one driver (and trips for a driver must not overlap). Customers who are not registered yet need to register (providing their address, phone number, email address, and credit card information). A registered customer should be able to book a trip, i.e. provide the pick-up address and time as well as the drop-off address via a graphical user interface. Customers should also be able to view their trips and cancel them if needed. All these operations are only possible after a customer signs in (which means they must be registered). Each new trip must be confirmed…
A taxi company would like to provide an online service for customers to book a trip and for taxi drivers to check their upcoming trips. A database needs to be created to store customer data (name, address, email, telephone number) and trip information (pick up and drop off address and pick up time and date). Furthermore, your database should contain driver information (name and license plate). Each trip must be assigned to exactly one driver (and trips for a driver must not overlap). Customers who are not registered yet need to register (providing their address, phone number, email address, and credit card information). A registered customer should be able to book a trip, i.e. provide the pick-up address and time as well as the drop-off address via a graphical user interface. Customers should also be able to view their trips and cancel them if needed. All these operations are only possible after a customer signs in (which means they must be registered). Each new trip must be confirmed…
A taxi company would like to provide an online service for customers to book a trip and for taxi drivers to check their upcoming trips. A database needs to be created to store customer data (name, address, email, telephone number) and trip information (pick up and drop off address and pick up time and date). Furthermore, your database should contain driver information (name and license plate). Each trip must be assigned to exactly one driver (and trips for a driver must not overlap). Customers who are not registered yet need to register (providing their address, phone number, email address, and credit card information). A registered customer should be able to book a trip, i.e. provide the pick-up address and time as well as the drop-off address via a graphical user interface. Customers should also be able to view their trips and cancel them if needed. All these operations are only possible after a customer signs in (which means they must be registered). Each new trip must be confirmed…
A taxi company would like to provide an online service for customers to book a trip and for taxi drivers to check their upcoming trips. A database needs to be created to store customer data (name, address, email, telephone number) and trip information (pick up and drop off address and pick up time and date). Furthermore, your database should contain driver information (name and license plate). Each trip must be assigned to exactly one driver (and trips for a driver must not overlap). Customers who are not registered yet need to register (providing their address, phone number, email address, and credit card information). A registered customer should be able to book a trip, i.e. provide the pick-up address and time as well as the drop-off address via a graphical user interface. Customers should also be able to view their trips and cancel them if needed. All these operations are only possible after a customer signs in (which means they must be registered). Each new trip must be confirmed…
Design an ER diagram for keeping track of information about votes taken in the U.S. House of Representatives during the current two-year congressional session. The database needs to keep track of each U.S. STATE’s Name (e.g., Texas, New York, California) and includes the Region of the state (whose domain is {Northeast, Midwest, Southeast, Southwest, West}). Each CONGRESSPERSON in the House of Representatives is described by their Name, and includes the District represented, the StartDate when they were first elected, and the political Party they belong to (whose domain is {Republican Democrat, Independent, Other}). The database keeps track of each BILL (i.e., proposed law), and includes the BillName, the DateOfVote on the bill, whether the bill PassedOrFailed (whose domain is {YES,NO}), and the Sponsor (the congressperson(s) who sponsored--i.e., proposed--the bill). The database keeps track how each congressperson voted on each bill (domain of vote attribute is {Yes, No, Abstain,…
A dentist’s office needs to keep information about patients, the number of visits they make to the office, work that must be performed, procedures performed during visits, charges and payments for treatment, and laboratory supplies and services. Assume there is only one dentist, so there is no need to store information about the dentist in the database. There are several hundred patients. Patients make many visits, and the database should store information about the services performed during each visit and the charges for each of the services. There is a standard list of charges, kept outside the database. The office uses three dental laboratories that provide supplies and services, such as fabricating dentures. Draw a complete E-R diagram for this example.
Draw the ER diagram based on the following specification. A tutorial school is using a database to manage information about teachers, courses, and students. Each teacher is identified by staff_id, has a name, an email address, and a phone number. Each student is identified by student_id, has a name, an email address, and a registration date. Each course is identified by course_id, year, and semester. In addition, each course has a name. Each course is associated with multiple lessons. A lesson has a lesson number, a location, a date, a start-time, and an end-time. Lesson numbers are sequentially numbers, starting from 1, generated separately for each course. Each teacher teaches at least one course. Each student takes at least one course. Each course is taught by one teacher. Each course can be taken by many students.
Consider a MOVIE database in which data is recorded about the movie industry. The data requirements are summarized as follows: Movies are identified by their title and year of release. They have a length in minutes. They also have a studio that produces the movie and are classified under one type (such as horror, action, drama, etc). Movies are directed by one or more directors and have one or more actors. Actors are identified by their names and date of birth and act in one or more movies. Each actor has a role in the movie. Directors are also identified by their names and date of birth. Each director has a rank value and direct one or more movies. Studios are identified by their names and have an address. The address contains building number, street name, and city name. They produce one or more movies. Design an Entity-Relationship diagram for the movie database.
Consider a MOVIE database in which data is recorded about the movie industry. The data requirements are summarized as follows: -- Each movie is identified by title and year of release. Each movie has a length in minutes and a rating (e.g., G, PG, or R). Each has a production company, and each is classified under one or more genres(such as horror, action, drama, and so forth). Each movie has one or more directors and one or more actors appear in it. Each movie also has a plot outline. Finally, each movie has zero or more quotable quotes, each of which is spoken by a particular actor appearing in the movie. An actor may have multiple quotes from one movie. -- Actors are identified by name and date of birth and appear in one or more movies. Each actor has a role in the movie, i.e., the character he or she plays. -- Directors are also identified by name and date of birth and direct one or more movies. -- Production companies are identified by name and each has an address. A production…
Consider a MOVIE database in which data is recorded about the movie industry. The data requirements are summarized as follows:  Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classified under one or more genres (such as horror, action, drama, and so forth).  Each movie has one or more directors and one or more actors appear in it. Each movie also has a plot outline. Finally, each movie has zero or more quotable quotes, each of which is spoken by a particular actor appearing in the movie.  Actors are identified by name and date of birth and appear in one or more movies. Each actor has a role in the movie.  Directors are also identified by name and date of birth and direct one or more movies. It is possible for a director to act in a movie (including one that he or she may also direct).  Production companies are identified by name and each has an address. A production company produces one or more…