FIGURE 3-13 Entity clustering for Pine Valley Furniture Company (a) Possible entity clusters (using Microsoft Visio) CUSTOMER CUSTOMER SELLING UNIT SALESPERSON Customer Type National? Regular? Submits Customer Type Serves SALES TERRITORY DOES BUSINESS IN REGULAR CUSTOMER NATIONAL CUSTOMER Account Manager PRODUCT LINE ORDER ITEM SALE Includes VENDOR HITEM PRODUCT ORDER LINE SUPPLIER USES PRODUCED IN Contract Number MATERIAL SUPPLIES RAW MATERIAL. WORK CENTER EMPLOYEE WORKS IN SKILL HAS SKILL Employee Type d) Employee Type "M" "U" UNION EMPLOYEE MANAGEMENT EMPLOYEE MANUFACTURING Supervises

FIGURE 3-13 Entity clustering for Pine Valley Furniture Company (a) Possible entity clusters (using Microsoft Visio) CUSTOMER CUSTOMER SELLING UNIT SALESPERSON Customer Type National? Regular? Submits Customer Type Serves SALES TERRITORY DOES BUSINESS IN REGULAR CUSTOMER NATIONAL CUSTOMER Account Manager PRODUCT LINE ORDER ITEM SALE Includes VENDOR HITEM PRODUCT ORDER LINE SUPPLIER USES PRODUCED IN Contract Number MATERIAL SUPPLIES RAW MATERIAL. WORK CENTER EMPLOYEE WORKS IN SKILL HAS SKILL Employee Type d) Employee Type "M" "U" UNION EMPLOYEE MANAGEMENT EMPLOYEE MANUFACTURING Supervises

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter4: Entity Relationship (er) Modeling

Section: Chapter Questions

Problem 1RQ

See similar textbooks

Similar questions

