Chris Martin
PT2520
Week 4 vLab
Chris Martin
PT2520
Week 4 vLab
Chris Martin
PT2520
Week 4 vLab
Chris Martin
PT2520
Week 4 vLab
Chris Martin
PT2520
Week 4 vLab
Chris Martin
PT2520
Week 4 vLab
Chris Martin
PT2520
Week 4 vLab
Chris Martin
PT2520
Week 4 vLab
Complete vLab Week2
COMPLETE vLAB WEEK2
PT2520: DATABASE CONCEPTS
STUDENT: Thiery Tchassem
INSTRUCTOR: Gabriel Haynie
Creating Entity Diagrams Using Visio
Task 1- REVIEW REQUIREMENTS AND BUSINESS RULES
Step1: Log in to PC1.
1) Open a word document and li
Scott Cumston 3/23/2013
PT2520 Saturday 165
Database Concepts
Instructor: Robert Freid
Lab 1.1 Explore AdventureWorks Database Using SQL Server Mnagement Studio
Scott Cumston 3/23/2013
PT2520 Saturday 165
Database Concepts
Instructor: Robert Freid
Lab 1.2
Week 6 Submit Project
1
SUBMIT PROJECT WEEK 6
PT2520: DATABASE CONCEPTS
STUDENT: Thiery Tchassem
INSTRUCTOR: Gabriel Haynie
TITLE:COMPILE A DATABASE
PROJECT:
STATEMENT OF WORK (SOW)
Vince Roberts runs a vintage record shop in the University district. His
Scott Cumston 3/30/2013
PT2520 Saturday 165
Database Concepts
Instructor: Robert Freid
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 fir
Scott Cumston
April 27, 2013
PT 2520 Saturday 165 Database Concepts
Instructor: Robert Freid
Unit 6 Lab 6.1 (Group A) Writing SELECT Statements
Question 1: How many rows were returned?
4
Question 2: How many columns were returned?
2
Question 3: What query
Scott Cumston 5/11/2013
PT2520 Saturday 165
Database Concepts
Instructor: Robert Freid
Unit 8 Lab 8.1 (Group A) Implement Authentication, Authorization,
Views, Stored Procedures, and Backup
Doctors
TABLE
Patients
Doctors
Patient Visits
Patient Groups
Drop
Scott Cumston 4/20/2013
PT2520 Saturday 165
Database Concepts
Instructor: Robert Freid
Unit 5 Research Assignment 1: Compare the Different Relational Database Management
Systems
Each value manipulated by an Oracle database possesses a data type. The data
Scott Cumston 4/27/2013
165 Saturday PT2520 Database Concepts
Instructor: Robert Freid
Unit 6 Research Assignment 1:
Explore the Latest ANSI and ISO Standard
ANSI (The American National Standards Institute) coordinates the U.S. voluntary consensus standar
"Electronic files are posted for viewing and limited printing by students who are currently enrolled in ITT
Technical Institute programs and by ITT Technical Institute faculty members. Unauthorized downloads,
duplications, distributions or printings of th
Quiz 1
1.
B
2.
C
3.
D
4.
D
5.
A
QUIZ 2
1.
B
2.
A
3.
A
4.
A
5.
D
Quiz 3
1.
C
2.
A
3.
A
4.
B
5.
D
Quiz 4
1.
B
2.
C
3.
C
4.
C
5.
B
Quiz 5
1.
A
2.
B
3.
C
4.
B
5.
D
Quiz 6
1.
A
2.
A
3.
B
4.
B
5.
C
Quiz 7
1.
C
2.
C
3.
B
4.
A
5.
B
Quiz 8
1.
B
2.
D
3.
B
4.
B
5.
C
Scott Cumston 3/30/2013
PT2520 Saturday 165
Database Concepts
Instructor: Robert Freid
Lab 2 Week 2
Lab 2.1 Identify Business Rules, Attributes, and Candidate Keys
(Group A)
List of questions:
What type of patient information should be stored in the data
Scott Cumston 3/30/2013
PT2520 Saturday 165
Database Concepts
Instructor: Robert Freid
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 (RD
Scott Cumston 4/20/2013
PT2520 Saturday 165
Database Concepts
Instructor: Robert Freid
Labs 5.1 (Group A) Create a Database Step by Step
Lab 5.2 (Group B) Create a Database
Scott Cumston 4/6/2013
PT2520 Saturday 165
Database Concepts
Instructor: Robert Freid
Unit 3 Research Assignment 1
Naming Conventions
As in programming, camel casing would be the choice for me. The whole idea is to make it
clear, consise and easy to read.
Scott Cumston 5/11/2013
PT2520 Saturday 165
Database Concepts
Instructor: Robert Freid
Unit 9 Lab 9.1 (Group A) Harden SQL Server and a Database
Step 4:
1. Which authentication mode is enabled?
SQL Server and Windows Authentication Mode
Step 5:
3.
4.
Step
PT2520
Database Concepts
Unit 1 Assignment 1: Homework
Saul M Sadler
INST: Roger Lyles
Assignment Requirements
Answer the following true-or-false questions.
1) At its simplest, a database can be seen as a collection of related data. TRUE
2) A delimited fi
PT2520
Database Concepts
Unit 1 Research Assignment 1: Exploring Programming Languages
Saul M Sadler
INST Roger Lyles
Assignment Requirements
Use the Internet and the ITT Tech Virtual Library to research the following questions:
1. Look up the history of
* We aren't endorsed by this school
