Answered: Database Design Before essential oil…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Database Design

Before essential oil products are marketed, testing is carried out based on the production batch of each essential oil. This is done to maintain the quality and content of the constituents in the essential oil. Where the Test Percentage Content must reach the Minimum Percentage Content standard for each constituent. If there is one type of constituent that does not meet the minimum standards, the batch will not be marketed because it does not meet the quality standard.

1. If recording the results of each testing process is still done manually, in your opinion, please explain which approach is suitable between Centralized and View Integration for collecting requirements.

2. What Fact Finding methods will you choose to obtain information related to the development of a database system to record the testing process, and explain the reasons for choosing it.

3. Apply 1-NF, 2-NF, 3-NF Normalization for the available forms

ID Testing:
ID Essential Oil:
Date:
Essential Oil Name:
Observer ID:
Essential Oil Type: Single/ Blended
Observer Name:
Batch Code:
ConstituentID
Constituent
Minimum
Test
Status
Name
Percentage Percentage
Content
Content

Expert Solution

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions