Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Normalization and Creation of A Database Design To demonstrate the ability to normalize and creat... Normalization and Creation of A Database Design To demonstrate the

Normalization and Creation of A Database Design To demonstrate the ability to normalize and creat... Normalization and Creation of A Database Design To demonstrate the ability to normalize and create database design using MSVisio, which provides a visual representation of the relational database design. Answer the following: In todays world, most college students use various types of social media (e.g. Facebook, LinkedIn, Instagram, YouTube, Twitter and others). Social media usage involves various activities (e.g. friending others, sharing pics, posting statuses, making comments, etc.). Some social media support specific activities. Get together with your group and discuss the various types of social media that each member uses on a daily basis. Use this information to determine the tables, fields and relationships that should exist in the database design that will help maintain relevant data about students social media usage.

D.Briefly discuss the importance of referential integrity constraint enforcement for database design and explain factors that help determine cascading options.

E.Since you just created a database design in this exercise, explain the major difference between a data model and a database design during the transformation phase.

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

Databases And Python Programming MySQL MongoDB OOP And Tkinter

Authors: R. PANNEERSELVAM

1st Edition

9357011331, 978-9357011334

More Books

Students also viewed these Databases questions

Question

What is the difference between Needs and GAP Analyses?

Answered: 1 week ago

Question

What are ERP suites? Are HCMSs part of ERPs?

Answered: 1 week ago