-
Why is a Key important in a database? How does it help with Referential Integrity? Chapter 8 lists three compelling reasons why Keys are crucial to table structure. There is an example of a table and its’ key in Figure 8.2. Respond to at least two of your classmates’ postings.
Need a Professional Writer to Work on this Paper and Give you Original Paper? CLICK HERE TO GET THIS PAPER WRITTEN - 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.
- Table Relationships
Chapter 10 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.
- Business Rules
There is a great deal of information to consider when planning business rules. Now that you have read Chapter 11, 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
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.
- Bending the Rules
Chapter 15 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.