Create an ER diagram for each of the following descriptions: (a) Each company operates four...

Create an ER diagram for each of the following descriptions:

(a) Each company operates four departments, and each department belongs to one company.

(b) Each department in part (a) employs one or more employees, and each employee works for one department.[with a startdate]

(c) Each of the employees in part (b) may or may not have one or more dependents, and each dependent belongs to one employee.

(d) Suppose company with attributes cnumber, cname, caddress, President.
department with attributes dname, dnumber, location.
employe with attributes ename, ssn(social security number), sex, address, salary, birthdate.
dependent with attributes dpNmae, sex, birthdate, relationship(to the employee).

(e) Represent all the ER diagrams described in (a), (b), (c), and (d) as a single ER diagram.

Solutions

Expert Solution

If you have any doubts, please give me comment...

venereology answered 1 year ago

Next > < Previous

Related Solutions

1- [4 Marks] Create an ER diagram for a movie theater company. The company had its...

1- [4 Marks] Create an ER diagram for a movie theater company. The company had its registered number and name of the company. The company may own many theaters, and each theater has unique Id, name, and address. Every theater must be owned by one or more companies. In each theater, multiple movies can be played. However, each movie may be played in one theater only. A movie can be played on one or multiple screens; every screen has id...

Create an ER diagram for the requirements below. - Parts have a unique number, name, and...

Create an ER diagram for the requirements below. - Parts have a unique number, name, and production year. - Car company has a unique number, name and country information -Automakers make multiple cars. It has a serial number and a name. but, There can be no more than two companies making one car. -Parts are used in many cars. When a part is used in a car, Save the part usage date and quantity information.

Create a database and design an ER diagram for the given question. Must link the related...

Create a database and design an ER diagram for the given question. Must link the related tables then implement the design using MySQL. Insert at least 5 records. Ensure that the data to be added are related to other tables. Follow this format in creating the database and table: Database format: databasename_yourname Table format: tablename_yourname QUESTION: Company ABC has the following business rules. A department employs many employees, but each employee is employed by only one department. A division operates...

I am doing a project and need an ER diagram, as well as some, create table...

I am doing a project and need an ER diagram, as well as some, create table statements in SQL. Here is what I have so far. My database will be a hospital management system. It will be able to keep track of patients and doctors, as well as each of their attributes, to better help organize the hospital's data. Each patient and doctor will be searchable via an id, and the user will be able to run reports as well....

Using WORKBENCH: 1. Create the database below via an ER Diagram in Workbench (take screen shots...

Using WORKBENCH: 1. Create the database below via an ER Diagram in Workbench (take screen shots of the diagram) 2. Go to the database table view and take a screen shot of the table(s) 3. Go to the data entry tool and enter at least three lines of data (in each table). Take screen shots. Create a database that is in third normal form for the following: You are a nerd and have decided to organize your comic books in...

Draw the diagram (ER / MR / UML) for a database containing the following characteristics: •...

Draw the diagram (ER / MR / UML) for a database containing the following characteristics: • Presence sensor that stores presence information with its timestamp and its location. • Distance sensor that saves distance information with its timestamp and its location. • An actuator of a switch that energizes a bulb, where the record of its been with your timestamp and your location. • An actuator of a motor that opens a door, where the record of its been with...

Given the business rule below. Draw the Data directories for each entities & ER Diagram. A...

Given the business rule below. Draw the Data directories for each entities & ER Diagram. A DOCTOR can be scheduled for many APPOINTMENTS, but may not have any scheduled at all. Doctor has the attributes such as DoctorID, Firstname, & Lastname. Appointment has attributes such as AppointmentID, Date & Reason. A PATIENT can schedule one or more appointments. Patient entity has attributes such as PatientID, PatientName & Address. One appointment is scheduled with exactly one patient. An appointment must generate...

Write EBNF descriptions for the following: • a Java For each statement Assume that EBNF descriptions...

Write EBNF descriptions for the following: • a Java For each statement Assume that EBNF descriptions for statement(s), type, array, white space are given. (statmnts, type, array, and whitespace respectively) You have to create EBNF descriptions for For each statement and also variable. Use the following Java variable naming rules to create EBNF description for variable. o All variable names must begin with a letter of the alphabet, an underscore ( _ ) , or a dollar sign ( $...

Select the correct term for each of the following descriptions. Descriptions Terms This theory argues that...

Select the correct term for each of the following descriptions. Descriptions Terms This theory argues that there is no optimal dividend policy because a firm’s dividend policy does not affect the value of the firm. Stock dividend According to this theory, an announced dividend payment that exceeds investors’ expectations is interpreted to be “good” news and should be expected to increase the price of the firm’s common stock, whereas an announced dividend that is less than investors’ expectations is...

Select the appropriate term associated with a bank reconciliation for each of the following descriptions. Descriptions...

Select the appropriate term associated with a bank reconciliation for each of the following descriptions. Descriptions Terms a. Cash receipts received by the company but not yet recorded by the bank. b. Fees imposed by the bank to the company for providing routine services. c. Checks written to the company that are returned by the bank as not having adequate funds. d. Checks written by the company but not yet recorded by the bank. e. Money earned on the average...

Subjects