create an ER table ManufacturerA manufacturing company produces products. The following product information is stored:product name, product ID and quantity on hand. These products are made up of manycomponents. Each component can be supplied by one or more suppliers. The followingcomponent information is kept: component ID, name, description, suppliers who supply them,and products in which they are used.Assumptions●●●●A supplier can exist without providing components.A component does not have to be associated with a supplier.A component does not have to be associated with a product. Not all components areused in products.A product cannot exist without components.

ER Diagram:An ER model is also known as an entity-relationship model. The level of this data model…

Answered: create an ER table

Engineering

Computer Science

create an ER table

Operations Research : Applications and Algorithms

4th Edition

ISBN:9780534380588

Author:Wayne L. Winston

Publisher:Wayne L. Winston

Chapter17: Markov Chains

Section: Chapter Questions

Problem 14RP

See similar textbooks

Similar questions

Read the following scenario and answer the questions given bellow.• A car rental company has its offices in three major cites of the area. Acostumer once registered with the company, can avail its services from anynearby office. Every office keeps record of the vehicles, their drivers andrenting details. Salaries of administrative staff are controlled at a single sitewhile the drivers are paid (according to the services they provide) from their local office. Rates for famous tourism spots are fixed (with a slight difference for different vehicles), while other spots are charged according to the mileage covered. 1. Identify the entities involved in the database designed for thecompany.2. Draw GCS for the system.3. Give details of any of the relations replicated on more than one sites
The objective is to create a system that allows you to completely manage the functions of thecompany through an optimal design of the data model, to be adapted to a system connected to aSQL database. StatementThe pharmacy chain “Recetas Rayos X” needs a system to manage information about its operations, such as the purchase, sale and administration of medications, other patients and who prescribed them.a medicine. The information that must be stored is the following:1. Patients are identified by the RUT and the name, surname, date of birth, email,address, several telephone numbers and pension system.2. There are various health provisions, both social and private, and they are correctly codified.3. Doctors are identified by the RUT. For each doctor you have to store the first name, last name,date of birth, specialties and years of practice.4. There are various specialties which are adequately codified.5. Each pharmaceutical company is identified by a code, the name and a telephone…
The objective is to create a system that allows you to completely manage the functions of thecompany through an optimal design of the data model, to be adapted to a system connected to aSQL database. StatementThe pharmacy chain “Recetas Rayos X” needs a system to manage information about its operations, such as the purchase, sale and administration of medications, other patients and who prescribed them.a medicine. The information that must be stored is the following:1. Patients are identified by the RUT and the name, surname, date of birth, email,address, several telephone numbers and pension system.2. There are various health provisions, both social and private, and they are correctly codified.3. Doctors are identified by the RUT. For each doctor you have to store the first name, last name,date of birth, specialties and years of practice.4. There are various specialties which are adequately codified.5. Each pharmaceutical company is identified by a code, the name and a telephone…
a) Suppose that You have gotten a job planning databases for the European Union. Yourfirst on job assignment is to help the various countries maintain information about theirinhabitants. Your model should capture the following information:• In each country, there are provinces, which contain towns. There cannot be twoprovinces with the same name in a single country. Similarly, there cannot be two townswith the same name in a single province.• People live in towns. Men and women work in a town. Children learn in a school in atown.• A person can be a man, a woman, or a child, and has a first-name, last-name, id, andbirthday.Children are any people under the age of 18.• A man can be married to a woman (polygamy is not allowed, i.e., one man can bemarried only to one woman). Although the Pope strongly disapproves, divorce, andsubsequent remarriage, is possible.• For each marriage, store the date of the marriage and information about who are thechildren of the married couple. You should…
Consider the following scenario and draw an E-R diagram for Cathay airlines. Cathay Airlines stores details about an airline’s fleet, flights, and seat bookings. The airline has one or more airplanes and an airplane has a model number, a unique registration number, and the capacity to take one or more passengers. An airplane flight has a unique flight number, a departure airport, a destination airport, a departure date and time, and an arrival date and time. Each flight is carried out by a single airplane. A passenger has given names, a surname, address and a unique email address. . Each address is made up of a street, a city and a postcode. A passenger can book a seat on a flight.
Consider the following information for a company which wishes to keep track of certain information about itssales staff and its products and how the products are selling. Specifically, the company has determined that it isinterested in the following attributes.Employee ID Product NumberEmployee Name Product NameBase Salary Unit PriceCommission Percentage Quantity (of product sole)Department Number Office NumberDepartment Name Office SizeManager ID Office WindowManager Name After discussion with the company, it was determined that the following functional dependencies hold for theproposed database.Employee ID -> Employee NameEmployee ID -> Base SalaryEmployee ID -> Commission…
Computer Science Draw the CONTEXT Digram for the given case study below: “UAETourism & Travel Agency LLC” from this year on, the tickets will be sold in three distinct ways: traditionally, i.e. by the two events agencies, in electronic format directly on the festival website, and through SBB. All parties will have access to the same unique tickets database of the new system, to avoid double selling. A partnership with the SBB railway company needs to be set up, such that SBB can sell combi-tickets including both the festival admission fee and the train ride to the festival venue at reduced price, from anywhere in Dubai. This way, more music fans would have easier and cheaper access to UAETourism . Moreover, the system will have to be extended to support not only Arabic, but also English, French and Italian. Since tickets will also be sold online, SecurePayment Inc. will be contracted to provide and ensure the security of the online payment service. The UAETourism event manager…
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.
Create the ER diagram and the database schema: Pick and Shovel Construction Company is a multi-state building contractor specializing inmedium-priced town homes. Assume that Pick and Shovel’s main entities are its customers, employees,projects, and equipment. A customer can hire the company for more than one project, and employeessometimes work on more than one project at a time. Equipment, however, is assigned to only one projectat a time.
Draw an ER diagram for the following domain of criminal court cases. Each judge has a list ofoutstanding cases over which he will preside. Only one judge presides per case. For each case one prosecuting counsel is appointed to represent the Department of Public Prosecutions. Cases are scheduled at one Crown Court for an estimated duration from a given start date. A case can try more than one crime. Make any assumption that you need for the relationship cardinality if you feel it is missing. Note that for this ER the attributes for the entities are missing. You do not have to defineattributes that has not explicitly mentioned in this question
Consider the following scenario A student has a name, which consists of a given name and a family name, and a student IID. Each student is uniquely identified by his/her student ID.A course has a subject and a course ID. For each course, we want to record the number of students taking that course and the type of equipment being used for the course. A course is uniquely identified by its course ID.A student can be enrolled in an arbitrary number of courses, and an arbitrary number of students can be enrolled in a course. For each course in which they are enrolled students receive a lab mark and an exam mark.A course cannot exist if there is no student enrolled in it.A school is distinguished by the honour's degree that it awards. We also want to record to which faculty a school belongs. A student is registered with at most one school, while a school can have an arbitrary number of students. Questions a) Draw an Entity Relationship Diagram b) translate the ERD into a relational data…
Draw an ER diagram and then map it into a relational schema(database) for the following scenario.• For each MEMBER we keep track of the unique MemdID, a well as Name, Zip, and the Datethe membership was paid.• For each MEMBERSHIP type we keep track of the unique Mid, as well as MName and Price• For each PASS CATEGORY we keep track of the unique PassCatID, as well as PCName andPrice• For each ONE DAY PASS we keep track of the unique PassID and Date• For each MERCHANDISE item we keep track of the unique MrchID, as well as Name andPrice• For each sale TRANSACTION we keep track of the unique Tid and Date• Each member pays for exactly one membership type; each membership type has at leastone member but can have many members.• Each member can buy many day passes but does not have to buy any, each day pass wasbought by exactly one member• Each day pass belongs to exactly one pass category; a pass category can have manyindividual day passes issued for it but does not have to have any. • Each…