Required Items for Project

Detail of the scenario

Developing ERD

Defining at least $7$ Entity

Defining attributes

Defining all necessary relationships $($Identify with matrix diagram$)$

If possible superype$-$subtype, arc and hierarchical structures, non$-$ transferable relationship.

Preparing "table instance chart" to map ERD to DB structure

Writing SQL DDL statements for implementing ERD $($create table, constraints, defining keys: pks and fks$)$

Making Physical Database using APEX

Entering data to the Database

Writing SQL DML Statements to reach information

One statement including subquery

One statement including ioin

One statement including group by

One statement including date function

One statement including character function

One statement including update

bne statement including alter table

Inventory control management Database Project

Design goals: maintain a proper variety of required items, increase inventory turnover, reduce and maintain optimize inventory and safety stock levels, obtain low raw material prices, reduce storage cost, reduce insurance cost, reduce taxes.

Tables: Products, Product Categories, Customers, Suppliers, Credit Sales, Purchases, Sales, Customer Orders.