Statement of Work
History: Vince Roberts runs a vintage record shop in the university district. His
shop sells 45s, LPs, and old 76 RPM records. He uses most of his stock. Hey buys
used vinyl from customers or finds them at yard sales and discount
Lab: Running SQL Queries
The purpose of this lab is to help you design SQL queries to test the business rules.
By now you should have a basic database in place for the Wild Wood Apartment scenario. Now
Lab: Installing SQL Server 2008
The purpose of this lab is to familiarize you with the procedure involved in initial installation of
Microsoft SQL Server.
A key requirement of modern information technol
Current Issues, Database Requirements, and
Current Systems Issues
Vince doesnt have a system to keep track with his inventory
Vince needs a better method to track his sales
Vince needs a way to track how much money he spends buying hi
Authentication and Authorization Plan, Threat
Analysis, and Preliminary Disaster Plan
All users will be authenticated through a windows user account
These accounts will be monitored by an active directory account that is attached
The requirements are software, company, start/end date, and the terms.
The requirements are version, license type, pricing, pricing unit.
Access and security requirements:
Questions I would ask:
1. Who is the patient?
2. Where does the patient live?
3. Does the patient have any pre-existing conditions?
4. Is the patient on any form of medication?
5. Does the patient have suicidal tendencies?
1. When a primary key is repeated to make a relationship foreign key
2. Which of the following is the best describes an attribute something that describes part
of the entity
3. Is providing a user friendly graphical interface part of a good database False