1503230 – Database Management

+49 176 309776231
College of Computing and Informatics Department of Information Systems
1503230 – Database Management
Spring 2023-2024
Group Project Outl
the latest version of Access. Students may join each other in a group of a maximum of three
students. The topic is chosen by the student, to help you get started, we suggest the following
domains:
• Furniture purchase order processing domain
• Books order processing domain
• Pharmacy prescription processing domain
• Flower order processing domain
• Pet order processing domain
Suggest your own: You are highly encouraged to suggest your own application domain to work
on. You are required to discuss your plan with your professor, prior to any project deadline.
Phase I: Analysis (Conceptual design).
This task aims to analyze the requirements for your application domain and express those
requirements in a DBMS-independent way. This will be accomplished by using the
entityrelationship (ER) model.
Your design should include an ER diagram using as many of the entity-relationship model
constructs as necessary to fully express the database requirements of the application. In particular,
entities, relationships, attributes (of entities and relationships), keys, and constraints should be
included in your design as required by the application.
Note: Your ER diagram should include between 6 to 8 entities.
Phase I should include the following:
• A description of the application domain of your choice. State as clearly as possible what you
want to do.
• A description of the functionalities that you plan to offer.
2
• An initial ER design; for each entity, a diagram or listing showing the attributes of the entity
and an indication of any constraints on the entity or its attributes (e.g., keys, composite
attributes, foreign keys, etc.).
• Include all relationships among your entities showing any descriptive attributes and structural
constraints in your ER design.
Phase II: Table creation and data insertion, forms, and reports (Database
implementation)
Phase II should include the following:
• Create a switchboard to allow you to navigate around your Access database.
• Create all the tables that correspond to the ER diagram developed in phase I (between 6 and 8
tables). Include all the constraints, field properties constraints, primary and foreign keys
constraints, etc.
• Create the relationship between the tables based on the business rules related to your application
by drawing the relational diagram using Access, Save the diagram. Make sure you build the
right relationships between tables.
• Insert sample data into all the tables (at least 10 rows per table), do not enter data from the table.
• Forms for all your tables, design a form for each table you create and enter your data in the
forms.
• Create queries to answer various questions on your available data (minimum 6 queries).
• Generate at least 4 reports.
Final Report Submission requirements and guidelines
Requirements
A written report which includes the following:
• A description of the current system and a proposal for the new system to be designed.
• A description of the steps of the normalization process.
• A list of the tables in your database, the attributes of each table, field type, the primary key, and
the foreign key if found.
• A copy of the tables with the data (print a copy from the tables – Datasheet View).
• A relational diagram (print a copy of Access – Relationships). Write the business rules to
explain the relationship between the different tables in the database.
• A copy of the queries, briefly explain each query.
• A copy of the forms, briefly explain each form.
• A copy of the reports, briefly explain each report.
• A conclusion evaluating the system, including a description of its limitations and the
possibilities for improvements.
General Guidelines
• Identify the tasks assigned to each student in the report and list the responsibilities.
3
• The final submission date for the project is on Tuesday 16/4/2024. Your final submission
includes the following:
1. A hard copy of the written report.
2. A softcopy of the project (Access Database).
• One student in the group will submit the final project via Blackboard.
• Students are expected to give a 15-minute presentation about their project and answer
questions related to their database on Thursday 16/4/2024.
• Students are graded individually based on their presentation, their contribution to preparing the
report, and the content of the report submitted.