We're Open
+44 7340 9595 39
+44 20 3239 6980

Coursework 2: Database Design and Implementation using MS Access

  100% Pass and No Plagiarism Guaranteed

Coursework 2: Database Design and Implementation using MS Access

Summary

This is a group coursework worth 40% of the total module mark. It requires developing of a database using MS Access which 
stores information about the course of study as well as personal information about each student, application forms for entering 
data and application reports for querying and presenting the information. It finishes with a group and an individual report. Each 
student will work in a group of 4-5 students belonging to one course and approved by the teaching team prior to starting the work

Tasks                                                                                               Mark

 

1.        Construct a data model for the persistent data                                            max 10%
2.        Specify a data dictionary for the database                                                  max 10%
3.        Implement a database                                                                                  max 5%
4.        Populate the database with test data                                                           max 5%
5.        Design database queries                                                                             max 10%
6.        Implement forms for entering data into the database                                 max 10%
7.        Implement reports for presenting information stored in the database       max 10%
8.        Write a group report to present the group work                                           max 20%
9.        Write an individual report to present the individual work                             max 20%
 

Requirements

 
  1. 1.    Model
  2. 2.    Data Dictionary
·         The model must be relational with at least 4 different relations (tables)
·         Each relation must be identified using suitable primary key
·         The relations must be described using suitable attributes (columns)
·         The attributes could be constrained using suitable constraints (i.e., unique, not null, equal/not equal to, greater/smaller 
than, later/earlier than, etc.)
·         The relations could be interlinked using suitable pairing of foreign keys/unique keys
·         The model must be illustrated using suitable diagram (i.e., entity-relationship diagram or data diagram produced 
using a graphical editor or directly using MS Access)
  • The data dictionary must specify the entire schema of the database
  • Each table specification must describe its columns using information about the name, data type and constraints as well as its role in the table (i,e., primary key, unique key, foreign key, indexed field, hashed field, etc.)
  • The data dictionary must be presented in a suitable format (you can draw a table using Word or other editors, or you can take a screenshot in Design View of Access)

 

 

  1. 3.    Database
  2. 4.    Test data
·         The database must be stored in a single MS Access file named using combination of the code of the workshop group, 
the name of the group and the Student ID (i.e., W1-A-123456789)
·         The database must include both the database tables of the database designed by the group and the individual database 
forms and database reports created by the student
  • Each table in the database must include at least 5 records of data in it
  • The test data in each student database must be different from the data of the other members of the same group

5. Queries

  • Each student in the group must design at least one query for entering data and implement at least one form for entering data into one table
  • The queries and the forms of the students in each group must be different for each member of the same group
  1. 6.    Database forms
  2. 7.    Database reports
    1. 8.    Written Group Report
  • Each student in the group must design at least one query for storing data and implement at least one form for entering data into one or more tables
  • The queries and the forms of the students in each group must be different for each member of the same group
  • Each student in the group must design at least one query for retrieving information from one or more tables and implement at least one report for presenting it
  • The queries and the reports of the students in each group must be different for each member of the same group
  • Each group must prepare one written report to present the data model, data dictionary and database implementation
  • The group report must by made available to all members of the group and must be submitted together with the individual report
  • The group report must be named using the name of the workshop group and the name of the group (i.e,  W1-A.pdf)

Notes on the Assessment

  • You must not forget to include:

ü  Linking the tables using pairing of foreign keys and primary keys

ü  Indexing the tables using unique keys

ü  Forms for entering data into more than one table

ü  Reports for presenting information retrieved from more than one table

ü  Data validation in the forms

ü  Data statistics in the reports, etc.


100% Plagiarism Free & Custom Written,
Tailored to your instructions


International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

UK Registered Company # 11483120


100% Pass Guarantee

STILL NOT CONVINCED?

View our samples written by our professional writers to let you comprehend how your work is going to look like. We have categorised this into 3 categories with a few different subject domains

View Our Samples

We offer a £ 2999

If your assignment is plagiarised, we will give you £ 2999 in compensation

Recent Updates

Details

  • Title: Coursework 2: Database Design and Implementation using MS Access
  • Price: £ 249
  • Post Date: 2024-08-28T18:23:38+00:00
  • Category: Assignment
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

Coursework 2: Database Design and Implementation using MS Access Coursework 2: Database Design and Implementation using MS Access
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

The support team is quite friendly and gives you the best solutions. I literally came here crying and went smiling like an idiot. My HR assignment is written beautifully with all the specifications I wanted. This is the best platform to get helped in assignments for me. All the people are supportive. Keep it up you all!
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

I ordered the literature review for my research project in rush delivery. I was not expecting that they would complete my order 2 hours before my chosen time. The quality is also nice. Thank you for help.