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.

Solutions

Expert Solution

E-R diagram:- E-R diagram is an entity relationship diagram which represents the relationship between the entities with their attributs.This is a model which defines how the entitiestheir attributs and their objects such as people their object and certain ideas are related to each other in single process. it works as step by step process flow. Some doffrenet symbols are used in E-R diagram to represents entity attributs and relationship between them such as :

1. Rectangle used to define the entity in E-R diagram.

2. Ellips used to represent objects or attributs.

3. Diamond shape used to represent relationship between entities.

venereology answered 1 year ago

Next > < Previous

Related Solutions

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...

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...

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....

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 entity relationship diagram to describe the data requirements of the system. Your client is...

create an entity relationship diagram to describe the data requirements of the system. Your client is a local real estate company that wants to automate some of their processes. Here is how some of the business is described: - In a real estate transaction, there is a buyer, a seller, a property, a purchase agreement and a real estate agent - A seller may have one or more properties to sell - A buyer wants to buy only one property...

Create an entity relationship diagram to describe the data requirements of the system. Here is how...

Create an entity relationship diagram to describe the data requirements of the system. Here is how some of the business is described: - In a real estate transaction, there is a buyer, a seller, a property, a purchase agreement and a real estate agent - A seller may have one or more properties to sell - A buyer wants to buy only one property - A purchase agreement is between the seller and the buyer, and only for one property...

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...

PYTHON First, create an ER random graph with N=100 and p=0.1 and name it G. Then...

PYTHON First, create an ER random graph with N=100 and p=0.1 and name it G. Then use the histogram() function to draw a histogram of the node degrees for the graph G. Don't worry about filling in "missing" values. Also print the mean, median, and mode of the node degree distribution. Execute this a few times. Note: while histogram(G.degree()) does draw a plot, that plot is not a histogram. Doing so will result in zero credit for this exercise.

1. [100] Create a C program for a number guessing game. Here are the requirements: a....

1. [100] Create a C program for a number guessing game. Here are the requirements: a. Your program generates a random number between -100 and 100 and keeps asking the user to guess the number until the user guesses it correctly. Your random number generator should be implemented as a C function which takes min and max values as input parameters and returns a random number between those values including the min and the max. b. If the user guesses...

Subjects