Chapter 5 Database Processing - Case & Exercise. Jason C. H. Chen , Ph.D. Professor of MIS School of Business Gonzaga University Spokane, WA 99258 USA firstname.lastname@example.org. In-class exercise UYK (p.171).
Jason C. H. Chen, Ph.D.
Professor of MIS
School of Business
Spokane, WA 99258 USA
(e.g., GU students, faculty, staff etc.)
(e.g., ZagWeb, Blackboard, Bookstore, Library, etc.)
(e.g., GU database)
2.Consider the relationship between AdviserandStudentin Figure 5-20. Explain what it means if the maximum cardinality of this relationship is (A:S– Advisor:Student)
3. Identify two entities in the data entry form in Figure 5-27. What attributes are shown for each? What do you think are the identifiers?
Fig 5-27 Sample Data Entry Form
4. Using your answer to question 3, draw an E-R diagram for the data entry form in Figure 5-27. Specify cardinalities. State your assumptions.
Employees take zero or more classes; a class is taken by one or more employees
1. Courses may be offered many times but always on different dates.
2. Employees may not have taken any classes.
3. Classes have at least one employee.
5. The partial E-R diagram in Figure 5-28 (next page) is for a sales order. Assume there is only one Salesperson per SalesOrder.
a. Specify the maximum cardinalities for each relationship. State your assumptions, if necessary.
b. Specify the minimum cardinalities for each relationship. State your assumptions, if necessary.
1. Clearly, Dynamo, Bigtable, and Cassandra are critical technology to the companies that create them. Why did they allow their employees to publish academic papers about them? Why did they not keep them as proprietary secrets?
2. What do you think this movement means to the existing DBMS vendors? How serious is the NoSQL threat? Justify your answer. What responses by existing DBMS vendors are sensible?
3. Is it a waste of your time to learn about the relational model and Microsoft Access? Why or why not?
4. Given what you know about GearUp, should it use a relational DBMS, such as Oracle Database or MySQL, or should it use Cassandra?
5. Suppose that GearUp decides to use a NoSQL solution, but a battle emerges among the employees in the IT Department. One faction wants to use Cassandra, but another faction wants to use a different NoSQL data store, named MongoDB (www.mongodb.org). Assume that you’re Kelly, and Lucas asks for your opinion about how he should proceed. How do you respond?