Page 231 -

Chapter 5 Database Processing
230

Figure 5-29
Sample Data Entry Form

Coll abora tion exerCiSe 5

Using the collaboration IS you built in Chapter 2 (page 110), col- 5-12. A Big Data Analytics organization has launched a
laborate with a group of students to answer the following questions. connecting program around the UK to train faculty
The Falcon Security problem is an excellent example of the members across 500 campuses. Each year at least 20
use of small databases in business. It is also within reach for you faculty members from each campus need to register
to develop as a practice exercise. To do so, work with your team for this program. The faculty members will be trained
to answer the following questions: on the big data analytics and other emerging technol-
ogies. As a coordinator of this program, you need to
5-5. Study Figure 5-28 to understand the entities and their
relationships. Justify each of the cardinalities in this track faculty members, their campuses and the tech-
model. nology they have registered for in the current term.
5-6. Working with your team, develop a list of seven queries You have decided to represent this situation with an
that together use all of the entities in Figure 5-28. ER diagram. Hence,
5-7. Modify the E-R model in Figure 5-28 to include a Con- a. Identify various entities in this given scenario.
tact entity that is related to the Facility entity. Create the b. After identification of entities, find out the attri-
relationship, and specify and justify the relationship’s butes of the identified entities .
cardinalities. c. The next task is to list down the identifiers to be used
5-8. Discuss the advantages and disadvantages of the mod- in the final ER diagram.
el you created in your answer to question 5-7 and the d. Before going for the depiction of the given scenario
model in Figure 5-28. using ER Diagram, figure out the relationship
5-9. Transform the data model in Figure 5-28 into a rela- among identified the entities.
tional database design. Hint: Create a table for each e. After performing above steps, make an ER Diagram
entity and relate those tables as shown in Q6. to depict the above findings.
5-10. Create an Access database for your design in question 5-9.
5-11. Fill your database with sample data. Because you do
not have files on a server, leave the URL column blank.