Questions from Database Management

Q: Consider the SQL query in Figure 1-20. a

Consider the SQL query in Figure 1-20. a. How is Sales to Date calculated? b. How would the query have to change if Helen Jarvis wanted to see the results for all of the product lines, not just the Ho...

Q: Wally Los Gatos, owner of Wally’s Wonderful World of Wallcoverings,

Wally Los Gatos, owner of Wally’s Wonderful World of Wallcoverings, Etc., has hired you as a consultant to design a database management system for his new online marketplace for wallpaper, draperies,...

Q: Doctors Information Technology (DocIT) is an IT services company supporting

Doctors Information Technology (DocIT) is an IT services company supporting medical practices with a variety of computer technologies to make medical offices more efficient and less costly to run. Med...

Q: Review your answer to Problem and Exercise 2-49; if

Review your answer to Problem and Exercise 2-49; if necessary, change the names of the entities, attributes, and relationships to conform to the naming guidelines presented in this chapter. Then, usin...

Q: Draw an ER diagram reflecting the needs of an instructor to monitor

Draw an ER diagram reflecting the needs of an instructor to monitor their class performance, and include entities such as class performance, grades, and attendance. This ER model will be used by the i...

Q: Consider the two E-R diagrams in Figure 2-25

Consider the two E-R diagrams in Figure 2-25, which represent a database of community service agencies and volunteers in two different cities (A and B). For each of the following three questions, plac...

Q: Draw an E-R diagram for the following situation: ShinyShoesForAll

Draw an E-R diagram for the following situation: ShinyShoesForAll (SSFA) is a small shoe repair shop located in a suburban town in the Boston area. SSFA repairs shoes, bags, wallets, luggage, and othe...

Q: Consider this situation: The faculty at a university (FACULTY entity

Consider this situation: The faculty at a university (FACULTY entity) can also be part of Board of Studies (BOARD entity). Is there a weak entity here? Why?

Q: Because Visio does not explicitly show associative entities, it is not

Because Visio does not explicitly show associative entities, it is not clear in Figure 2-22 which entity types are associative. List the associative entities in this figure. Why are there so many asso...

Q: Figure 2-26 shows a grade report that is mailed to

Figure 2-26 shows a grade report that is mailed to students at the end of each semester. Prepare an ERD reflecting the data contained in the grade report. Assume that each course is taught by one inst...