Using MIS (10th Edition)
10th Edition
ISBN: 9780134606996
Author: David M. Kroenke, Randall J. Boyle
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 5, Problem 5.2UYK
Consider the relationship between Adviser and Student in Figure 5-21. Explain what it means if the maximum cardinality of this relationship is:
- a. N:1
- b. 1:1
- c. 5:1
- d. 1:5
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Normalize the following table, given 1NF, 2NF and BCNF:
2nd Teacher
Students
School
Group
А, В
Subject Name
1st Teacher
Class
Arabic Lang
Ali
Ahmed
6th
50
Markazia
Islamic Edu
Ahmed
Ali
5th
B.
45
Markazia
When mapping the (M To N) relationship all we do is move the key attribute to
one side from the many side.
Select one:
O True
O False
If a university has 20 colleges and a college belong to one university then the
cardinality for this scenario is:
Note: Consider the left side for the college and the right side for the university
O 1.
1:N
O 2. N:1
O 3. 1:1
O 4. N:M
TESTING YOUR UNDERSTANDING
Exercise 3-1.
Consider the scenario described at the beginning of this chapter:
When parents call to say that children are sick, we have to let their classroom teachers know, and if it's
sports day and the child is on a school team, the sports teacher might have to sort out substitutes. Then
we need to count up all the days missed to put on the child's report. The Department of Education needs
the totals each term, too.
Run through the steps in the summary section and sketch some use cases and an initial data model. Assume
that the main objectives are to record the absences for the classroom teacher, for school reports, and for
statistics given to the Department of Education.
Chapter 5 Solutions
Using MIS (10th Edition)
Ch. 5.2 - Prob. 1EGDQCh. 5.2 - Prob. 2EGDQCh. 5.2 - Prob. 3EGDQCh. 5.2 - Prob. 4EGDQCh. 5.2 - Prob. 5EGDQCh. 5.2 - Prob. 6EGDQCh. 5.2 - Prob. 7EGDQCh. 5.2 - Consider the adage Never ask a question for which...Ch. 5.3 - Prob. 1SAQCh. 5.3 - Prob. 2SAQ
Ch. 5.3 - Prob. 3SAQCh. 5.3 - Prob. 4SAQCh. 5.8 - Prob. 1SGDQCh. 5.8 - Prob. 3SGDQCh. 5.8 - Prob. 4SGDQCh. 5.8 - Prob. 5.1ARQCh. 5.8 - Prob. 5.2ARQCh. 5.8 - Prob. 5.3ARQCh. 5.8 - Prob. 5.4ARQCh. 5.8 - How are data models used for database development?...Ch. 5.8 - Prob. 5.6ARQCh. 5.8 - Prob. 5.7ARQCh. 5.8 - Prob. 5.8ARQCh. 5 - Draw an entity-relationship diagram that shows the...Ch. 5 - Consider the relationship between Adviser and...Ch. 5 - Prob. 5.3UYKCh. 5 - Prob. 5.4UYKCh. 5 - Study Figure 5-28 to understand the entities and...Ch. 5 - Working with your team, develop a list of seven...Ch. 5 - Modify the E-R model in Figure 5-28 to include a...Ch. 5 - Discuss the advantages and disadvantages of the...Ch. 5 - Transform the data model in Figure 5-28 into a...Ch. 5 - Prob. 5.1CE5Ch. 5 - Fill your database with sample data. Because you...Ch. 5 - Prob. 5.12CE5Ch. 5 - Explain why a one-table database could be stored...Ch. 5 - Prob. 5.14CS5Ch. 5 - Examine the columns in Figure 5-33. Name three...Ch. 5 - Prob. 5.16CS5Ch. 5 - Prob. 5.17CS5Ch. 5 - Explain the statement A database is an abstraction...Ch. 5 - Prob. 5.19CS5Ch. 5 - Prob. 5.2MMLCh. 5 - Prob. 5.21MML
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
- Please help me with this question ERD diagram.arrow_forwardHow can you tell if a model meets the requirements for proportionality and additivity?arrow_forwardQ1. Consider the following fact table about sales: Product Time Drinks Bread $20000 $25000 $35000 $10000 $10000 $10000 July August Sept $15000 $15000 Oct $20000 Nov $20000 Suppose the Time dimension hierarchy has three levels: month → quarter → all, and the Product dimension has two levels: item → all. July and August belong to the summer quarter, and Sept and Oct and Nov belong to the fall quarter. (a) List all derived cells that involve quarters, together with their total dollar values. (b) Give an example of drill down involving two cells (list both the "from" cell and the "to" cell). (c) Give an example of roll up involving two cells (list both the "from" cell and the "to" cell). Q2. Use the fact table in Q1 to illustrate what is meant by “the sum() measure is distributive", what is meant by "the avg() measure is not distributive", what is meant by "avg() is algebraic", and what is meant by “the median() measure is not algebraic".arrow_forward
- We have a ternary relationship below: Job ID Employee Branch Work ID ID The following rule applies to this system: One employee only works on one job One employee only works for one branch One branch offers many jobs A job could exist in many branches Many employees are doing same jobs in one branch Can we decompose the ternary relationship to three binary relationship? If so, how?arrow_forwardFill in the matrix representation for the relation depicted in the arrow diagram. 1 2 1 2 3 1 Pick Pick Pick 2 Pick Pick Pick 3 Pick Pick Pickarrow_forwardPlease answer below questions based on this dimensional model and additional information provided Time B Year B1 14 14 Quarțer B2 13 12 Month B3 13 B4 Month АЗ B4 C5 CS 16 Measure 1 Measure 2 C4 АЗ Measure 3 15 127 A2 C3 13 1.6 A1 C2 16 A C1 There is a central fact table and 4 dimensions – Time, A, B and C. The ratio m: n between 2 attributes of the hierarchy represents that for every 'm' occurrence of a parent element there will be a maximum of 'n' children. As per the current state, this fact table contains 1. 3 Years 2. 4 A1s| 3. 5 В1s 4. 5 C1s Q1: What is the maximum possible fact data volume in terms of record/row count? Answer: Q3: The m:n ratio from attribute B3 to attribute B4 is changed from 1:3 to 1:1 due to some organizational changes. By how many times the maximum possible fact data volume (by record count) decreases? Answer: Q4: If there is an aggregate fact table at quarter dimension level with other attributes B4, C5 and A3. What is the maximum possible record count of…arrow_forward
- Use a Venn diagram to illustrate the relationship A ⊆ B and B ⊆ C.arrow_forwardDraw an ER diagram for the following domain of criminal court cases. Each judge has a list ofoutstanding cases over which he will preside. Only one judge presides per case. For each case one prosecuting counsel is appointed to represent the Department of Public Prosecutions. Cases are scheduled at one Crown Court for an estimated duration from a given start date. A case can try more than one crime. Make any assumption that you need for the relationship cardinality if you feel it is missing. Note that for this ER the attributes for the entities are missing. You do not have to defineattributes that has not explicitly mentioned in this questionarrow_forwardConsider the relation R(A, B, C, D, E) and the set F = {AB → CE, E → AB, C → D}. What is the highest normal form of this relation? Explain your answer.arrow_forward
- Let R₁ and R₂ be the relations on X={a,b,c}, R₁={ (b,a), (c,b), (a,c) } R₂={ (a,c), (b,c)} R₁-¹= R₂ ° R₁=arrow_forwardDraw the ER/EER model for the given scenario. Manufacturer have unique name, an address, and a phone number. Products have a product_id, a name and price. Products may be classified into electronics and grocery. Electronic products have description, type attributes. Groceries have fssai_number, date_of manufacture, date_of_expiry. Each product is made by one manufacturer, and different manufacturers may produce different products.. Customers are identified by their unique social security number. They have email addresses, and physical addresses. Several customers may live at the same (physical) address, but we assume that no two customers have the same email address. An order has a unique order number, and a date. An order is placed by one customer. For each order, there are one or more products ordered, and there is a quantity for each product on the orderarrow_forwardQUESTION 5 Consider the following preference profile P: Applicant Preferences Hospital Preferences A1 A2 A3 A4 H3 H3 На A2 A1 Н НА H2 H3 H2 H4 H1 H2 H3 H4 A4 A3 A4 H1 H1 H1 A2 H2 H4 H3 H2 A2 Аз A4 A1 As indicated above, the table with hospitals' preference lists has some missing data points (though you can deduce, for example, that Hi's second choice is A1). You are not given any further information. Let M be the output matching of the applicant-proposing GS algorithm. Then, M includes the matched pair O (A1, H1) O (A2, H1) (Аз, Н1) O (A4, H1)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Operations Research : Applications and AlgorithmsComputer ScienceISBN:9780534380588Author:Wayne L. WinstonPublisher:Brooks Cole
Operations Research : Applications and Algorithms
Computer Science
ISBN:9780534380588
Author:Wayne L. Winston
Publisher:Brooks Cole
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY