Description
Hi, I would like to receive detailed answers on the attached questions. Need only any 4 questions answered out of the 6. References are also attached. I need to this to be delivered on 4/20/2021, at 9:00 PM PST.
Unformatted Attachment Preview
Purchase answer to see full attachment

Explanation & Answer

View attached explanation and answer. Let me know if you have any questions.
Question One
Properties of a Good Database Design
1.
2.
3.
4.
5.
6.
7.
Presents all the projected Data over time.
Easy to understand
Allows access to all the data
The problem at hand is presented in real- world structure
Avoids duplication of data
Allows access of multiple users
Allows easy maintenance of data
Properties of bad database design
1.
2.
3.
4.
5.
6.
Data integrity not protected
Poor documentation
Normalizing of data is ignored
Poor design
Weak naming standards
Reference data not stored properly
Functional dependency- in database management, functional dependency is a constraint that
determines the relationship of one attribute to another. It’s used in maintenance of quality data.
Possible sources of information in functional dependency
1. Reflexivity
2. Augmentation
3. Transitivity
c. MyTinyStore
Customer_LastName Drink_Item
Food_Item
Delivery_method
Smith
Iced_Tea
Burger
Not_Delivery
Smith
Coke
Hot Dog
Delivery
Paul
Coke
Hot Dog
Carry out
Sara
Coffee
Noodles
Carry out
We find out whenever a customer takes coke (as a drink) then he/she takes Hot Dog as a food item.
Therefore drink item attribute uniquely identifies the food item. If we know the drink item we can
know the food item he will take.
Therefore food item is a functional dependent of the drink item
Drink item > Food item
Question 5
Differences/similarities between SQL implementation and the traditional methods
SQL implementation – process of installing a database software, configuring, customizing, testing,
running, testing integrating and thereafter training the users.
Procedure.
1.
2.
3.
4.
5.
6.
Install the DBMS
Setup the variables
Creation of database and tables
Loading the data
Setting up users and security features
Implementation of backup
Traditional database methods – they were designed to store correlational records
They are the:
a) Relational mode
b) Hierarchal model
c) Network model
Advantages of the NOSQOL database
1.
2.
3.
4.
5.
6.
7.
Can store unstructured, semi-structured or structured data.
Friendly to the developer
Can take advantage of the cloud so as to deliver zero downtime
Can handle huge volumes of data
Requires no advanced expertise
Can be scaled
Requires less support
QUESTION 2
Unnormalized relation – it’s also called a NON – first normal form (NF2). It contains repeating groups
and entities do not need to be first singled out and satisfies all the properties of a relation.
It therefore lacks the efficiency of a database normalization.
Developing normal forms from 1NF to BCNF.
Normalizing a database is reducing the data redundancy and eliminating not so desirable char...
