Database Management
Q1.
Discuss the purpose of Views and Indexes. Why are they important? Provide an example of when you would setup an Index in a table (other than the ones in the text).
Q2.
Understanding functional dependencies is necessary to determine which fields belong in a table, and to work through the normalization process. Explain what a determinant is and in turn what is means for a field to be functionally dependent on another field. Using the Owner’s Table below – which field(s) might be determinants, and which fields would be functionally dependent on the determinant? You can assume we assign a unique Owner ID number for each person in the table. We are assuming only information about US personnel with a SS# will be stored in the table. Owners Table:
Q3.
Under what circumstances do you think following a database system lifecycle or database design methodology is a good practice? Give an example (either from your work or personal experience) where you have used a standard approach to accomplish the task. Why might a company or team choose not to use an established methodology? Provide an example.
Q4.
Database Security is an increasingly important topic. Discuss the difference between authentication and authorization; provide an example of each. Additionally, how might a View be used to augment the security?
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
Click ORDER NOW..
