Please help me answer these questions:

Purpose: To demonstrate the ability to normalize and create a database design using MS Visio,

which provides a visual representation of the relational database design.

Instructions:

In today's world, most college students use various types of social media (e.g, Facebook,

LinkedIn, Instagram, YouTube, Twitter and others). Social media usage involves various

features (e.g., Like button, emojis, comment box, upload multimedia content capabilities, etc.)

that allow users to activate various activities (e.g., friending others, sharing pics, posting

statuses, making comments, etc.). Although social media applications are known to be a specific

type of social media (e.g., microblogs, social networking site, professional social networking

site, instant chat or messenger, live stories, etc.), social media often support similar features and

activities. Users tend to make use of social media for different periods of time for various

reasons and purposes.

At CSUF, there are several faculty members who conduct research on social media usage. The

researchers want to know who uses social media, what types of features or activities could be

found in the various social media applications, what purposes do social media users use social

media tools for (e.g., educational, personal, organizational, entertainment, and possibly other

reasons), how long is a user on social media on a daily basis so that weekly or monthly usage

can be extracted, social media value to the user (e.g., whether or not social media is considered a

useful tool and why). Social media users usually use more than one social media and social

media offers many types of activities. Because this will be an ongoing study, the researchers

wish to have a system in place to store the date prior to data collection. Therefore, your team

has been challenged with building a database that will help researchers capture, monitor and

maintain social media users data and their various levels of social media activity and frequency.

The database design should account for the tables, fields, and relationships that will store and

organize the relevant data about student's social media usage and allow users to extract various

reports that may inform the findings.

The proposed database design should contain the following:

Question 1: Using parenthetical method, list the final database design that specifies the tables,

primary keys, and foreign keys. Tables should be normalized and in 3NF. (Hint: Use the

normalization steps provided to you in chapter 2).

Question 2: Create a visual representation of your database design using Crow's foot notation. The

ERD diagram should include all of the elements (entities, attributes, relationships,

cardinalities). (Hint: Differentiate weak versus strong entities, illustrate non-identifying

versus identifying relationships, notate the PK, and justify minimum and maximum

cardinalities).

Question 3: During implementation, various constraints have to be considered in the DDL SQL

syntax. 1) Discuss why referential integrity constraints are a key factor in the

database design. 2) Explain the factors that developers use to determine the

cascading options that will be defined in the database.

Question 4: Create a guideline or recommendation list of items to consider when developing a

database design. (Note: From your experience, think about what you have learned

about the database design process. Then identify suggestions you would give others in

that they may use as a guide when faced with developing a database design solution).