1. After reviewing the history on SQL server, I have found that there have been 7 revisions of the
SQL standard. In the most recent, SQL 2011, there were many new non-temporal features. You
have DELETE in MERGE, Pipelined DML, CALL enhancements, Limited f
Unit 7 Lab 7
Unit 7 Lab 7.1 (Group A) Writing Queries to Modify and Join Data
1. How many rows were affected?
One row was affected.
How many rows were returned?
Four rows were returned.
Execute a q
Lab 1.2 Define Major Topics for a Database
New drug, Prozac
Extent of depression, sleeping patterns, activity
Unit 1 Research Assignment 1
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
Unit 2 Research Assignment 1
System Analysis and Design Life Cycle
There are nine parts to the system analysis and design life cycle. The first three stages are
about gathering information. The first part of the cycle is initi
Unit 5 RA 1
Each value manipulated by an Oracle database possesses a data type. The data type of a
value links a selection of attributes to the value. These attributes of the value differentiate one
data type from the other.
Unit 6 Labs
Unit 6 Lab 6.1 (Group A) Writing SELECT Statements
Question 1: How many rows were returned?
Question 2: How many columns were returned?
Question 3: What query did you execute?
Unit3 RA 1
As in programming, camel casing would be the choice for me. The whole idea is to make it
clear, consise and easy to read. There are too many limitations using special characters and
underscores, the largest being the
Unit 9 Assignment 1
Unit9 Assignment 1: List Phases of a Computer Attack
Phase One: Recon and Probing
One of the first steps that attackers take is information gathering, which will give
them an idea about facts of
Unit 9 RA 1
1. Which authentication mode is enabled?
SQL Server and Windows Authentication Mode
Unit 9 RA 1
Unit 9 RA 1
Step 7: C
Unit 7 RA1
1. The advantages of a declarative language as in the case of SQL compared to procedural
languages such as C+, Java, C#, or Visual Basic are in the table I have included. Of course
these languages are not without th
Are there any side effects that happen when taken with other medicines?
Does having high blood pressure affect the effects of the medicine?
What diseases affect the outcome of the medicine?
Does weight decide the dosage of the medicine?
There are many naming conventions that are great to use. Some of which work great for some
people and others work great for other people. I personally like IBMs DB2 naming conventions
because they are very general and very simple. As long as I am within t
True/False Questions for Unit 3
1. The logical design is independent of any database management system.
2. The physical design is the logical design adapted to the constraints and features of the database
3. You should alway
Sometimes finding a good example of things may be difficult to do. Things like finding an
example of functional dependency may prove difficult for some. There was a good example that
I was able to find at http:/discovery.csc.ncsu.edu/Courses/csc440-S08/sl
There are 5 main parts to the Systems Development Life Cycle. These parts are planning,
analysis, design, implementation, and maintenance. I believe that these relate to database
development because when developing a database you just about go through eac
Keyword: Words or Phrases that cannot have the meaning or usage changed
Delete (Delete) ] >Anomolies
* = Wild Card
Select Au.Username, Pro.* Authorization Profile
From [What table(s)] Authroization Au, Profile
Unit 2 Lab 2
Unit 2 Labs
Lab 2.1 Identify Business Rules, Attributes, and Candidate Keys
Do you have patient records in a computer system already?
How is patient info tracked and updated?
How do you process reports?
Unit 4 RA 1
1. Functional Dependencies are removed in the Second Normal Form (2NF). Basically
functional dependencies are groups that depend on each other within an entity. But to
simplify or normalize the form and eliminate a
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 6 RA1
Unit 6 Research Assignment 1:
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 1
True/False Questions for Unit 4
1) Normalization is the process of removing anomalies from database design.
2) Not being able to insert data because other data is required is an example of an insertion anomaly.
3) An insertion anomaly occurs wh