Database Systems: Design, Implementation, & Management
12th Edition
ISBN: 9781305627482
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
thumb_up100%
Chapter 4, Problem 5P
a.
Program Plan Intro
Entity Relationship (ER) Diagram:
The following figure illustrates the ER Diagram for Hudson Engineering Group in (HEG) Crow’s Foot notation:
Explanation:
- In above ERD, A trainee can take several class and each class can have more trainees, so there is an “M: N” relationship between the entities TRAINEE and CLASS. Hence a composite entity “ENROLLMENT” is act as bridge between those entities.
- The relationship between the entities INSTRUCTOR and CLASS is 1: M. Because a class is taken by only one instructor but an instructor can take more classes.
- The relationship between the entities COURSE and CLASS is also1: M.
b.
Explanation of Solution
Relationship:
The relationship between the entities INSTRUCTOR and CLASS is 1: M. Because a class is taken by only one instructor but an instructor can take several classes...
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
The Hudson Engineering Group(HEG)has contacted you to create a conceptual model whose application will meet the expected database requirements for the company's database program.The HEG adminitrator gives you the following discription of the training group's operating environment.The HEG has 12 instructors and can handle upto 30 trainees per class.HEG offers 5 Advanced Tecnology courses,each of which may generate several classes.If a class has fewer than 10 trainees,it will be canceled.Therefore ,it is possible for a course not to generate any classes.Each class is taught by one instructor.Each instructor may teach upto 2 classes or may be assigned to do research only.Each trainee may take to 2 classes per year.Given that information do the following:a.Define all of the entities and relationships.b.Describe the relationship between instructor and class in terms of connectivity,cardinality,and existence dependence.
"Mpho is very excited about the new information system to be built for his spaza shop. In this section, you need to make Mpho understand database concepts and how they will benefit his spaza shop."
To make Mpho understand databases and database management system, use an infographic to list and explain the hierarchy of data. The infographic must be easy to read. The data hierarchy must be listed in the order of the smallest to the largest.
You are one of the team members who your project team leader has assigned to involve in the discussion of developing an Automated Teller Machine (ATM) system. Throughout the discussion, you have gathered the following requirements statement for the ATM system from your clients' team members. The IT personnel from your client’s team need to understand the structure of your database and the interaction between the actor(s) or object(s) in the system. Therefore, you have instructed your System Analyst to provide the structural and behavioural modelling of the ATM system based on the requirements statement you gathered, as shown below :
AutomatedTellerMachine
The software to be designed will control a simulated Automated Teller Machine (ATM) having a magnetic stripe reader for reading an ATM card, a customer console (keyboard and display) for interaction with the customer, a slot for depositing envelopes, a dispenser for cash (in multiples of $20), a printer for printing customer…
Chapter 4 Solutions
Database Systems: Design, Implementation, & Management
Ch. 4 - Prob. 1RQCh. 4 - What is a strong (or identifying) relationship,...Ch. 4 - Prob. 4RQCh. 4 - Suppose you are working within the framework of...Ch. 4 - Prob. 6RQCh. 4 - Prob. 7RQCh. 4 - Discuss the difference between a composite key and...Ch. 4 - What two courses of action are available to a...Ch. 4 - Prob. 11RQCh. 4 - Discuss two ways in which the 1:M relationship...
Ch. 4 - Prob. 13RQCh. 4 - Prob. 14RQCh. 4 - Briefly, but precisely, explain the difference...Ch. 4 - What are multivalued attributes, and how can they...Ch. 4 - Prob. 17RQCh. 4 - Prob. 18RQCh. 4 - What two attributes must be contained in the...Ch. 4 - Describe precisely the composition of the...Ch. 4 - Prob. 21RQCh. 4 - Prob. 1PCh. 4 - Create a complete ERD in Crows Foot notation that...Ch. 4 - Prob. 4PCh. 4 - Prob. 5PCh. 4 - Prob. 6PCh. 4 - Prob. 7PCh. 4 - Prob. 8PCh. 4 - Prob. 9PCh. 4 - Prob. 10PCh. 4 - Prob. 11C
Knowledge Booster
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 spread-sheet 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_forwardThe ______________ model is a simple but highly useful way to organize data into collections of two-dimensional tables called relations.arrow_forwardDatabase design is a crucial phase during the database life cycle (DBLC).John is the CEO of a company that produces large-scale online educationpackages. The company has decided to start from scratch with a brand new database system. He has approached you to assist him specifically with the Conceptual Design. John has provided you access to their previous system and has set up interviews for you with multiple employees that use the system. John has also requested a visual representation of the data to help him get an overview. As a businessman, John must make important decisions based on reports generated by the system. A list of the required reports has been sent to you. John has also indicated that their data will be hosted across multiple sites due to thelarge amounts of data that have to be stored.Fully explain to John how you will approach the Conceptual Design stage.Your answer must refer to the situation described above.arrow_forward
- Please read the brief scenario provided below: As the IT director for a large tertiary care center, you were asked to create a database that will collect patient information for the oncology department. You narrowed your database structure to either a relational or a NoSQL database model. The head of oncology asked that you attend a meeting to elaborate on the ability of these models to meet his team’s needs and get their feedback prior to making a final decision. Compose your arguments for each model to share with the oncology team. Please make sure that you include the benefits of each database models in your answer. Next, please make a recommendation for the type of database that would best meet the needs of the oncology department and provide a rationale for your decision.arrow_forwardIn this assignment, you will develop a business/organizational case study and design a database that will meet the needs (or a subset of needs) of your business which is the healthcare industry, particularly hospitals. Your database must ultimately include at least 6 tables and at least 30 columns in total (it can contain more tables/columns if you would like or if your business case requires). You will only need to provide three rows of sample data for each database table. You will produce a report that describes the business needs that have led to the need for your database, details your business rules. Your report will also include both a conceptualand logical model of your database, as well as data dictionariesarrow_forwardThe Hudson Engineering Group (HEG) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company’s training program. The HEG administrator gives you the following description of the training group’s operating environment. The HEG has 12 instructors and can handle up to 30 trainees per class. HEG offersfive Advanced Technology courses, each of which may generate several classes. Ifa class has fewer than ten trainees, it will be canceled. Therefore, it is possible for a course not to generate any classes. Each class is taught by one instructor. Each instructor may teach up to two classes or may be assigned to do research only. Each trainee may take up to two classes per year. Given that information, do the following: a. Identify all of the main entities, relations and connectivities among entities. ENTITY RELATIONSHIP CONNECTIVITY ENTITY b. Draw the ERD for HEG.arrow_forward
- You must create an ER model for Upwork before forward engineering the database in MySQL. A database design project typically begins with requirements analysis to identify the business rules, entities, and relationships to form an ERD, which is then converted into a database. Assumptions: - A client/freelancer can sign up and create an account via email. - A freelancer cannot be a client. - Clients can leave feedback on the freelancers. - The system should keep track of all bids for each project. - The total bid amount can be calculated by assuming an 8-hour workday. [(freelance hourly rate * total number of days * 8) = Bid Amount] Other functionality not mentioned in the assumptions section is out of scope. Hint: How to get started: - Writing down your design before implementing it in MySQL will help you better understand the relationships. - Examine the screenshots provided to learn how the website works. - Determine which entities are required and which may be required. - Record…arrow_forwardEduvarsity, a university which prides itself in its efforts to provide their students with the academic support, has just hired you to develop the information system they will be using to keep track of the students that have signed up for extra classes at the university. They have brought you in to specifically help them design the database their information system will be using. As part of your design job, the Eduvarsity managers asked you to provide an Entity Relationship Diagram to show the structure of the database. They would like the database to keep track of the students who have used the system to register for extra classes. Details such as their student number, frst name, last name, and date of birth are to be stored for every student that registers. The university has lecturers involved in their academic support programme. The designed database should be able to store details on the lecturers such as first name, last name and highest qualfication. Each lecturer can provide…arrow_forwardThe Entity Relationship (ER) Model is intended as a description of real-world entities. The ER Diagram represents the conceptual level of database design meanwhile the relational schema is the logical level for the database design. Refer to the Figure 1 below and convert the given ER Diagram into a relational schema. Identify all the primary as well as foreign key relations that should be implemented in the required relational schema.arrow_forward
- The administrators of Tiny College are so pleased with your design and implementation of their student registration and tracking system that they want you to expand the design to include the database for their motor vehicle pool. A brief description of operations follows:• Faculty members may use the vehicles owned by Tiny College for officially sanctioned travel. For example, the vehicles may be used by faculty members to travel to off-campus learning centers, to travel to locations at which research papers are presented, to transport students to officially sanctioned locations, and to travel for public service purposes. The vehicles used for such purposes are managed by Tiny College’s Travel Far But Slowly (TFBS) Center.• Using reservation forms, each department can reserve vehicles for its faculty, who are responsible for filling out the appropriate trip completion form at the end of a trip. The reservation form includes the expected departure date, vehicle type required,…arrow_forwardThe administrators of Tiny College are so pleased with your design and implementation of their student registration and tracking system that they want you to expand the design to include the database for their motor vehicle pool. A brief description of operations follows:• Faculty members may use the vehicles owned by Tiny College for officially sanctioned travel. For example, the vehicles may be used by faculty members to travel to off-campus learning centers, to travel to locations at which research papers are presented, to transport students to officially sanctioned locations, and to travel for public service purposes. The vehicles used for such purposes are managed by Tiny College’s Travel Far But Slowly (TFBS) Center.• Using reservation forms, each department can reserve vehicles for its faculty, who are responsible for filling out the appropriate trip completion form at the end of a trip. The reservation form includes the expected departure date, vehicle type required,…arrow_forwardThe administrators of Tiny College are so pleased with your design and implementation of their student registration and tracking system that they want you to expand the design to include the database for their motor vehicle pool. A brief description of operations follows: Faculty members may use the vehicles owned by Tiny College for officially sanctioned travel. For example, the vehicles may be used by faculty members to travel to off-campus learning centers, to travel to locations at which research papers are presented, to transport students to officially sanctioned locations, and to travel for public service purposes. The vehicles used for such purposes are managed by Tiny College’s Travel Far But Slowly (TFBS) Center. Using reservation forms, each department can reserve vehicles for its faculty, who are responsible for filling out the appropriate trip completion form at the end of a trip. The reservation form includes the expected departure date, vehicle type required,…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
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
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning