Business Driven Technology
7th Edition
ISBN: 9781259567322
Author: Paige Baltzan Instructor
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 6, Problem 5MBD
Explanation of Solution
Entities and Attributes:
The different types of entity classes that Mr. M will use would include the vendors and the classes of equipment. And these classes refer to the different sports.
- Total effort
- Sam sports
- The underline
- Maximum workout
- Basketball equipment
- Aerobics equipment
- Tennis equipment
- Golf equipment
- Swimming equipment
Count of attributes that will be applicable to the above mentioned entities will actually be less and only relevant attributes will be included...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Need this in 30 minutes please Just draw me the Entity-Relationship Digram and here is all the infomation you need for complete it
Entity-Relationship Diagram (ERD)
An ERD visually represents the relationships between entities in a database. Here's what you need:
Entities:
Product: Represents items sold by the coffee shop.
Transaction: Represents a sale event.
Payment: Represents the payment method used for transactions.
BeanCard: Represents the loyalty or prepaid cards customers can use.
Attributes:
Product: Product ID, Name, Category (Beverages, Bakery goods), Price.
Transaction: Transaction ID, Date, Total Amount.
Payment: Payment ID, Type (Cash, Credit, BeanCard), Amount.
BeanCard: Card ID, Customer ID, Balance.
Relationships:
Products to Transactions: A transaction can include multiple products (many-to-many).
Transactions to Payment: A transaction is completed with a single payment method (one-to-one).
BeanCard to Payment: A BeanCard can be used for many payments…
Computer Science
After completing a course in database management, you have been hired as a summer intern by Mountain View Community Hospital. Your first assignment is to work as part of a team of three people to develop a high-level E-R diagram for the hospital. You conduct interviews with a number of hospital administrators and staff to identify the key entity types for the hospital. As a result, your team has identified the following entity types:
• CARE CENTER—a treatment center within the hospital. Examples of care centers are maternity, emergency care, or multiple sclerosis center. Each care center has a care center ID (identifier) and a care center name.
• PATIENT—a person who is either admitted to the hospital or is registered as an outpatient. Each patient has an identifier, the medical record number (MRN), and a name. The hospital also records the date of first contact with the hospital (Contact Date)
• PHYSICIAN—a member of the hospital medical staff who may admit patients…
ERD and Keys
A hotel has many rooms. A guest can make a reservation for one room or multiple rooms. A reservation is associated with only one guest. Draw an ERD with the relationships and resolve any many to many relationships. Create an ID for each entity you create (for example RoomID, GuestID, Reservation ID) as the Primary Key. Identify any foreign keys in each entity where appropriate.
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- 1. Create an entity relationship diagram for the conceptual design using UML notation. The diagram can be created by hand or via some modeling tool. 2. Create a data dictionary for the entities, relationships and attributes. Make your best guess for representing the attributes. Schema 3 You have been hired by the Snowbird ski mountain resort to build a database for their data. The resort has ski mountain peaks, chair lifts, trails, stores and restaurants. For each mountain peak, you track the name, the elevation and its latitude and longitude. Each peak name is unique. The names of the mountain peaks are: Mount Superior, Mount Baldy, Twin Peaks and Hidden Peak. For each chair lift, you track a unique name, the vertical rise, the travel time, the number of people per chair (ranging from 2 to 4) , and its closing time. For each trail, you track its unique name, its elevation, its length, and the typical time it takes to complete. Each ski trail is classified by its level of…arrow_forwardManufacturer A manufacturing company produces products. The following product information is stored: product name, product ID and quantity on hand. These products are made up of many components. Each component can be supplied by one or more suppliers. The following component information is kept: component ID, name, description, suppliers who supply them, and products in which they are used. Create an ERD to show how you would track this information. Show entity names, primary keys, attributes for each entity, relationships between the entities and cardinality. 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 are used in products. A product cannot exist without components.arrow_forwardERD Diagram LucidChart Please be sure to accurately draw each entity, connecting lines, cardinality, actions (relationships), and attributes. Please be sure to properly label – if appropriate – your attributes. Please be sure to designate a primary key and foreign key(s) for each attribute. Please sure to properly label your associative entity – if appropriate. Please be sure to add to your diagram entities “user defined” primary key fields and appropriate foreign key fields Red Light Minor Emergency Clinic located in Wichita Falls, Texas is a 24-hour clinic that provides patients with minor emergency medical care. The clinic would like you to draw and ERD diagram that depicts their customer care process. The nurses working at the clinic can provide care to many patients, and the patient can be seen by many nurses. The clinic would only like to track the nurse’s name (first name and last name). The clinic would like to keep track of the following patient information to include…arrow_forward
- 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.arrow_forwardWhich of the following is a key part of conceptual design in an entity relationship model? This model uses column names instead of attributes. In this model, the characteristics such as location, path, and format are described. This model converts entities into tables. In this model, no primary keys are specified in the entities.arrow_forward______ represent real-world associations between entities. Entities Attribute Relationships Primary Keyarrow_forward
- Given the information above, draw an EER Diagram showing the following:• Entities,• Attributes,• All key attributes,• Data types for each attribute, and• All relationships between the entities.arrow_forwardAn entity in X is connected numerous entity in Y, however an entity in Y is associated to only one entity in X. What it the type of relationship? Select one: a. One to many b. One to One c. None d. Many to Manyarrow_forwardAnalyze the given entity relationship diagram and answer the following questions. What is the degree of “has” relationship? Identify primary key(s) Identify the category of each attribute Name the cardinalitiesarrow_forward
- When an attribute of one entity type references another entity type's attribute, this means that: O it is a derived attribute O weak entity type exists O a relationship exists O it means nothingarrow_forwardYou have been asked to design and implement a database for CTU, which includes 3 entities (tables), as follows: Students Faculty Courses Part 1 Create a Word document that includes the following: Identify at least 3 attributes for each entity, including the following: Student's entity should have an attribute for the program the student is enrolled in. Faculty should have an attribute identifying their rank. Properly identify all of the primary keys (use solid underlines). Create an entity relationship diagram (ERD) from the entities. You may use SmartDraw, Visio, Erwin, or even Word to draw the diagram. Take a screenshot (no need if you use Word), and insert it into the Word document. Part 2 Use Microsoft Access to implement the database that you designed in Part 1, and include the following: Create the Student, Faculty, and Course tables in Access. Add a few instances in each table. Create 2 queries for the following objectives: Find the student names for all students who are in the…arrow_forwardUse Lucidchart to draw an ERR Diagram with this information: EER Diagram for Royal Victoria Hospital Information System Assumptions: The diagram focuses on the entities and relationships. Attributes with cardinality are assumed to be single-valued. Dates are assumed as identifiers for visits. Entities: Person: (person_ID, name, address, birth_date, phone_number) Employee: (inherits from Person, date_hired) Nurse: (inherits from Employee, certificate) Staff: (inherits from Employee, job_class) Technician: (inherits from Employee, skill) Physician: (inherits from Person, speciality, pager_number) Patient: (inherits from Person, contact_date, resident_flag) Outpatient: (inherits from Patient) Resident: (inherits from Patient) Visit: (date, comments, outpatient_ID) Care Centre: (name, location) Laboratory: (name, location) Bed: (bed_number, room_number, care_centre_ID) Item: (item_number, description, unit_cost) Treatment:…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY