+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.

1
Week3 Tutorial
Relational Database Model
1. What is entity integrity and referential integrity and why are important to a database?
2. Explain the purpose and function of each of the following relational set operators:
a. Select
b. Project
c. Union
d. Intersect
e. Difference
f. Product
3. Identify and describe the components of the table shown in figure 1, using correct
terminology. Consider knowledge of naming conventions to identify the table’s
probable foreign key(s).
Fig 1:
2
4. Using the database shown in figure 2, answer the following questions
Fig 2:
a. Identify the Primary Keys
b. Identify the Foreign keys
c. Create the ERM
d. Create the relational diagram to show the relationship between Director and Play.
5. Considering the Student and Professor tables shown in Figure 3 to illustrate the
differences between a natural join, an equijoin, and an outer join.
Fig 3:

The first half (2-3 pages) requires you to reflect on your experience with toxic leadership. Which of the six typologies of toxic leadership did this leader represent? What were the behaviors this toxic leader use? What were the environments the toxic leader created? How did you cope with the toxic leader? What was the end outcome?

The second half (2-3 pages) requires you to reflect on a time when you were a toxic leader.

What were you doing? What were the typologies you exhibited?

Were you aware of your toxic leadership at the time?

How did you find out you were toxic? What did you do when you became aware of your toxicity?

How did it effect your team?

Did anyone support your toxic style?

References to course material using APA REQUIRED

Case Study McDonalds Assignment

Instructions

Please follow the instructions provided in the attached PDF document.

AI (ChatGPT) must not be used to create your report, or parts of it!

———————————————————————————————
1)  Introduce the company of your choice.

2) What similariJes does this company have with McDonald’s, what is unique or sets them
apart from McDonald’s?

3)  What is the unique selling proposiJon or compeJJve advantage of your selected
company? How is it presented and maintained?

4)  Field invesJgaJon: Visit at least one restaurant of McDonald’s and one of your selected
company. InvesJgate their operaJons and report your observaJons in regards of:
a. Layout of the restaurant and how it serves the purpose of the operaJonal goals; b. Customer wait Jmes, number/type of staff, variaJons throughout the day;
c. Service performance and observed customer saJsfacJon;
d. Stocked items & cleanliness;
e. ProducJvity, JIT, and how it is achieved;
f. Quality tools, such as Lean or TQM; how are they uJlized?
g. Summarize the overall operaJonal processes observed.

5)  Analyze if and to what extend the value proposiJon and compeJJve prioriJes were met in reality. Assess the operaJons strategy of McDonald’s and the company of your choice in the compeJJve environment. What challenges do they face, what opportuniJes do you see for their future development of operaJon strategies?

Structure your report according to the the reader can easily follow your logic with about 2,500-3,000 words of text, you apply the APA formaUng.

——————————————————————————————————————————————————-
1. Attached is the McDonalds Case Study. pdf

2. Screenshots of rubrics for score acceptance
3. PPT study material for reference (Be thorough and relatable to work in class)

1. What is the basic purpose/goal of life? 2. What are the basic parts/elements of the personality that carry out the goal? 3. What happens when these basic elements encounter the demands of others  (developmental statements)? 4. Finally, how does the theory account for individual differences in personality?