PT2520 Database Development
Final Exam Study Guide
At minimum, what must you specify when creating a database in SQL Server Management Studio?
a. Database name
b. Database size
c. File location
d. Login credentials
A columns data typ
Unit 8 Lab
Views, Stored Procedures, and Backup
Unit 9 Lab 9.1 (Group A) Harden SQL Server and a Database
1. Which authentication mode is enabled?
SQL Server and Windows Authentication Mode
Step 7: Create and test an application role named PatientDataRole in the W
Unit 4 Labs
Lab 4.1 Normalize a Database Design Step-by-Step
1. In order to normalize the PatientVisit table I created the additional entity
PatientVisitSymptoms with the following attributes:
Unit 4 Research Assignment
Functional Dependency is defined as such: A Functional Dependency on a relation schema R is a
constraint X -> Y, where X and Y are subsets of attributes of R. Definition: an FD is a
relationship between an attribute "Y" and a de
Unit 4 True or False
Unit 4 True/False Questions
Normalization is the process of removing anomalies from database design.
Not being able to insert data because other data is required is an example of an insertion
Unit 7 Lab
Unit 7 Lab 7.1 (Group A) Writing Queries to Modify and Join Data
1. How many rows were affected?
2. How many rows were returned?
One row was affected.
Four rows were returned.
Execute a query that assign
Unit 2 True or False
SQL: A Brief History
SQL, short for Structured Query Language, is a programming language designed for
managing data held in a relational database management systems (RDBMS).SQL consists of a
data definition language and a data manipulation language. The s
1. 4 rows were returned.
2. 2 columns were returned.
3. SELECT * FROM Patients
4. SELECT FirstName, LastName, PhoneNumber FROM Patients
5. SELECT LastName FROM Patients WHERE DoctorKey = 123
6. It told me that there were 2 patients, but did not list them
Unit 9 Research Assignment
Unit 9 Research Assignment 1: Disaster Recovery
The best defense is a good offense. A combination of policies, backup procedures, and
recovery procedures come together to form a good Disaster Recovery.
Unit 8 True or False
Unit 8 Assignment 1: Homework
True / False Questions
Authorization is the process of assigning permissions to users.
Authentication is the process of assigning permissions to users.
In SQL Server, a login provides dat
Unit 6 True or False
SQL is the programming language used to manipulate data and data objects in a
relational database management system.
SQL is a procedural language.
A declarative lan
Unit 7 True or False
Unit 7 True/False Questions
A scalar function operates on one row at a time.
An aggregate function works on multiple rows a time.
Whenever you have an aggregate function in a query criteria, you must use the HAVING
Unit 7 Research Assignment 1
1. What are the advantages of a declarative language as opposed to a procedural language?
The advantage of declarative programming languages is mainly two-fold. The programs are
concise; this makes it easy even for non-program
Unit 6 Research Assignment
Explore the Latest ANSI and ISO Standard
The American National Standards Institute (ANSI) is a non-profit organization that
manages a standardization system for US companies since 1918. The ANSI does not set the