Develop ERD (Entity Relationship Diagram) for one of the following two scenarios. NOTE: No further details were provided by the professor. The diagram can be drawn by hand also if preferred. Option1: A customer who goes to a grocery shop generates one invoice each time s/he goes to the grocery. Customer data to capture includes ID, FirstName, LastName, City, State, CreditLimit. An invoice should capture the data on InvoiceID, SaleDate, SalesPerson, and Amount. Provide a conceptual ERD for this transaction scenario. Option 2: One sports team consists of many players, and one player can belong to one sports team at a time. Sports team data should have TeamID, TeamName, CoachName, memberNumbers, City, State, owner, TeamValue. Each player can be represented with PID, Name, Address, PhoneNo, Position, weight, height, Value, and Scores. Provide a conceptual ERD to develop a database.
Prepare an entity relationship diagram for the revenuecycle that includes entities, cardinalities, andreflects the following business rules:• Customers place many orders during the period• Each sales order consists of one or more line itemsof inventory.• Customers are billed twice a month for the purchasesthat they made during the period.• Customers make payments once a month to settletheir accounts.
Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notationaccording to the below business rules. Your design should be at the logical level – include primaryand foreign key fields and remember to remove any many‐to‐many relationships. Business rules for a horse‐riding competition:1. All entities should have surrogate primary keys.2. Each rider may only represent a single club, but each club may enter many riders into thecompetition.3. The name of each club must be recorded in the database.4. The name and surname of each rider must be recorded in the database.5. Each rider may only ride one horse, and every horse may only have one rider.6. The name of each horse must be recorded in the database.7. A horse may compete in multiple different events, and each event will have many horsesthat compete in it.8. The name of each event must be stored in the database
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 ‐ Each course has a number, name and credit. The course number is unique for each course. ‐ Each department has a name, code and The code is unique for each department. ‐ Each course may has one or more sections where each section is belong to only one ‐ A department offers one or many 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.
which relationship or association is depicited in the following entity relationship (ER) diagram? Salesperson sales Product a) Uniary b) One to many c) Associative Entity d) Intersection Dta
Create an ER Diagram for an Bank. Identify atleast 5 entity in the ER Diagram Identify atleast one weak entity. Identify atleast 3 attributes for each entity. Identify atleast one attribute that is: Composite Multivalued attribute Derived attribute Represent all the key(primary) attributes by suitable notations/symbol. Represent the Cardinality and Modality using Crow’s foot notation. Identify atleast one specialization/generalization.
create an Entity Relationship Diagram using the following Entities and their respective attritubes for an online programming competition registration for both leaners and university students. 1. Host it's attributes (host Id, hostFirstName,hostLastName, hostTelNum,hostEmail,hostPassword) 2. Student(StudentId, StudentfirstName, Student Email, StudentPassword, InstitutionName) 3. Learners(leaner Id, leanerFirstName, leanerLastName, leanerPassword, SchoolName) 4. Competition(compId, comName, compDate,comTime, compRules, compRequirements) 5. Qualified Student/Leaner (id, firstName, compId,email)
Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation according to the below business rules. Astronaut mission business rules:• Every entity must have a surrogate primary key.• An astronaut lives in a specific country, and many astronauts can be from the samecountry.• The name for each astronaut must be stored in the database.• The name for each country must be stored in the database.• An astronaut is assigned to a mission to perform a specific role on board a specific vehicle.• An astronaut and a vehicle can be assigned to multiple missions over time.• The start date and end date of each mission must be stored in the database.• The model and name of each vehicle must be stored in the database.• The description of each role must be stored in the database.
Draw an entity relationship diagram ERD using unified modelling language UML nation according to the below business rules. your design should be logical level-including primary and foreign key fields and remember to remove any many-to-many relationships. 1. all entities should have surrogate primary keys. 2.A customer can place many orders over and over time and each order is placed by exactly one customer. 3.The name and surname of a customer must be stored in the database 4.The date and status of an order must be stored in the database 5.Each order cab obtain many items and each item can be part of many different orders 6.The name description and unit price of every item must be stored in the database 7.When an item is added to an order, the quality ordered and the unit price of thr item must be stored 8.Each item in the database belongs to a catagory and a catagory has many items that belong to it 9.The name of each of the categories must be stored in the database
Perform given tasks on Case study Q-Find entity Attribute and primary key, also draw Entity diagram? Case study: In a college we have students, department, teachers and courses. A student has name registration No and address. A teacher has name NIC and qualification. A department is known by its name e.g. CSIT, and have a HOD name , Num of students and Floor No. A course is identified by its Code. Course also has name and level of degree. A student must enroll (roll no and Semester as relationship attribute) in any one department. A department can have many students. The teacher is assigned class (time and day as attribute) in more than one department. A department has many teachers. A student can study up-to 5 courses by a teacher in given classroom number.
Construct an Entity Relationship Diagram (ERD) in Crow’s Foot Notation for the following Nationwide City Express shipping system. Be certain to indicate identifiers and cardinality constraints. You may state any assumptions that you make. Nationwide City Express (NCE) prides itself on having up-to-date information on the processing and current location of each shipped item. To do this, NCE relies on a company-wide information system. Shipped items are the heart of the NCE product tracking information system. Shipped items can be characterized by item number (unique), weight, dimensions, insurance amount, destination, and final delivery date. Shipped items are received into the NCE system at a single retail center. Retail centers are characterized by their type, uniqueID, and address. Shipped items make their way to their destination via one or more standard NCE transportation events (i.e., flights, truck deliveries). These transportation events are characterized by a unique…
Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation according to the below business rules. Your design should be at the logical level – include primary and foreign key fields and remember to remove any many-to-many relationships. Business rules for hairdressers: 1. All entities should have surrogate primary keys. 2. Each hairdresser can work at multiple different salons over time, and every salon employs many different hairdressers. 3. The job title of a hairdresser at a specific salon must be stored in the database. 4. The name and surname of each hairdresser must be stored in the database. 5. The name of each salon must be stored in the database. 6. Every hairdresser is certified to have several different skills, and each skill can be mastered by many different hairdressers. 7. The name of each skill must be stored in the database. 8. The date that a specific hairdresser was certified to have a specific skill must be stored in the database.