Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Translate the following business rules into an object relational diagram (ORD) using UMLet. a USER has many ROLES. a USER has one BIRTHDATE. a USER

  1. Translate the following business rules into an object relational diagram (ORD) using UMLet.
    • a USER has many ROLES.
    • a USER has one BIRTHDATE.
    • a USER can have many DEPENDENTS.
  2. Convert the translated diagrams into NoSQL data structures.  
  3. Save the ORD and NoSQL data structure as separate image files.
image

For this week's assignment we will be comparing and contrasting the differences between relational and non-relational database structures. Relational databases have been a successful technology for over twenty years, providing persistence, concurrency control, and an integration mechanism (Fowler & Sadalage, 2012). Data persistence, as the name suggests, is the process of "persisting" data to some physical location. The popularity of relational databases derives from its ability to "make-sense" of complex data structures. Data is categorized into tables, columns, and rows. Tables represent the entities (think JavaScript classes), columns represent the Meta data (think JavaScript properties), and rows are the raw data elements (think values). There are three types of relationships in a relational database system, One-to-Many, Many-to-Many, and One-to-One. Business rules are brief, precise, and unambiguous descriptions of a policy, procedure, or principle within an organization. Diagrams are used to graphically illustrate these business rules and their associated relationships. One-to-Many Relationship Business Rule: a PERSON can own many CARS Object Relational Diagram PERSON 11 owns NOSQL Data Structure: { "cars": [ { }, { "first_name": "Martin", "last_name": "Fowler", "type": "Ford", "color": "White" CAR "type": "Nissan", Many-to-Many Relationship Business Rule: an EMPLOYEE can learn many SKILLS Object Relational Diagram EMPLOYEE 14 One-to-One Relationship Business Rule: an EMPLOYEE manages one RESTAURANT Object Relational Diagram EMPLOYEE There is a movement away from using databases as integration points towards encapsulating databases within applications and integrating through services (Fowler & Sadalage, 2012). This gravitation has resulted in the adoption and evolution of NoSQL database structures. Web communications and transmissions are unstructured data components that require a mechanism for dealing with their complexities. NoSQL technologies bridge this gap by not forcing developers into specific paradigms, rather allowing them to keep the data generic and language agnostic. In a NoSQL world, the above diagrams data structure may resemble the following: 1.1 manages 1.1 RESTAURANT V

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

Database Systems Design Implementation and Management

Authors: Carlos Coronel, Steven Morris

11th edition

9781305323230, 1285196147, 1305323238, 978-1285196145

More Books

Students also viewed these Databases questions

Question

Solve each equation. x 3 - 6x 2 = -8x

Answered: 1 week ago