First, you will define the company's business requirements and design the database schema, showing in detail all the relations $($tables$),$ data types, relationships, and constraints to be used in the database. After the design phase is over, you will implement the schema in Oracle by creating the required tables with appropriate data types together with relationships and constraints, and populate all the relations with valid data. Last, you will use your database to retrieve the required data using complex SQL queries.

In this assignment, you need to include the following:

A short description of the company $($you can use just one department or business process if the company is large$)$

Reasons why the company needs a database

Detailed business requirements that describe all entities, relationships, and constraints from the business perspective. Do not include more than $4-5$ entities! It is very difficult to design a large database without prior experience. Your database will be revised in the following assignments and you will have a chance to make it more complicated later on$.$

A detailed description of each entity including the name, purpose, and attributes. Description of relationships between entities. Make sure to evaluate each relationship in both directions!

A list of different users for the database you proposed. Define user categories and describe different types of applications each user would need. Explain what type of interface each user would need.

Explain which DBMS architecture would you choose from section $2\mathrm{.}5$ of the Fundamentals of Database Systems textbook and why. Why would the other architectures not be a good choice?