Court System Database System Project

For our course project, students will design a database system for a federal court system called QUECOURT that has court buildings in multiple cities within the $50$ U$.$S$.$ states. Students will work in groups of up to five students. The project is divided into $6$ parts, and each has a fixed due date for submission.

Part $1$: Project Description and Oracle Installation

Part $2$: Project Description Revised and E$-$R Diagram

Part $3$: Oracle DB System

Part $4$: Data Manipulation $($SQL queries, update and delete statements$)$

Part $5$: DB Applications $($PL$/$SQL Code$)$

Part $6$: DB Refinement $($Normalization$)$

Part $1$: Project Description and Oracle Installation

The project description lists all the requirements that defines the environment of the database system. It should contain information for the conceptual design that is the process by which the enterprise is examined to determine entity types and relationships among these entities, and the entity analysis that is concerned with determining the entities, their attributes, and the relationships among them. You will use the project description defined in this part to design an E$-$R diagram in part $2$ of the project. Hence, be sure that your description includes the requirements listed below plus additional requirements assumed by your group sufficient to at least identify eight entity sets, and nine relationships. Your relationships should include at least one of each from the following characteristics: binary, unary, ternary, one$-$to$-$one, one$-$to$-$many and many to many. Your project description needs to be original no copied from some other place, and it must include the following requirements.

Mandatory Requirements:

The court system needs to store information about each of their buildings. Some of the information needed include the identification of areas for criminal court hearings, family case hearing, small claims, and civil cases. The court system also needs information about libraries available within the buildings, detention facilities, meeting rooms and office space.

The federal court system needs to store information about their current and old court cases. Information needed includes lawyers and parties involved, description of cases, rulings, findings, orders, and dates of each event.

The court needs to keep record of judges.

The court needs information about threats incidents.

Information about employees should include their education, certification, criminal record, etc.