To manage the materials of a factory, please give the E-R diagrams.Such entity sets are involved as below:Warehouse: with attributes as Number, area and telephoneAccessory : with attributes as number, Name, Specification, priceand descriptionSupplier: with attributes as Number, name, address, telephone andасcountProject : with attributes as number and budgetEmployee : with attributes as number, name and age The relationships among these entity sets are listed as below:A kind of accessory can be deposited in more than one warehouse. Awarehouse can accommodate more than one kind of accessory.There can be more than one employee in a warehouse, and a employeecan work in only one warehouse.Some employee can leader others.A supplier can supply various accessories to various projects. Aproject can use accessories supplied by various suppliers. A kind ofaccessory can be supplied by various supplier.*

The E-R diagram is given below:

To manage the materials of a factory, please give the E-R diagrams. Such entity sets are involved as below: Warehouse: with attributes as Number, area and telephone Accessory: with attributes as number, Name, Specification, price and description Supplier: with attributes as Number, name, address, telephone and асcount Project : with attributes as number and budget Employee : with attributes as number, name and age

To manage the materials of a factory, please give the E-R diagrams. Such entity sets are involved as below: Warehouse: with attributes as Number, area and telephone Accessory: with attributes as number, Name, Specification, price and description Supplier: with attributes as Number, name, address, telephone and асcount Project : with attributes as number and budget Employee : with attributes as number, name and age

Principles of Information Systems (MindTap Course List)

12th Edition

ISBN:9781285867168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter12: Systems Development: Investigation, Analysis, And Design

Section: Chapter Questions

Problem 12SAT: Data modeling is most often accomplished through the use of a(n) __________________. a....

See similar textbooks

Similar questions

