Question 1
Discuss, in your own words using 500 words or more, the relationship between users and roles in databases. Explain why we use roles rather than simply assigning rights and privileges to each individual user. Consider how to handle new hires and job changes.
Cite your sources in-line and at the end. Provide a URL for your citations. Write in essay format not in bulleted, numbered or other list format. Do not copy without providing proper attribution. Use quotes to indicate where you have used other’s words.
Use the five paragraph format. Each paragraph must have at least five sentences. Include 3 quotes cited in-line and in a list of references. Also, Include an interesting meaningful title.
It is important that you use your own words, that you cite your sources, that you comply with the instructions regarding length of your paper.
Question 2
Assume that a student table in a university database had an index on StudentID (the primary key) and indexes on Major, Age, MaritalStatus, and HomeZipCode (all secondary keys).
Further, assume that the university wanted a list of students majoring in MIS or computer science, over age 25, and married OR students majoring in computer engineering, single, and from the 45462 zip code. How could indexes be used so that only records that satisfy this qualification are accessed?
Need help with this assignment or a similar one? Place your order and leave the rest to our experts!