Discussion Problems
o Describe the main entities or objects of the business function/operation. Specify the attribute that would be the primary key for each entity, and provide a rationale for why you selected such an attribute.
Business Function/Operation for accessing the build and rooms
• Attribute - Fingerprint
• Entity - doors
To be allowed toenter the building, your fingerprint would be the primary key, and the fingerprint will be the unique identifier. With certain credentials, you will be allowed to enter certain rooms inside the building. It will depend on your classification.
o Determine whether the relationships between each of the chosen entities are one-to-one, one-to-many, or many-to-many relationships. Justify your response.
One fingerprint can get you into the building and various rooms inside.Therelationship would be a one-to-many because one fingerprint can open many doors. Without your fingerprint being in the system you would have no access to get in any roomsor the building.
o Explain the key manner in which the business function/operation and the business rules associated with that business function/operation support the relationships mentioned above. Also, explain the fundamental ways in which the relationships could change, based on the interpretation of the given business rules.
The fingerprint is also used to keep track of your time for the week so that you can get paid. So, this could be a one-to-one because your fingerprint calculates your time.