Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Identify two or more restrictions that can be implemented on a database server to increase security? (Note: backups are not a security measure) (Give 3-4

  1. Identify two or more restrictions that can be implemented on a database server to increase security? (Note: backups are not a security measure) (Give 3-4 full sentences, not bullet points)
  2. Identify some cyber security functions, policies and procedures that can be implemented on relational database management systems (RDBMS) that can increase security? (Give 3-4 full sentences, not bullet points)
  3. Identify some cyber security functions, policies and procedures that can be implemented on database contents that can increase security? (Give 3-4 full sentences, not bullet points)P
  4. rovide a Data Dictionary for both the Departments and Locations tables. Ensure you identify: table names, primary keys, and foreign keys.
  5. Research 5 SQL aggregate functions widely available in most databases. Describe the features of each and give an example of where each could be applied to solve a problem. Do not give functions that are specific to one database vendor.
  6. For each of the 10x confirmed business rules above, list the type of SQL statement testing methodology used for each (eg. Field Constraints (datatype, size), Data Integrity Constraints (unique, mandatory, references), Business Rules (range, triggers). This video is part 16 of a series on Database Testing; part 16 is about Integrity testing.
    https://www.youtube.com/watch?v=hn4SPMakHC4

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Operations Management Creating Value Along the Supply Chain

Authors: Roberta S. Russell, Bernard W. Taylor

7th Edition

9781118139523, 0470525908, 1118139526, 978-0470525906

More Books

Students also viewed these Databases questions

Question

Discuss why single-sourcing is attractive to some companies.

Answered: 1 week ago