Database
MIS 582 iLab 3 The Week 5 iLab Database Construction Using MySQL
SQL Statements for Lab 3

Designing Database Applications: Course and Student Schedules
Visio ERD for Course and Student database

Office 2013 MyITLab MS-Access Grader Go! – Access Chapter 1: Assessment Project 3: A_CH01_GOV1_A3 – Open Houses
Solution file and tutorial for Go! – Access Chapter 1: Assessment Project 3: A_CH01_GOV1_A3 – Open Houses

Application Assignment 25 Valle Products MS-Access Database
Solution file for Valle Products database project

CSC 352 / 452: Database Programming Project
.sql solution files for questions 2 to 7

Office 2013 MyITLab MS-Access Grader Paterson Credit Union
Solution file for Office 2013 MyITLab MS-Access Grader Paterson Credit Union

Trainer Database Modelling and Normalization
Functional Dependency diagram, normalization steps and ERD for Trainer DB schema

Office 2016 MyITLab MS-Access Grader YO16_AC_VOL1_GRADER_CAP_AS – Real Estate
Solution file for Office 2016 MyITLab MS-Access Grader YO16_AC_VOL1_GRADER_CAP_AS – Real Estate case

DBM 380 Week-2 Database Design and ERD Creation for Art Museum
A MS-Word Memo containing Art Museum Database Design with entities, attributes and keys identification, data types details and ERD.

DBM 380 Week-1 Database Environment Proposal for Art Museum
APA Paper describing database environment for an art museum, conceptual database design, issues and constraints encountered, scope & objectives, specifications.

Perfect Pets Database Case Study
Database Design, entities, attributes, relationships, data dictionary, ERD for Perfect Pets Database case

Perfect Pets Database Case Study
FROM $4.00CS 342 Database Systems Relational Algebra/Calculus Lab 7 Centrepointe Church Database
Solution for CS 342 Lab 7 SQL and relational algebra questions along with screen shots

Office 2016 MyITLab MS-Access EX16_AC_CH04_GRADER_CAP_HW – National Conference
Solution file for MyITLab 2016 National Conference MS-Access case

Academic Paper: Need and Importance of Good Database Design
APA format 12 paged term paper

Office 2016 myITLab MS-Access EX16_AC_CH04_GRADER_CAP_AS – National Farm and Agriculture Conference
Solution file for Office 2016 myITLab MS-Access EX16_AC_CH04_GRADER_CAP_AS – National Farm and Agriculture Conference case

Office 2016 myITLab MS-Access EX16_AC_CH03_GRADER_CAP_AS – Retirement Accounts
Solution file for Office 2016 myITLab MS Access EX16_AC_CH03_GRADER_CAP_AS – Retirement Accounts case

Sales Order Database: DB Construction Solution
Paper describing normalization of tables for sales order database and respective DDL statements.

Sales Order Database Normalization Solution
Academic paper on normalization of sales order database.

Sales Order Database DB Schema and ERD
Paper describing database schema for Sales Order Database, the ER diagram and learning outcomes during its construction.

Online Vehicle Sales Inc. (OVS) case study solution Part II
SQL stored procedures for OVS study case.

Online Vehicles Sales Inc. (OVS) case study solution Part I
Solution containing SQL DDL statements to create and populate database tables for OVS DB case study.

MIS 204 Stocks Database MS-Access Solution
MS-Access database tables and queries solved for MIS 204 case.

MIS 582 MySQL Inventory Database Construction Solution
Database construction solution for mySQL inventory database, includes data dictionary, entity relationship diagram and SQL scripts
