Dylan’s Book Store has been running successfully in
Swansea for many years. The shop has customers from all over the Principality
and a number of loyal English, Scottish and Irish fans. They specialise in selling classic titles and
new best sellers. In particular they try to look for first editions of many of
the classics (for example ‘Under Milk Wood’ has become very desirable this year
for some unknown reason).
The following points document the working
procedures of the book shop: –
Staff place orders with suppliers (publishers and collectable book
dealers). This is carried out mainly by intuition and guessing what the
customers may be interested in.
Customers will also place orders for copies of books, both popular
titles and rare first editions.
They have many customers outside the Swansea area and for many
years they have operated a mail order service. The release a newsletter
once every three months, detailing current interesting stock etc.
They have on small computer used for word processing and what could
loosely be termed as a data base (a collection of names and addresses of
customers typed into one document which isn’t update regularly)
Due to the various factors such a prompt and
friendly service and much media coverage of the works of a famous Welsh author
the company are gaining an ever-increasing customer base. To maintain their
level of service, the company has decided that fast information retrieval and
processing is a must. They realise it’s time to computerise. They require a
user-friendly database system, in MS-Access Ó, that will satisfy their processing needs.
Additional information
The database system should be menu driven. The
design of the record structure of any tables you use has been left to your
discretion.
The book shop would like to use the system to query
information for customer seeking out specific titles in particular the classic
rare first editions and produce relevant reports on availability.
Although this is a typical stock plus mail order
system, the shop would like to maintain its friendly service and customer care
that has gained them their reputation. They hope the system will allow for this
flexibility
Using the above scenario, ensure that your system includes the following
features: –
·
User has the ability to add or delete information
from any table.
·
User should be able to view, on screen, Book stock,
orders and customer details.
·
User should be able to view ongoing customer
orders.
·
User should be able to query the system and print
out relevant reports.
Guide to successful implementation of assignment requirements:
You must use design techniques that you have
been studying in class to develop a suitable solution for the above scenario.
Context
diagram
Level
0 DFD
An
Entity Relationship Diagram Showing:
Entities
Relationships
Degree
of Relationships
Membership
Class
Annotated
descriptions for each relationship
Documentation
Provide evidence that the tables will link
together in a relational database environment.
Apply suitable data analysis and design techniques
to create a logical design:
§ Suitable tables created
§ Suitable fields created
§ Suitable foreign keys
created
§ Suitable relationships
created
§ Tables relate together
correctly
§ Verify the design meets
user requirements
§ Table design meets the
rules of third normal form (3NF)
§ Use references to
books, journals, notes and web material used in the completion of the
assignment
§ Use Microsoft Visio to
produce the final ERD, document the tables and comment on the results achieved
in Visio
Use of additional MS-Access functionality
§ Produce calculation in a report
§ Produce Master and Embedded forms
§ Producing reports and forms from a macro query
§ Menus are displayed immediately after the database opens