Describe main entities or objects of the business function

Assignment Help Database Management System

Reference no: EM131493065

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.

Reference no: EM131493065

Questions Cloud

What role does your relationship with the land play : What role does your relationship with the land play in your health and the health and well-being of a community?

Analyze reason why entity relationship modeling is important : Analyze the key reasons why entity relationship modeling is important, and determine at least way in which it impacts the overall development of the database.

How does a dual-slope a-d converter work : What is Shannons sampling criterion? How does a successive approximation A/D convener work?

Case report - jubilee mines nl vs riley : HA3021 Corporations Law Evaluation of Group Report. Write a 2000 words report on given case, the case name: JUBILEE MINES NL VS RILEY (2009)

Describe main entities or objects of the business function : Describe the main entities or objects of the business function/operation. Specify the attribute that would be the primary key for each entity.

Identify the business rule associated with business function : Identify the business rules associated with your selected business function. Explain the manner in which such business rules would impact design of a database.

Demonstrate a strong thesis supported by research : Identify specific risks, evaluate the method/s to use, and analyze the probable outcomes

What is the maximum allowable conversion time for the a-d : An A/D convener is required to digitize a I kHz. sinusoidal waveform. What is the maximum allowable conversion time for the A/D?

Services for new year world exposition : Great Lakes Clinic has been asked to provide exclusive health care services for new year's World Exposition. Although flattered by the request

User Account

All Pages