代写Relational Databases调试数据库编程

Relational Databases

FSP Computing & Information Systems

Major Database Assignment

Dates Due:

Part A: Friday 20th September 2024

Part B: Due Friday 4th October 2024

Your Task:

You are required to produce a relational database for a fictional client of your choosing. As part of this task, you will be required to provide documentation of the Systems Development Life Cycle involved in developing the database.

Requirements:

PART A – Friday 20th  September 2024

Problem Definition (½ page)                                                                                                             (5 Marks)

All projects need an introduction that tells the reader what the intended aim of the developed project will be. The Problem Definition should be set out in two parts:

The Client

Clearly state, who the client is and what their needs are

Outcomes

List four outcomes that the client requires the new system to be able to do.

For each outcome, discuss who will require the outcome and why (i.e., the reason for each outcome.)

• Outcome 1: Data Entry Form

All systems require the entry of data into a transaction table – this is the main function of the finished relational database. Produce a screen that has a form/sub-form. layout.

• Outcome 2: Multiple Criteria Report

This outcome requires simple processing (at least two criteria) from the data in the transaction table.

• Outcome 3: Statistical Report

This outcome requires the use of grouping in Access to produce summary statistics such as sum, count or average from the records in a transaction table.

• Outcome 4: Calculated Report

This outcome involves creating a new calculated field from one or more existing fields, such as Age: (date()- [date of birth])/365.25

Analysis (1 – 2 pages)                                                                                                                          (10 Marks)

In the Analysis phase, focus on each outcome the client requires the system to be able to do:

•    State the outcome

•     Identify the data that needs to be stored.

•     Identify the processing steps to achieve the outcomes.

Design (3-4 pages)                                                                                                                              (35 Marks)

The Design stage will propose the database and its features by discussing the tables needed based on the data identified from the outcomes in the Analysis.

Tables and Relationships (1 page)

•    The tables needed (one paragraph per table).

•    The relationships between the source tables, and why they may be one-to-many or many-to-many.

•    The resolution of the many-to-many relationships between source tables with transaction tables (e.g., explain why a Loans table is needed to resolve the many-to-many relationship between Borrowers and Books).

•     Include in your discussion of each table a description of what a record in that table contains. In this way you are demonstrating a good understanding of the system you have designed.

For example, “there is a record in the Loans table for each book borrowed by a borrower”, and “one record in the Borrowers table for each borrower of the library”.

Table Relationship Diagram (½ page)

This diagram may be either a screen shot from the software in Access or produced using graphics.

•    Show the links and the fields used for linking between the tables.

•    On the link give the relationship between the tables and highlight the key in each table.

Data Dictionaries (½ page for each table)

These are to be of your final design and must be an accurate representation of the tables. You should show:

•    the primary key

•    fields that have a default value to automatically supply a frequently used value e.g. =date() for the date borrowed field

•    data entry validation checks e.g. gender =”M” or “F”

•     Use of drop-down boxes to reduce errors at data entry e.g. drop down lists for title: Mr, Mrs, Ms

PART B – Due Friday 4th  October 2024

Development and Validation                                                                                                           (50 marks)

The Development involves creating the database, including the tables, the queries, the forms, and reports. It also includes entering in the test data and testing the database to ensure that it does what it should do.

Ensure the system is checked from all angles and involves checking for illegal transactions (e.g., two people borrowing the same book at the same time).

Marks will be awarded for the successful processing of all data and using effective layouts:

Switchboard – User interface for easy navigation

Data Entry Form (Outcome 1) - Use of data entry form/layout to enter new transaction data Reports (Outcomes 2-4) - using effective layout and appropriate appearance

Client Progress Meetings                                                                                                                  (20 marks)

Each stage is verified by the client (your teacher) and that the project meets the client needs as the project progresses. Issues can be identified and addressed as the system is being created.

Presentation ofthe Project                                                                                                              (10 Marks)

Produces documentation of the Systems Development Life Cycle by providing:

• correct life cycle layout.

• all sections with correct headings.

• a contents page with all pages numbered.

• good use of grammar, and high-quality word-processing.