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.

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 2 years ago

Create an ER diagram, a Relational Schema, and tables with Data, based on the following requirements:...

Create an ER diagram, a Relational Schema, and tables with Data, based on the following requirements: The database will keep track of students and campus organizations. - For each student, we will keep track of his or her unique student ID, and his or her name and gender. - For each organization, we will keep track of its unique organization ID and the location. - Each student in the database belongs to at least one organization and can belong to...

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 ER diagram for the following: Emerging Electric wishes to create a database with the...

Draw the ER diagram for the following: Emerging Electric wishes to create a database with the following entities and attributes: (10) • Customer, with attributes Customer ID, Name, Address (Street, City, State, Zip Code), and Telephone • Location, with attributes Location ID, Address (Street, City, State, Zip Code), and Type (values of Business or Residential) • Rate, with attributes Rate Class and RatePerKWH After interviews with the owners, you have come up with the following business rules: • Customers can...

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

Create ER diagram for the following: A database has been designed for a Human Resources for...

Create ER diagram for the following: A database has been designed for a Human Resources for a school in the UK. The database includes records of the teachers and their holidays. The Dean of this school has the power to approve those holidays for all teachers in the school. For each teacher, Human Resources keeps track of the Teacher's ID, name, Cell phone number(s), total number of holidays for each year, number of unemployed holiday days remaining in the...

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

Company X database Create an ER Diagram using UML notation for the following tables, then write...

Company X database Create an ER Diagram using UML notation for the following tables, then write out in the Relational model. Company X is a manufacturing company that binds and sells books. They have hired you to create database to track their Employees, Products, customers and their orders. All employees work with book Binding, Only some are designated as Reps for customers. Reps may have many customers. But each customer can only have 1 rep. They count to record each...

Database: Our AD is Movie Theater. Create an ER diagram with the following entities: Staff, Ticket,...

Database: Our AD is Movie Theater. Create an ER diagram with the following entities: Staff, Ticket, Movie, Session, Hall, Seat, Director, Actor, Distributor, and Roles. AND also identify the type of relations between the entities with notations and explain why you used it. **Read the question carefully before you answer**

Question