Transcript DBdesignstages

Database Design -Stage 1
• Create a E-R diagram of the UK Delivery
• Specify all constraints. If a constraint
connot be expressed using the diagram,
write it down in words ( and clearly)
• If you find that additional assumptions are
necessary, make them explicitly and
include in your document.
Database Design -Stage 2
• Realize your E-R diagram as a set of relations
using the algorithm for converting the diagrams
in the relation model.
• Using CREATE TABLE commands or using the
wizard provided by Access 2003 to create and
specify these relations and all the relevant
constraints.
• Create the actual relations in your Access
database and populate it with data (example
data will be provided at due time.
Database Design -Stage 3
• To develop the queries that will need to be asked to be
able to use the database, as we have the precise tables
for our relational database design
• Before building the user interface for our system, we
must develop code and test the queries that will be
needed to access the data in the database.
• Work on the SQL queries that access your database to
provide the requested information ( Requested
information will be provided at due time)
• You will eventually use these queries for your final
Project submission.
Database Design -Stage 4
• Design and implement the screens and user
interactions for your shipment monitoring
system.
• The interactive system should support the
various operations required by the various
users.
• It must be able to ask the queries and perform
the updates described before.
• It’s up to you design which screens to provide
and what to put on each screen.
Database Design –Final Stage
• Congratulations! You have nearly finished
your design. You system should function
like these:
– Your program must be working and be able to
execute all the specified queries.
– Besides the portfolio, you should also include
your Access program burned on CD.