MIS150 BJ Choi
Group Project Instruction
This group project consists of two parts, Part I and Part II:
Part I (50 points) (due on 11/6)
1.
(20 points) Create the ER diagram for the HAFH Realty Company Property Management Database.
2.
(10 points) Create the relational schema for the HAFH Realty Company Property Management Database.
3.
(10 points) Create a data dictionary that documents metadata about tables.
4.
(10 points) Build a relational database with data populated using SQL commands. Part II (50 points) (due on 12/4)
5.
(25 points) Write ten SQL queries and show the results. The sample SQL commands are shown below: a.
WHERE
b.
JOIN
c.
ORDER BY
d.
LEFT OUTER JOIN
e.
GROUP BT
f.
HAVING
g.
Set operations
h.
Subqueries
i.
Aggregate functions
j.
Database updates using INSERT, UPDATE, and DELETE
6.
(15 points) Create your own Entity for the HAFH Realty Company Property Management Database (Requirements: Create two entities with three different types of attributes respectively. Create a new ER diagram and its relational schema).
7.
(10) Build a relational database with your own data populated (at least three records) using SQL commands. Write three SQL queries and show the results.
Sample data dictionary
