About this AssignmentDatabases 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 NormalizationWrite 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 DatabaseTable Structure for ProduceCOLUMN_NAME DATA_TYPE NULLABLEITEMID CHAR (5) NoSUPPLIERID CHAR (10) NoPLUCODE CHAR (4,2) NoPRODUCENAME CHAR (15) NoTYPE CHAR (10) NoSTOCKQTY NUMBER (4,2) NoNXTDELIVERY DATE NoTable Structure for Animal Products:COLUMN_NAME DATA_TYPE NULLABLEITEMID CHAR (5) NoSUPPLIERID CHAR (10) NoANPRDNAME CHAR (15) NoTYPE CHAR (10) NoSTOCKQTY NUMBER(4,2) NoNXTDELIVERY DATE YesTable Structure for Grains:COLUMN_NAME DATA_TYPE NULLABLEITEMID CHAR (5) NoSUPPLIERID CHAR (10) NoGRAINNAME CHAR (15) NoTYPE CHAR (10) NoSTOCKQTY NUMBER(4,2) NoNXTDELIVERY DATE YesTable Structure of Suppliers:COLUMN_NAME DATA_TYPE NULLABLESUPPLIERID CHAR (10) NoLASTDELIVERY DATE YesSPECIALTY CHAR (15) YesACTIVE CHAR (1) NoTable Structure of Purchases:COLUMN_NAME DATA_TYPE NULLABLEITEMID CHAR (5) NoTOTALBOUGHT NUMBER (8,2) YesTOTALSOLD NUMBER(8,2) YesTOTALREV NUMBER(10,2) YesMARGIN NUMBER(10,2) YesFormatting & SourcesPlease write your paper in APA format. You may refer to the course material for supporting evidence, you may also use other sources as needed, make sure you cite them using APA format. If you use any Study.com lessons as sources, please also cite them in APA (including the lesson title and instructor’s name).For This or a Similar Paper Click Here To Order Now
Menu
