You have recently been hired as a database consultant for a Silicone Valley startup, XYZ Blogs. XYZ would like to compete in the blogging space directly against big names such as WordPress and blogger.com. In order to do this, it is building a cloud-based system that will allow users to create date-posted blogs. Be sure to carefully review the full document to gain an understanding of the full requirements for this project.

Project Objectives and Requirements by Unit:

Unit	Objectives and Requirements	Submission Type	Minimum Length (Minimum Words/Slides)
1	Identify and submit entities, attributes, and relationships with a detailed narrative explanation of each. Define business rules with a detailed narrative explanation of each.	Draft Final Paper – Section 1 Draft Final Paper – Section 2	500 500
2	Develop Entity Relationship Diagram with a detailed narrative explanation of each.	Draft Final Paper – Section 3	500
3	Create data definition commands for entities, attributes, and relationships with a detailed narrative explanation of each.	Draft Final Paper – Section 4	1000
4	Create SQL commands for all CRUD for tables: users, articles. Create query to count the number of articles written per user. Explain each in detail.	Draft Final Paper – Section 5	1000
5	Research business intelligence, data mining, and data warehouses and report on your findings with a PowerPoint presentation with detailed presenter notes in the notes section of each slide. Be sure to properly cite your sources in-text in slides and/or notes, with references on the last slide.	Draft Microsoft PowerPoint Presentation with Presenter Notes	20
6	Research and compare three cloud-based systems. Make a selection recommendation based on the requirements you have identified. Provide implementation documentation previously created through Units 1 - 5, and recommend implementation, maintenance, and recovery strategies. This final Unit 6 submission includes both the final PowerPoint Presentation and the final paper of which both are inclusive of the previous drafts with edits based on instructor feedback and the additional content assigned in Unit 6, above. Be sure that you apply your instructor’s feedback.	Final Microsoft PowerPoint Presentation with Presenter Notes and Final Paper	34 2500

Project Functional Requirements:

User Accounts

Users will be able to sign up for a free account. They must have confirmed email addresses, valid passwords, and a name. For security purposes, it is good to store when the profile is created, the IP address of the computer with which they created the account with, and the last time the user logged in.

Optional information that users might want to enter would include a description of themselves, a date of birth, interests, and gender.

Articles

Each user will have the ability to write articles. Articles will need to store a title, content (the article), a date created and edited, the id of the user that created the article, and whether the article is ready for publishing.

Groups

Users will have the ability to “follow” a blog. When they login, they will see the latest articles posted by those blogs that they follow.

Additionally, a user will be able to allow other account holders to leave comments if given the permission to.

Answer rating: 100% (QA)

It appears that you have provided a detailed project description and a set of objectives and require... View the full answer