STUDENT NAME:

  12 November, 2016

DATABASE ASSIGNMENT

STUDENT NAME:

  12 November, 2016

DATABASE ASSIGNMENT




Contents

	DATA DICTIONARY	2

	DATABASE

STUDENT NAME:. 12 November, 2016. DATABASE ASSIGNMENT. 

This article describes the Home Inventory Database, including its software tool description, SQL section, security measures, testing and validation strategies. The SQL section includes create commands, select statements, and data display meeting certain conditions. Security measures include a separate table for user login and password, with user types of admin or normal. The testing and validation strategies involve avoiding anomalies and updating the database to meet new requirements. Metrics for effectiveness include a separate table for item images and unique item IDs.

Databases

Home Inventory Database: Software Tool Description, SQL Section, Security Measures, Testing and Validation Strategies

Dissertation

This article provides an Employee Database with ER Diagram, Table Commands, Sample Data, and SQL Queries. It includes Department, Employee, Project, and WorksOn tables. The ER Diagram, CREATE TABLE commands, and sample data are provided. SQL queries include listing employees in alphabetical order of surname, listing female employees, listing managers, listing employees who work for the IT department, listing retiring managers, finding employees managed by James Adams, listing total hours worked by each employee, listing projects with more than two employees, and listing departments with more than 10 employees.

STUDENT NAME:. 12 November, 2016. DATABASE ASSIGNMENT.