Evaluating a Relational Database Solution

Evaluating a Relational Database Solution

Performance criteria and desired outcomes-

The database will contain all required details:

Criteria to implement:

Successful or Failure:

A student table with essential details (StudentID, Forename, Surname,

DateOfBirth, Gender, Address 1, Address 2, Address 3, Postcode,

Telephone Number, Mobile Number, Email Address)

ü Done

A course table with essential details (CourseCode, Course Name, Course

Category, Course Description, Course Date, Course Time, Length Of

Course, VenueID, Tutor Forename, Tutor Surname)

ü Done

A venue table with essential details (VenueID, Venue Name, Address1,

Address 2, Address 3, Postcode, Telephone Number, Tube, Buses)

ü Done

A course selection table with essential details (ReferenceNumber,

StudentID, CourseCode, Accepted, Letter Sent)

ü Done

A way of showing students details of a certain type.

ü Done

A way of showing courses details of a certain type.

ü Done

A way of showing venue details of a certain type.

ü Done

A way of showing course selection details of a certain type.

ü Done

Final invoice should be laid out exactly the same way the sample

letter is shown.

ü Done

Students detail must all be given on the letter.

ü Done

Must be sent to the correct students - accepted or rejected.

ü Done

Must have the applicant’s course, which they have been accepted or

rejected for.

ü Done

The first part of this Task will be carried out in Microsoft Access

At the beginning of this project, I set the database some objectives

that I hade hope would be achieved. Some of ...

... middle of paper ...

...have worked with a ‘paper-based system’ such as MS Access

because it requires a lot of thought from the user and it will be

difficult to pin-point an aspect for an inexperienced beginner.

However, for a user to use Microsoft Word it will be straightforward

using features such as: bold, underline italics etc. Thus, they must

be very cautious when they are using the ‘mail-merge’ because the

process is achieved by a step-by-step method and the slightest of

mistakes can take the user off the significant criteria – So they have

to pay attention to their preceding action.

I enjoyed working with these packages – MS Word and MS Access; because

I feel that I have learnt a lot more concepts of what the packages are

capable of producing. I would be most obliged if I have to work on

such a sophisticated package in the aftermath.