Home

A: Problem Description

In this assignment, we have developed a complex database system for an "ABC Company". The company's products, parts, vendors, customers, departments, jobs and applicants, interviews, marketing sites, supplies, and salaries are tracked in a relational DBMS, conforming to the third normal form. An EER diagram and dependency tree illustrates the requirements, a schema details their implementation, and SQL statements implement the schema. Additionally, views provide important information that is not obvious from the database state, and several queries provide further insight into various aspects of the state. Made by Max Hogan and Daniel Sawyer

Navigation as follows:

• Home(A): Problem Description
• B: Individual contribution breakdown
• C: Project questions (Answer questions listed in this project).
• D: EER diagram with all assumptions.
• E: Relation schema after normalization.
• F: All requested SQL statements.
• G: Dependency diagram.