Computer Science-Database Unit III

These are two separate assignments.

Unit III Project

For this assignment, you will continue to work with the scenario you began in Chapters 1 and 2. The initial scenarios are discussed on pages 17-18 of your textbook and are continued on pages 40-43. (Again, the “Westlake Research Hospital”scenario will act as an example throughout this course.)

Instructions:

1. Reread the introduction to your selected scenario on page 17 or 18 and the continuations on pages 37-41.
2. Read your scenario for Chapter 3 on pages 60-61.
3. Review the “Deliverables” section below.
4. Review the “Suggestions for Scenarios” section on page 61 of your textbook for important details and ideas to
   assist you with your deliverables.
5. Read the “Westlake Research Hospital” scenario on page 18, pages 41-44, and page 61. Click here to review the
   suggested answer for this scenario to gain an understanding of what is expected of you on this assignment.

ITC 4150, Database Design and Implementation 3

Scenario

Page Number for “To Do” List

Wild Wood Apartments

Page 17-18

Vince’s Vinyl

Page 18

Grandfield College

Page 18

Scenario

Page Number for “To Do” List

Wild Wood Apartments

Page 39

Vince’s Vinyl

Page 40

Grandfield College

Page 41

6. When you have completed all of the deliverables, compress the files together into a single .zip file for upload. Contact your instructor if you have any questions.

Deliverables:

1. Complete the tasks in the “To Do” section at the end of your scenario. The table below shows where you can find each list:

Conger, S. (2014). Hands on database: An introduction to database design and development (2nd ed.). Upper Saddle

River, NJ: Pearson.

Unit III Scholarly Activity

Using the SQL for Dummies textbook in the CSU Online Library, refer to Table 3-4 “Types of Protection” on page 74 to create three scenarios in which the use of protection operations are used to secure a database. Describe the scenario, select which protection operations users should use in the scenario, and then explain your selection.

Your paper should be three pages in length. All sources used, including the textbook, must be referenced; paraphrased and quoted material must have accompanying citations, and cited per APA guidelines.