Describe in detail the role of the constraints

Assignment Help Management Information Sys

Reference no: EM133545407

Problem: Entity Types and Relationships

You need to turn your attention to the business requirements. A typical business requirement might be that all employees are at least 16 years of age. Regardless of the selected RDBMS, business requirements are ultimately enforced by implementing database constraints on tables and columns. These constraints include:

1) A NOT NULL constraint
2) A unique constraint
3) A primary key constraint
4) A foreign key constraint
5) A check constraint

Database designers implement some and/or all of the above database constraints to meet the business requirements established during the analysis phase of the Database Life Cycle.

In your initial post, provide two examples of new business requirements and the database constraints that could be implemented to enforce them. Describe in detail the role of the constraints and provide the SQL statements required to create them in the database. Explain the advantages and disadvantages of implementing database constraints as well as any potential performance issues your database constraints may cause.

Reference no: EM133545407

Questions Cloud

Which food in the second least-predominant ingredient : brown sugar, enriched flour, cinnamon, salt, and calcium carbonate. Which food in the second least-predominant ingredient in the cereal

How could data mining and analytics be used to detect fraud : How could data mining and analytics be used to detect fraud in health insurance claims? How could private insurance companies and public government agencies

Concept of whiteness and american film : How do you think Hollywood has influenced your ideas, your understanding, and even your acceptance of those groups (Italian Americans, Latinos, etc.)?

What changes could be made to improve a firm performance : what changes could be made to improve a firm's performance is supporting its expatriates to optimize their international Simon success, including repatriation.

Describe in detail the role of the constraints : Describe in detail the role of the constraints and provide the SQL statements required to create them in the database.

What would you expect the specific gravity of the urine : If a patient had been given a large volume of fluid via an intravenous (IV) infusion what would you expect the specific gravity of the urine to be as a result

What types of jobs do you think will not work with this type : What are the advantages of The Body Shop's open hiring program? What are its' disadvantages? What types of jobs do you think will work best with this type

Technological threat of big data : According to Harari, one of the primary dangers of the 21st century is the technological threat of Big Data.

How does photosynthesis work : How does photosynthesis work at the molecular level in plants? Come up with a hypothesis

User Account

All Pages