Database and management

Hints:

• Create a query that lists all details needed for a report. If you are unable to formulate this query, then

create a report that is based directly on the table. (Note: you will not be able to obtain full marks for the

report creation if you base your report directly on the table and some criteria are not met in your reports.)

• Use the report wizard to generate a basic report based upon your query (or the table if you were unable to

formulate the query).

• Once the report wizard finishes, switch to design view and rename the labels to match those shown in the

report above; for example, change FirstName to First Name etc.

Implementation Report

You must also provide a short implementation report describing your experiences with this assignment.

You may discuss any of the following:

a) You may see more than one design choice (such as whether or not to introduce a surrogate key, the

data type selection for a particular attribute, etc) whilst implementing this database. If so, describe

the relative merits of the alternatives.

b) You should clearly show each of the SQL statements for the information requests. Describe your

experience with MS Access SQL. (Note: It is optional to justify why your SQL statements are

effective in addressing each information request.)

c) You may have encountered some limitations in the DBMS you were using whilst trying to

implement this database. Describe what you were trying to implement and explain the limitations

you encountered.

d) You may reflect on what you have learned during this assignment, what areas you think you need to

improve on, and how you intend to improve your knowledge of those areas.

Use the implementation report to demonstrate that you have thought carefully about the issues that arise

when implementing a relational database.

What you should submit

• A Microsoft Access database file containing:

1. Tables with sample data

2. Relationships

3. Queries

4. Integrity constraints

5. Report.

• A Microsoft Word document containing:

1. Two relations with functional dependencies and demonstration of normalisation

2. Implementation report

Your document should contain appropriate identification information (your student number, name, course

number, etc.) and should be appropriately formatted. For example, your document should contain a brief

introduction stating the purpose of the document, as well as headings for each section.

Administración de bases de datos MySQL SQL

Nº del proyecto: #7736430

Sobre el proyecto