Assessment Task:
Relational Database Design and Development Computer Science Reflective Report Assessment Answer

Background

You have been asked to develop a database that supports the needs of a small company’s blog. There are six members of staff, any of whom can work on blog entries. These blog articles can be written by a single member of staff or a combination of staff. The articles are text-only and need to be stored in a database in such a way that the author or authors can be identified easily. Members of the public can make comments about the articles but can only do so once they have signed up to the company’s website. These members of the public must also be stored in the database. One of the features of the database is that the comment creators must be linked to the comments that they create as well as the link between these comments and the articles they are related to.

Requirements

  • The database must keep a record of

o Members of staff

o Members of the public who have signed up on the website

o Articles

o Comments

  •  It must be possible to identify who wrote the articles
  • It must be possible to see who created comments
  • It must be possible to see which comments are about which articles.

Part 2 - Tasks

Task 1

A. Using the information given in the case study, draw an Entity Relationship Diagram for the database system. The ERD must include the primary keys identified and any foreign keys that you think are required. The ERD should fit on ONE page and MUST be produced electronically. Hand drawn diagrams will receive NO marks. There are a number of free or trial-period ERD drawing software packages that you can use.

Task 2

A. Create a data dictionary for the tables you have identified in your ERD. Don’t forget the intersection tables for any many-to-many relationships. The tables should contain a logical range of attributes and clearly indicate the keys. For each table, the data dictionary should include the following:

i. The attributes for the table, as they will be named in the database

ii. The data type and size you have chosen for each attribute

iii. Where appropriate, whether an attribute is a primary or foreign key

iv. For foreign keys, the table they relate to. 

B. Create the database and populate each table with a minimum of 10 records.

C. Create 5 queries that can support the needs of the business. The queries must:

Write a reflective report on the way you developed the database and how you chose the queries.

 

This Computer Science Assessment has been solved by our Computer Science Experts at UniLearnO. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : Mitchell Lee
  • Posted on : December 18th, 2018

Whatsapp Tap to ChatGet instant assistance