Create an Entity/Relationship (ER) diagram to model the following scenario: An online magazine maintains a list that ranks restaurants based on reviews sent by the magazine's subscribers each restaurant is uniquely identified by an auto-generated code other attributes associated with a restaurant include its name, address, price range (1-3), rating (1-5 stars), and cuisine type there are many cuisine types and more can be added in the future subscribers are uniquely identified by their email and each have a name subscribers can review as many restaurants as they want, and a restaurant can be reviewed by many subscribers a review has a rating (1-5 stars), a date, and comments the system does not allow more than one review on the same date to the same restaurant and written by the same subscriber new reviews entered do not become immediately available as the magazine needs to check if the comments are appropriate and do not contain cursing or anything nasty/offensive once a new review…
Draw a complete ER-diagram for the following case. A lecturer (having an ID, name and room number) is responsible for organizing a number of course modules. Each module has a unique code and also a name and each module can involve a number of lectures who deliver part of it. A module is composed of a series of lectures and sometimes lectures a on a given topic can be part of more than one module. A lecture has a time room and date and is delivered by a lecturer and a lecturer may deliver more than one lecture. Students, identified by number and name, can attend lectures and a student must be registered for a number of modules. We also store the date on which the student first registered for that module. Finally, a lecturer acts as a tutor for a number of students and each student has only one tutor. Also show relational database schema including Primary and Foreign key constraints. (Please draw this on a paper)
Create an Entity Relationship Diagram using the following scenario: A restaurant chain has several store locations in a city (with a name and postal code stored for each), and each is managed by one manager. Managers manage only one store. Each restaurant location has its own unique set of menus. Most have more than one menu (e.g., lunch and dinner menus). Each menu has many menu items, and items can appear on multiple menus, and with different prices on different menus.
ENHANCE ENTITY RELATIOSHIP DIAGRAM The entity type PERSON has the following attributes: SSN, name, address (City/State/Zip), date of birth, age, and contact number. The entity also has the three subtypes: CAMPER, BIKER, AND RUNNER. Draw a separate diagram segment for each of the following situations: 1. At a given time, a person must be exactly one of three subtypes. 2. A person may or may not be one of these subtypes. However, a person who is one of these subtypes cannot at the same time be one of the other subtypes. 3. A person may or may not be the one of these subtypes. On the other hand, a person may be any two (or even three) of these subtypes at the same time. 4. At a given time, a person must be at least one of these subtypes.
Draw an E-R diagram to model the following situation. Be sure to include in your diagram all the relevant entities, attributes, relationships, functionality (N:1 or N:M) and whether any are mandatory. You can either draw the diagram by hand and submit it as a photograph/scan or you can create the diagram in a program with drawing tools (Word, Powerpoint etc.). Upload your diagram by the deadline. [HINT: There are 3 entities and 2 relationships in the model answer]. A bus depot includes a maintenance section that repairs faulty buses. Each bus is identified by its fleet number, its make, the year it was manufactured and its registration number. When a vehicle breaks down, a report is submitted describing the nature of the problem and the time when the incident occurred. These reports are consecutively numbered as they are received and include the time when the bus was returned to the depot for repair. One or more mechanics fix the bus. Mechanics are identified by their staff number,…
Draw a single ER diagram that represents the specifications listed below. Follow the process below to help you do this: Consider a model of an airport with planes, models of planes, test of planes, and technicians. Draw an ER diagram to represent these entities and their attributes. Planes have a unique registration number. Airplane Models are each identified by a model number (e.g., DC-80, A380, B747), and each have a capacity and a weight. Several technicians work at the airport. You need to store for each technician the name, phone number, address, and salary. The airport has a number of tests that are used regularly to ensure that airplanes are safe. Each test has a unique FAA number, a name, and a maximum possible score. Extend your ER diagram with relationships to represent the following information. Each airplane is of one specific model. Each technician is an expert on one or more plane models. His or her expertise may overlap with that of other technicians. Transport…
Transfer the following description into an ER Diagram: A company has one or more locations referred to as "Plants" (Plant-ID). Several plants are uniquely assigned to the same company code (CC-ID). Plants can have several storage locations (S-loc-#) in which the manufactured and purchased items are stocked, a storage location however, can only be assigned to one plant. A purchase organisation (PO-ID) can be assigned to several plants and a plant to several purchase organisations. A company code is related to one or more purchase organisations, the latter is uniquely related to a company code. A distribution channel (DC-#) can be assigned to several divisions (Div-ID), whereas a division is uniquely assigned to a distribution channel. A sales organisation (Sales-Org-ID) can have several distribution channels, whereas a distribution channel is uniquely assigned to a sales organisation. A company code can have several sales organizations. Sales organisations are assigned to one…
Draw an Entity relationship diagram (ER) for a university according to the following rules: ! -- For each student the university needs to keep track of: first name, last name, student id, address, phone no and their major. ?. -- The student id is identical for each student. } -- Each course has a number, name and credit. The course number is unique for each course. t -- Each department has a name, code and location. The code is unique for each department. Ş -- Each course may has one or more sections where each section is belong to only one course. 6 -- A department offers one or many courses. 7- Some courses have perquisite courses. 8- Each student could register in one or more courses. In your diagram you need to show the following: 1- The primary key for each entity. 2- The cardinality and participation between entities.
Draw an Entity Relationship Diagram for all of those below. Draw an ER diagram to represent information about students. A student is identified by his/her student number. Student’s name (first and last), permanent address, phone number, gender and date of birth are also stored. An airplane has a registration number, type, number of economy class seats, number of business class seats and the year of production. Some students live in student halls. Each hall has a name (unique) and an address. Each student has a number (unique) and a name. Assume that there are students living in every hall. Each text book has a unique ISBN (International Standard Book Number), and contains several chapters. Each chapter has a chapter number (unique within a book), the number of pages and the number of references. A chapter covers a single topic, but the same topic may be covered in various books. Each lecturer is identified by a unique number, name and phone. A lecturer teaches several courses, and for…
Design an Entity Relationship Diagram for the following example:
Draw an Entity Relationship Diagram for ther following information.
Prepare an Entity Relationship Diagram for the application described in the following paragraph. Pick and Shovel Construction Company is a multi-state building contractor specializing in medium-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 employees sometimes work on more than one project at a time. Equipment, however, is assigned to only one project at a time. Draw an ERD showing those entities.