Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

Database Evaluation Essay – unicorp essays


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 a brief 400 to 500 word 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

Formatting & Sources
Please write your paper in APA format,  you may also use other sources as needed, make sure you cite them using APA format, please also cite them in APA.



Source link

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"