Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Assignment: PyBookCo you will be learning about normalization and how to build ORD's, given a set of data elements. Normalization is loosely defined as the

Assignment: PyBookCo

 you will be learning about normalization and how to build ORD's, given a set of data elements. Normalization is loosely defined as the process of breaking larger data sets into smaller, more "relatable" objects. Take for example:

image.png

Address1, address2, and address3 imply "many" addresses and first_name/last_name imply "person." Through normalization, the latter becomes: ORD:


 

image.png

 

Now, some of you might be thinking "this looks very close to an entity relationship diagram (ERD)" or "we could normalize the data further." While this does resemble relational databases, we are primarily focused on how to build NoSQL data models, given "some data elements." For the database purest out there, we are shooting for 2NF or second normal form. But, remember, we are not building primary/foreign key relationships or trying to rationalize the data beyond simple relationships. The easiest way to think of this ORD is as a Person object with a nested array of ADDRESS objects, in JSON format.

NoSQL Document Diagram:

image.png


NoSQL Data Structure:

{

    "first_name": "Joseph",

    "last_name": "Haydn",

    "addresses": [

        {

            "address1": "505 Main Street"

        },

        {

            "address2": "500 Maple Road"

        },

        {

            "address3": "7011 Cornhusker Avenue" 

        }

    ]

}


Instructions:

Data Fields:

image.png


  1. Convert the provided data fields into a normalized ORD.
  2. Convert the normalized ORD to a NoSQL document diagram.
  3.  a NoSQL data structure.
  4. Supply your own default values.
  5. Create business rules to support your diagrams.
  6. Save the ORD, NoSQL document diagram, and NoSQL data structure as separate images.
     
     
     

first_name last_name address1 address2 address3

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction to Data Mining

Authors: Pang Ning Tan, Michael Steinbach, Vipin Kumar

1st edition

321321367, 978-0321321367

More Books

Students also viewed these Databases questions