Assignment: PyBookCo you will be learning about normalization and how to build ORD's, given a set of
Question:
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:
Address1, address2, and address3 imply "many" addresses and first_name/last_name imply "person." Through normalization, the latter becomes: ORD:
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:
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:
- Convert the provided data fields into a normalized ORD.
- Convert the normalized ORD to a NoSQL document diagram.
- a NoSQL data structure.
- Supply your own default values.
- Create business rules to support your diagrams.
- Save the ORD, NoSQL document diagram, and NoSQL data structure as separate images.
Introduction to Data Mining
ISBN: 978-0321321367
1st edition
Authors: Pang Ning Tan, Michael Steinbach, Vipin Kumar