DATA ANALYSIS AND MODELING
This question is intended to help you to understand the problem specification before designing a proper ERD for a new database system. As such, you are required to choose ONE (1) of the following environment:
Then, answer each of the following questions:
a) Prepare a brief proposal for the chosen environment by including the following items:
i. Propose ONE (1) potential application from the chosen environment. Describe the primary objective of proposed application.
(Describe the objective clearly, in at least one or two paragraphs)
ii. Describe ONE (1) potential process from the chosen application that can be operated by using a database system (e.g.: registration process, billing process, scheduling process, handling process, or any simple process that can be used to keep track of record inside the application).
iii. Identify and describe clearly FIVE (5) primary data involved in this application.
b) Based on the proposed application above:
i. List out FIVE (5) main entities that could be included in the application complete with their attributes (at least two and not more than five).
(Note: each entity should have at least one primary key.)
ii. Draw a complete Entity Relationship Diagram (ERD) by using the entities and attributes that have been identified above. Make sure you clearly identify the relationships between the entities and their cardinality.
Note: For information regarding the ERD shapes, refer to the CBDA2103 module (Topic 4).