About this Assignment
Databases store, organize, collect, and retrieve data, and, given the amount of data some databases store, how they’re built can seem disjointed and confusing. To overcome these obstacles and make databases useful, computer scientists developed complex algorithms and database designs to create efficient and accessible databases. Relational databases are an example of this type of solution. They store data in tables that are related by different unique keys so that relevant data is stored together, but different data combinations can still be retrieved using the unique identifying keys.
In this assignment, you will explore these topics by evaluating a miniature database and identifying its core components.
Database Normalization
Write an essay that evaluates the miniature database below. Your essay should identify which version of database/SQL it uses, explain the database’s level of normalization, and the choice of keys and dependencies.
Miniature Database
Table Structure for Produce
COLUMN_NAME DATA_TYPE NULLABLE
ITEMID CHAR (5) No
SUPPLIERID CHAR (10) No
PLUCODE CHAR (4,2) No
PRODUCENAME CHAR (15) No
TYPE CHAR (10) No
STOCKQTY NUMBER (4,2) No
NXTDELIVERY DATE No
Table Structure for Animal Products:
COLUMN_NAME DATA_TYPE NULLABLE
ITEMID CHAR (5) No
SUPPLIERID CHAR (10) No
ANPRDNAME CHAR (15) No
TYPE CHAR (10) No
STOCKQTY NUMBER(4,2) No
NXTDELIVERY DATE Yes
Table Structure for Grains:
COLUMN_NAME DATA_TYPE NULLABLE
ITEMID CHAR (5) No
SUPPLIERID CHAR (10) No
GRAINNAME CHAR (15) No
TYPE CHAR (10) No
STOCKQTY NUMBER(4,2) No
NXTDELIVERY DATE Yes
Table Structure of Suppliers:
COLUMN_NAME DATA_TYPE NULLABLE
SUPPLIERID CHAR (10) No
LASTDELIVERY DATE Yes
SPECIALTY CHAR (15) Yes
ACTIVE CHAR (1) No
Table Structure of Purchases:
COLUMN_NAME DATA_TYPE NULLABLE
ITEMID CHAR (5) No
TOTALBOUGHT NUMBER (8,2) Yes
TOTALSOLD NUMBER(8,2) Yes
TOTALREV NUMBER(10,2) Yes
MARGIN NUMBER(10,2) Yes
