Connect with LearnSmart Access Card for Business Driven Technology
7th Edition
ISBN: 9781259852183
Author: Paige Baltzan, Amy Phillips
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
Question 1
a) Give an example of three entities that might exist in a database for a medical office, and list some attributes that would be stored in a table for each entity.
b) What is a relationship, and what three types of relationships exist? Give an example of each of the three types of relationships as per your example of entities in part (a)
Question 2
Identifies the Entities and Draw an ER diagram for the following scenario:
a) A college needs to track placement test scores for incoming students. Each student can take a variety of tests, including English and math. Some students are required to take placement tests because of previous coursework.
b) Every employee in a company is assigned to one department. Every department can contain many employees.
c) Data for an information technology conference needs to be collected. The conference has a variety of sessions scheduled over a two-day period. All attendees must register for the sessions they plan to attend. Some…
Using er assistant create an Entity Relationship Diagram(ERD) with appropriate entries, relevant attributes, and relations to support the following business rules, and write a few lines to defend your erd.
You need to design a database to keep track of clubs at a high school.
Attributes:
A student may only join one club
Some students do not join at all
Club needs to have one student
Need to capture students:
Name
Address
Year of grad
All Phone numbers
Club name
Club advisor
Meeting dates
Production tracking is important in many manufacturing environments (e.g., the pharmaceuticals industry, children’s toys, etc.). The following ER diagram captures important information in the tracking of production. Specifically, the ER diagram captures relationships between production lots (or batches), individual production units, and raw materials.(ER Diagram in photo)
I) Please convert the ER diagram into a relational database schema. Be certain to indicate primary keys and referential integrity constraints
ii. Please identify an attribute in the above ER diagram that might represent a composite attribute, and explain why/how it might represent a composite attribute.
iii. Please identify an attribute in the ER diagram that could represent a derived attribute and explain why/how it might represent a derived attribute.
iv. The ER diagram/relational database schema contains several instances of data redundancy. Please identify one instance where a data redundancy issue exists.
v. The…
Chapter 6 Solutions
Connect with LearnSmart Access Card for Business Driven Technology
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
- A new sales ordering system needs a relational database that contains a customer table, a product inventory table, and an order table. Use a word-processing, graphics, or spreadsheet program to draw an entity-relationship diagram showing the relationships among these entities. Next, design each of these tables showing the keys and attributes to be included in each table. Include five sample records for each table.arrow_forwardPlease read the instructions carefully;1. Find a domain to design your database. Examples: University database, Flightreservation system, etc. Note: Please do not use these. As discussed in the class, try tochoose a domain which is not explored much / your own family business.2. Collect the necessary information to model the database for the chosen domain.3. Identify entity sets, relationship sets, attributes etc.4. Draw the ER diagram5. Reduce the ERD into conceptual schema by applying appropriate rules.6. Normalize each schema upto BCNFarrow_forward1. 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_forward
- Note: This question has been rejected three times now saying the question is incomplete. That's how the question is. Please do not reject it saying it is incomplete. The previous 4 questions were related. I was asked to provide question 3 but I will provide all of them. Question 1: Create the Entity Relationship (ER) Diagram for the following scenario. We want to maintain a database for a Faculty within a multi-campus regional university. The faculty has a number of schools and each school is characterized by its school-code which is unique, name and campus location. Schools employ professors who are characterized by their unique staff-id, name and the school they work for. A school offers courses that are characterized by their course-code which is unique, course name and the school. There are subjects offered within the faculty and these arecharacterized by unique subject-code, title and the school that offers them. Students enroll into courses that are characterized by student-id…arrow_forwardExercise 3 Manufacturer 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. List of Entities and the Attributes List of Relationship and Cardinalities Draw the Conceptual Model Draw the Logical Model with…arrow_forwardDesign a conceptual schema (ER diagram) for doctors’ offices. The following information describes the situation that doctors’ offices database must model. Be sure to indicate all key and cardinality constraints and any assumptions you make. Each doctor has badgeId , and name. A doctor is uniquely identified by their badgeId and may manage more than one office. An office may be managed by at most one doctor. An office has address and a phone. it is uniquely identified by its address, and it contains one or more exam rooms An exam room can be identified by its room number, and the office that it is in. Each patient has SSN, name, and phone number. Patient is uniquely identified by their SSN. When a patient visits an office, he or she has a consultation with a doctor in an examination room.arrow_forward
- Doctors have id. name. date of birth. and specialty. Patients have id. name, and date of birth. and address. Medicines have name. patent number, and milligrams We want to build A database that keeps track of the medicines prescribed by a doctor to patients The prescription process happens in a hospital. (a) Draw a complete Entity-Relationship diagram for the description above. You must include all the details, such as keys, weak entities (if any). cardinality constraints., etc Your diagram must use n-ary relationships You must use arrow notation Your diagram must avoid redundancy.arrow_forwardMIS150 hires qualified employees to purchase merchandises from vendors. Develop an appropriate enhanced entity relationship diagram for MIS 150 database that only describes MIS 150 employees to purchase merchandises from vendors for increasing inventory, and to handle purchasing payments for the vendors that could be either credit and/or cash. The diagram can only have one-to-many relationship and cannot contain any irrelevant entities to avoid points deduction. (Use Word’s Shapes, and Text Box to draw enhanced entity relationship diagramarrow_forwardPage of 2 ZOOM 44-460 Database Systems Chapter 3 Assignment Spring 2022 Draw an EER diagram to represent the following situation: When appropriate, model an associative entity. A rental property would like to store information about TENANT, DEPENDENTs and Payment. The property would like to store information about Tenant: Unique Tenant Id, Tenant Name(first and last) , Address(Street, City, State) , Phonenumbers (country, Area, local), Email Address and House Type. A housetype can be a Townhouse, Apartment or Individual house. For a Apartment, we will store Unique Apart number, number of rooms; for an Individual house, we will store Unique House number, size of house. We will not store any additional information about Townhouse. Dependents are depended on the tenants. Dependent can be uniquely identified by their name. For PAYMENTs, the following information will be stored: a unique payment id, the Bank name associated with the form of payment…arrow_forward
- Your task is to develop an ER diagram, listing all entities with its attributes including associations and multiplicities, based on the following narrative. You will need to use either MS Visio or Draw.io to create an ER diagram. Case Study Professional Electronics and Repairs (PEAR) company repairs smartphones, laptops, tablets, and MP3 players. PEAR hired you to create a database to help run their business. When a customer brings a device to PEAR for repair, data must be recorded about the customer, the device, and the repair.The customer’s name, address, and a contact phone number must be recorded (if the customer has used the shop before, the information already in the system for the customer is verified as being current). For the device to be repaired, the type of device, model, and serial number are recorded (or verified if the device is already in the system). Only customers who have brought devices into PEAR for repair will be included in this system. Since a customer…arrow_forwardCreate a logical data model documented with an ERD using the crow’s foot format. Be sure that each entity has the entity name at the top of the box, the primary key attribute or attributes in the middle of the box, and the non-key attributes in the bottom of the box. Lines should separate each part of the entity box. Follow these instructions about each ERD: ● The ERD must not have any many-to-many (m:n) relationships. ● All attributes must be placed within an entity. ● Each entity must have a primary key defined. A primary key can consist of one or more attributes. ● Each relationship must have a foreign key. Denote the foreign key(s) with the notation (FK) on the ERD. Remember that in a one-to-many relationship, the foreign key is placed in the entity that is on the many side of the relationship. ● Each relationship must include both a maximum and minimum cardinality for both sides of the relationship. ● Each relationship should have a verb or verb phrase to describe it. Question:…arrow_forwardIllustrate an Entity-Relationship Diagram (ERD) model using Crow’s Foot notation Here we can have the following entities 1.patients:this entity will store the details of the patients and the attributes for this entity is id(which is unique for each patient and can be used as a primary key) name(this attribute will store the name of the patient and it is a composite attribute) address(this attribute will store the address of the patient and it is multi valued attribute. ) contact_num(this is also a multi valued attribute which will store the contact details of the patient). age(which is a derived attribute) 2.room:this entity will store the information about the details of the rooms. The attributes are. id(this is unique for each room and can be used as a primary key) room number(this will store the room number) Total_bed(this will store the total number of beds present in that room) 3. Bed:this entity will store the information regarding to each bed present in an room, and the…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Fundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningFundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY