INF322 DQ345

profileshaka
Home>Homework Answsers>Information Systems homework help
  1. Keys
      
    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. 
     
  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
      
    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. 
     
  4. 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.
  5. 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. 
     
  6. 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.

 

    • 12 years ago
    • 11
    Report issue
    Answer(1)
    profile
    penka
    3.9 (123)
    5.0 (2)
    Chat

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      keys.docx