Why is a key important in a database

Assignment Help Database Management System

Reference no: EM13809735

1. Keys

Why is a Key important in a database? How does it help with Referential Integrity? Lists three compelling reasons why Keys are crucial to table structure.

2. Determining System Requirements

Identify the database or process you would like to begin to think about for your future database design. After you have developed a database idea, you need to plan the interviewing of your users. Interviewing will give you a better understanding of user needs, wants, and desires, as well as help you to determine your system requirements. What questions should you ask? How do you think this will help you in determining your table and field requirements? When do you think it would be important to make these decisions? Respond to at least two of your classmates' postings.

3. Table Relationships

Discusses table relationships. Define one type of relationship (one-to-one, one-to-many, many-to-many and self-referencing relationships) and provide an example of this type of data relationship. Respond to at least two of your classmates' postings.

4. Business Rules

There is a great deal of information to consider when planning business rules. Think of a business rule from a place you have been employed at and use that in an example. This could be around defining user access or field specific data, deciding if a field is required or if a field has data validation. How effective was the application of the business rule? Please be specific in your example. Respond to at least two of your classmates' postings.

Views

5. There are three types of views. Pick one of them and provide a definition, an example of that type of view, and when you would use the view. If you have ever purchased anything online and returned to the vendor Web site, many views of data will be accessible when you login, including your previous orders, their catalog of product, and even your shipping and credit card information. Think of examples like this before you respond. Respond to at least two of your classmates' postings.

6. Bending the Rules

Discusses bending or breaking the rules. Can you think of a situation where you would apply this practice? List an example and which rule you would be bending or breaking. Respond to at least two of your classmates' postings.

Reference no: EM13809735

Questions Cloud

Market and manufacturing requirements : Discuss the market and manufacturing requirements that make it appropriate to use MRP and Just-in-Time.

Hipaa and hitech regulations : HIPAA and HITECH regulations

Define and describe active listening : Define and describe Active Listening.

Write an essay about transportation problems in the city : Write an essay about transportation problems in the city.

Why is a key important in a database : Why is a Key important in a database? How does it help with Referential Integrity? Lists three compelling reasons why Keys are crucial to table structure

Write a research paper about the cloud computing : Write a research paper about the cloud computing.

The impact of culture on communication in the health care : The impact of culture on communication in the health care

Projects in controlled environments interpretations : Post your summary of a systems view of a project. Analyse the Project Ma nagement Body of Knowledge (PMBOK) and Projects in Controlled Environments interpretations of the systems view. Evaluate the strengths and weaknesses of each interpretation.

Analysis of how laws guided the development of nhss : Identify at least three primary U.S. laws that established the Department of Homeland Security (DHS), and direct the department in its operations. Provide a brief description of these laws as they apply to the DHS.

User Account

All Pages