Answered step by step
Verified Expert Solution
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
- 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)
- 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)
- 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
- rovide a Data Dictionary for both the Departments and Locations tables. Ensure you identify: table names, primary keys, and foreign keys.
- 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.
- 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started