Project Study Guide
Tuesday, October 25, 2016
Max Submissions Allowed:
Word 2016 Module 1 - Textbook Project
10/24/2016 11:18:00 PM
Launch All Training
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file
from the SAM website.
Shelly Cashman Excel 2016 | Module 1: SAM Project 1a
Blooming Everywhere Delivery
CREATING A WORKSHEET AND A CHART
Chapter 8 Review Question Answers
What are BI systems?
Business Information (BI) systems are information systems that assist managers and other
business professionals to (1) analyze current and past events and (2) predict future events.
How do BI
Chapter 4 Review Question Answers
Name the three stages in the process of developing database systems. Summarize the
tasks in each.
Requirements Analysis: Users are Interviewed, sample forms, reports, queries, and
descriptions of update activities
Chapter 2 Review Question Answers
Why is the relational model important?
It is the single most important standard in database processing and is used for the design and
implementation of almost every commercial database worldwide.
Define the term e
Chap 3 SQL Assignment
Select make, model
Select CustomerID, LastName, FirstName, Address, City, State
Where State <> FL;
Microsoft Access is a personal database system. Which of the following is a characteristic of a personal database system?
O the DBMS removing the metadata from the database
0 the DBMS product taking the role ofthe DBMS and the database application
Quiz 3 Chapters 5 & 6
The entity "cars" would be this type of entity if another entity called "vehicles" existed in an ER-Diagram.
This occurs when there is an indirect relationship that caus
Quiz 5 - Chapters 9 and 10
_ requires that all SQL requests of a transaction be completed.
The _ keeps track of all of the processes that update the database.
Quiz 4 - Chapters 7 and 8
This type of join returns all rows with matching values in the matching columns and eliminates
Which type of join operation returns not only the rows matching the
6 / 6 pts
Jennifer is updating the database for her company. She wants to delete customer records that have not
made a purchase from more than 5 years ago but when she tries the database tells her that she can't
because she must firs
LAB 4 COP 3703
actor_id AS 'Actor ID',
last_name AS 'Last Name',
first_name AS 'First name'
ORDER BY last_name , first_name;
Score for this quiz: 30 out of 30
Submitted May 22 at 7:22pm
Teacher to Students is an example of this type of relationship.
The _ is the conceptual organization of the entire database as viewed by
LAB 6 COP 3703
PART I SQL Stored Procedures
Stored Procedure #1 Overview
1. CREATE PROCEDURE uspGetAddress
SELECT * FROM [AdventureWorks2012].[Person].[Address]
2. CREATE PROCEDURE uspGetProduct
SELECT * FROM [AdventureWorks201
You have started normalizing an ERD, and notice that one of the relations has attributes that are only
partially dependent on part of a composite primary key. This means that the table can only be in _
Chapter 1 and 2
And Installation of SQL and Access
A. Answer the following questions and submit via CANVAS by the specified due
date (you may need to refer to Chapters 1 and 2 for this assignment).
1. One of the biggest challenges of buildin
LAB 5 COP 3703
Select person.title as 'Title', person.firstname as 'First Name', person.lastname as 'Last Name'
Order by person.lastname
Select SalesPersonID as "Sales Pers
Quiz 2 - Chapter 3 and 4: COP3703: Database
Design/Architecture (SLM-M) MRG
Score for this quiz: 30 out of 30
You are designing a new database and need to create an Entity Relationship Diagram. Two of the entities are
employees and benefits. Wh
Chapter 4 Assignment
A locker in a high school gym class is assigned to a single student at a time. However we have more
lockers than students so some lockers are empty. What crow's foot symbols should be placed at
positions 1 and 2 in the init
Chapter 5 Assignment
STOP! This is the REAL assignment that is graded. This is not a practice assignment!
Proceed with this assignment only if you are ready. Remember to compete this assignment by the
I recommend you complete t
Chapter 6 Assignment
You have just created a new table. What type of index should you use for the primary key?
The company, based
Chapter 3 Quiz
Which character is used in a SQL SELECT statement to select all the columns of a table?
See page 148. (7th edition)
Also see the page titled SELECT Clause in the online notes.
Which of the follow
Midterm Part 2
Started: Oct 11 at 1:38pm
STOP! This is the REAL exam that is graded. This is not a practice exam!
Proceed with this exam only if you are ready. Remember to compete this exam by the deadline.
This is a two part exam. You M
CGS 2545C Answers Quiz 1
0 / 1 pts
Microsoft Access is a personal database system. Which of the following is a characteristic of a personal
the DBMS removing the metadata from the database
the DBMS product taking the role of th