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
• 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.
• 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
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
• Create queries to answer various questions on your available data (minimum 6 queries).
• Generate at least 4 reports.
Final Report Submission requirements and guidelines
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.
• 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.

ICT504 IT Project Management

ICT504 IT Project Management
Weekly Activity – 3
Answer the Following Questions
Question 1: Why are accurate estimates critical to effective project management? Briefly
Question 2: What are the differences between Bottom-up and Top-down estimating
approaches? Under what conditions would you prefer one over the other? Briefly explain.
Question 3: You are in charge of organizing a dinner-dance concert for a local charity. You
have reserved a hall that will seat 30 couples and have hired a jazz combo (group of few
musicians). With a budget of $20,000 allocated for the project, develop a scope statement for
this project that contains examples of all the checklist/elements. Assume that the event will
occur in 4 weeks and provide your best guess estimate of the dates for milestones.
Question 4: Below is a project WBS with cost apportioned by percents. If the total project cost
is estimated to be $600,000, what are the estimated costs for the following deliverables?
a) Design
b) In-house testing
c) Programming
What weaknesses are inherent in this estimating approach? Briefly explain.
1. Your work will be assessed on the following criteria:
• The accuracy of the answer (40%)
• The consistency in the answer (30%)
• The level of the communication (30%)
2. This assessment is worth 3% of your overall subject mark.
3. Your answers to all four questions combined should be between 500 and 600 words.
4. Do not copy and paste from the internet or use AI tools for this activity.
5. You must complete this activity during the class timings and submit on the Turnitin
link provided on the moodle.
6. Marks will be deducted for late submission.

Relational Database Model

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:
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:


CRICOS: 03836J
Weekly Activity
•This is an in-class activity.
•Time allowed: 30 – 60 min
•Individual activity.
•Answer following questions in a word document and submit to Moodle
before the due date
CRICOS: 03836J
This tutorial requires a thorough examination of various software development
methodologies, requiring a critical analysis of their strengths, weaknesses, and
applicability. To support your analysis, you’re tasked with citing a minimum of five
scholarly articles using APA7 format.
Select any two software mythologies and compare and contrast them. You need to write a
small report of 500 words. You must cite and reference a minimum of five scholarly
articles using APA7 format in this report.
Watch the APA referencing video and Powerpoint slides to get your self familiar with APA


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


Shortly after being named as CEO in 2016, the Publix Board of Directors authorized Todd Jones to move forward with opening ten new stores in the highly competitive Richmond, Virginia market. The company’s expansions out of its home market of Florida have paid off handsomely so far, with Publix now a close number 3 in market share in Georgia and gaining on its competition in Tennessee. Stressing service and a unique store experience, Jones believed Publix would remind Richmond shoppers of the now-shuttered, service-oriented Ukrop’s Super Markets and allow the company to quickly gain market share at the expense of its grocery nemeses, Walmart and Kroger. However, Richmond also marked the first time Publix would face Wegmans, a grocer with a similar background and focus on service, as well as a new European arrival, Lidl. Would the expansion work?

Your report and overview should address the following key strategic issues:

•    Assess Publix’s business-level strategy. Has the company’s business-level strategy been successful?
•    How does Publix’s strategy stand up against competitive rivalry in the industry?
•    Review the important elements of Publix’s external and internal environments.  Analyze key factors in the SWOT analysis.
•    Weigh the challenges confronting Publix. What are the greatest risks for Publix? What recommendations can be made to support Publix’s growth and profitability objectives?

3 page minimum

Business Finance – Operations Management OPMT 620: Operations Management – Case Study McDonalds Assignment

Case Study McDonalds Assignment


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)

Toxic Leadership

This summative assessment is the start of inputting information into the Strategic Marketing Plan Template. You will complete portions of this template in Weeks 2, 4, and 6, and prepare for sections of it throughout this course.
The first part of developing a strategic marketing plan is analyzing the forces that affect the business’s marketing efforts.
Access the Strategic Marketing Plan Template and complete Wk 2 – Part A: Environmental Analysis and SWOT Analysis in it. You will complete the rest of this document later in this course

Classical Psychoanalysis: Carl Jung

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?

Classical Psychoanalysis: Carl Rogers

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?