Final Project

Deadline: August $7,4$ pm

Database Design Project Outline

Objective: Develop a comprehensive database design for a fictional company, focusing on

defining entities, attributes, relationships, and converting the logical model to a relational model

then to DDL script.

General Instructions:

$$ The project must be original work. Collaboration within groups is encouraged, but each

group must submit their unique design and documentation.

$$ Use clear and professional language in all project deliverables.

Submission Details: $($submit two files$)$

$1)$ Submit a Word document named group$\_$i$.$doc $($where $"$i$"$ is your group number$)$

containing Parts $1,2,$ and $3$ of your project.

$-$ Include clear labels and headings for each section to facilitate grading.

$-$ List the full names and student IDs of all group members in the document.

$2)$ Submit DDL script named group$\_$i$.$sql $($part $4)$

Part $1$ Company Overview and Product

Company Name: Choose a unique name for the company that does not currently exist.

Company Overview$/$Description: Provide a brief overview of the company, including what it

does and its main products or services. Avoid using content from existing websites.

Product: Select a specific product offered by the company. Define its attributes and identify a

primary unique identifier $($UID$)$ such as product ID or code.

Product Attributes: Example of attributes:model, brand, type, description, size, color, height,

width, price, etc.

Part $2$ Entity Relationship Diagrams $($ERD$)$

Logical Model:

$$ Create an ER diagram using Oracle SQL Modeler

$$ Include the following:

o Entities with their attributes $($indicating mandatory or optional$).$

o Relationship cardinality $($one$-$to$-$one, one$-$to$-$many, many$-$to$-$many$).$

o Optionality of relationships $($mandatory or optional participation$).$

o Foreign keys to establish relationships between entities.

o Named relationships for clarity.

o Unique identifiers

Additional Requirements:

$$ Incorporate the company$$s multi$-$warehouse operations.

$$ Model how products are stored in warehouses, including inventory management.

$$ Ensure the diagram reflects that not all products are stocked in every warehouse.

Part $3$ Relational Model

Convert the Logical Model to Relational Model

Part $4$DDL Script

Generate DDL Script