Instructor Information
- Instructor: Abdou Elkenawy
- Office: LSBE 365M
- Email: abdou@d.umn.edu
- Homepage: www.d.umn.edu/~abdou
- Class Time: Tuesday/Thursday, 11:00 AM - 12:15 PM
- Location: LSBE 233
- Semester: Fall 2025
- Credits: 3
- Tuesday 5:00 - 6:00 PM
- Thursday 1:00 - 2:00 PM
- Wednesday 4:30 - 5:30 PM (Over ZOOM, first come first served basis) - https://umn.zoom.us/j/98612435785
- Or by appointment
Remember: Office hours are for everyone - not just struggling students. Come to get ahead, ask questions, or just chat about course material. No appointment needed during scheduled times.
How to Contact Me
As your instructor, I prioritize effective and timely communication. Please use the following methods in order of preference:
1. In-Person Communication (Most Reliable & Encouraged)
Talk to me directly before or after class, or during my office hours. This is the most effective way to discuss course material, get clarification, or address any concerns.
2. Email (For Official Class Matters)
- Must be sent from your official UMD email account
- Include class name and issue description in subject line (e.g., "MIS 3220 Sec 001 - Question about Assignment 2")
- Response within 48 hours during business hours (M-F, 9 AM-5 PM)
- Important: I will not reply to emails regarding assignment extensions if sent after the due date
- DON'T email the instructor asking for assistance until you've read all the instructions and attempted the assignment
3. Google Chat (Very Short Questions Only)
Use only for brief, urgent questions such as "Will class be canceled due to weather?" or "Is class moved to Zoom today?" This is not appropriate for assignment help or detailed discussions.
Course Description
This course provides comprehensive coverage of database management systems with emphasis on database design, implementation, and administration. Students will learn fundamental concepts of relational database theory, normalization, SQL programming, and database administration.
Database Design
Master Entity-Relationship modeling, normalization principles, and logical database design techniques.
SQL Programming
Develop expertise in advanced query writing, stored procedures, triggers, and database functions.
Database Administration
Learn security implementation, backup/recovery procedures, performance tuning, and system maintenance.
Business Applications
Apply database concepts to solve real-world business problems and create effective data solutions.
Prerequisites
MIS 2201 (Information Technology in Business) or equivalent, with basic understanding of business processes and information systems.
Course Structure: A Three-Part Approach
This course is structured into three distinct parts, each building upon the last to develop a comprehensive understanding of database systems from theory to practical application. Each part concludes with a major assessment.
Course Focus Areas
Database Design: Master Entity-Relationship modeling techniques, normalization principles, and logical database design to create efficient and maintainable database structures.
SQL Programming: Develop expertise in advanced query writing, stored procedures, triggers, and user-defined functions to solve complex business problems.
Database Administration: Learn security implementation, backup/recovery procedures, performance tuning, and system maintenance for enterprise database environments.
Technology Stack: Gain hands-on experience with Microsoft SQL Server, MySQL, and Microsoft Access. Learn to use database design tools and cloud-based database services.
Business Applications: Apply database concepts to real-world business scenarios, including data warehousing, business intelligence, and emerging database technologies.
Project-Based Learning: Complete comprehensive database projects including ER modeling, SQL programming, database administration, and final capstone project presentation.
Textbook Chapter Overview
This course follows the Coronel Database Systems 14e textbook with a structured progression through key chapters:
Part 1: Fundamentals (Weeks 1-5)
- Ch. 1: Database Systems
- Ch. 2: Data Models
- Ch. 4: Entity Relationship Modeling
- Ch. 3: Relational Database Model
- Ch. 7: Introduction to SQL
- Ch. 5: Advanced Data Modeling
- Ch. 6: Normalization
Part 2: Advanced Concepts (Weeks 6-10)
- Ch. 8: Advanced SQL
- Ch. 9: Database Design
- Ch. 10: Transaction Management
- Ch. 11: Performance Tuning
- Ch. 16: Database Administration & Security
Part 3: Practical Application (Weeks 11-15)
- Ch. 15: Database Connectivity & Web Technologies
- Ch. 12: Distributed Database Management
- Ch. 13: Business Intelligence & Data Warehouses
- Ch. 14: Big Data Analytics & NoSQL
Learning Outcomes
Upon successful completion of this course, students will be able to:
| Course Learner Outcomes (What am I learning?) | Mapping to Program Learning Goals |
|---|---|
| Design and implement normalized relational databases using Entity-Relationship modeling techniques | 2,5 |
| Write complex SQL queries including joins, subqueries, aggregate functions, and advanced SQL constructs | 2,5 |
| Create and manage database objects including tables, views, indexes, stored procedures, and triggers | 2,5 |
| Apply normalization principles to eliminate data redundancy and ensure data integrity | 2,5 |
| Implement database security measures including user accounts, roles, and permissions | 4,5 |
| Perform database administration tasks including backup, recovery, and performance optimization | 5 |
| Analyze business requirements and translate them into effective database solutions | 1,2,5 |
| Evaluate and select appropriate database technologies for different business scenarios | 1,4,5 |
| Design and implement data warehousing and business intelligence solutions | 2,5 |
| Understand emerging database technologies including NoSQL and cloud databases | 5 |
BBA Program Level Learning Goals
- Goal 1: Communicate ideas effectively in written and oral form.
- Goal 2: Acquire quantitative analysis skills that can be used in managerial decision-making.
- Goal 3: Be able to work effectively in a team.
- Goal 4: Demonstrate appreciation of ethical and global issues in managerial decision-making.
- Goal 5: Demonstrate competency in the core areas of business.
Required Materials
Textbook
Database Systems: Design, Implementation, & Management, 14e by Coronel
MindTap integrated with Canvas as part of the UMD CourseWorks Program, IAC ISBN = 9780357673119
Your student account will be charged directly because you are enrolled in this course through the Integrated Access Card (IAC) program.
Additional readings and resources will be provided on Canvas
Software/Tools Required
- Microsoft SQL Server (available through Azure for Education)
- MySQL Community Server
- Microsoft Access (part of Office 365)
- Database design tools (e.g., ERDPlus, Lucidchart)
- Canvas (http://canvas.umn.edu)
Technology Requirements
This is a hands-on database course requiring extensive use of database management software. Students will need to install and configure multiple database systems on their laptops for in-class exercises and assignments.
Windows or Mac?
Both the Windows 11 or Mac OS machines will work for this course. Other devices such as Chromebooks and tablets are not designed for the assignments in this course. Following the LSBE laptop requirement policy, a minimum set of specifications for the laptop is described on this policy document.
WIFI Connection on Campus
While on campus DO NOT USE THE UMD-GUEST WIRELESS CONNECTION. USE THE EDUROAM connection. Guest wireless connections do not allow file uploads and downloads and is generally much slower than the standard EDUROAM (secured) connection.
Database Software Requirements
Students will need to install Microsoft SQL Server, MySQL Community Server, and have access to Microsoft Access. Azure for Education provides free access to SQL Server for students. Database design tools such as ERDPlus or Lucidchart will be used for ER modeling exercises.
LSBE Loaner Laptops
If for any reason your laptop is not operational or is being repaired, LSBE allows students to check out laptops for a limited period. These loaners are available from the LSBE Technology Program at LSBE 111U.
Use of online cloud storage (OneDrive and iCloud)
Both Windows and Mac operating systems strongly push their respective cloud storage offerings that requires users to pay monthly subscriptions. To avoid confusion, save all your work on the local laptop drive instead of the cloud when choosing the folder to save the file.
Canvas
Canvas is the primary channel for learning and communication between students and the instructor for all class materials and assignments. ALWAYS REFER TO CANVAS FIRST FOR OFFICIAL INSTRUCTIONS AND DEADLINES FOR ASSIGNMENTS AND QUIZZES.
Course Homepage: http://canvas.umn.edu
Alternatively (long way) access the site through UMN Portal http://myu.umn.edu
Laptop Requirements
Windows 11 or Mac OS machines will work for this course. Chromebooks and tablets are not designed for the assignments in this course.
View LSBE RequirementsCampus WiFi
While on campus, use the EDUROAM connection, not UMD-GUEST wireless connection for better performance and security.
Database Management Systems
Microsoft SQL Server, MySQL, and Microsoft Access required. Installation guides will be provided on Canvas.
Respondus Lockdown Browser
Required for secure online exams and quizzes. Must be installed before exam dates.
Grading Policy
Grade Components and Weights (1000 points total)
| Component | Points | Weight |
|---|---|---|
| Exams | 400 | 40% |
| Midterm Exam 1 | 150 | 15% |
| Midterm Exam 2 | 150 | 15% |
| Final Exam | 100 | 10% |
| Database Projects | 300 | 30% |
| Project 1: Database Design & ER Modeling | 50 | 5% |
| Project 2: SQL Programming & Complex Queries | 100 | 10% |
| Project 3: Comprehensive Database Application | 150 | 15% |
| Assignments & Labs | 150 | 15% |
| Weekly Lab Homework Assignments (10 x 15 pts) | 150 | 15% |
| In-Class Assessment & Participation | 150 | 15% |
| In-Class Assessments (12 x 10 pts) | 120 | 12% |
| Class Participation | 30 | 3% |
| Total | 1000 | 100% |
Grading Scale
Note: Final grades are calculated based on your total points earned (out of 1000) and converted to the percentage scale above. No rounding is applied to final grades.
Course Schedule
| Week | Day | Date | Topic | Readings & Assignments Due |
|---|---|---|---|---|
| 1 | Tuesday | Aug 26 | Course Introduction & Chapter 1: Database Systems | |
| Thursday | Aug 28 | Chapter 2: Data Models | Lab 1 Homework Due (5:00 PM) | |
| 2 | Tuesday | Sep 2 | Chapter 4: Entity Relationship (ER) Modeling | In-Class Assessment 1 |
| Thursday | Sep 4 | Chapter 4: Entity Relationship (ER) Modeling (continued) | Lab 2 Homework Due (11:00 AM) | |
| 3 | Tuesday | Sep 9 | Chapter 4: Entity Relationship (ER) Modeling (continued) | In-Class Assessment 2 |
| Thursday | Sep 11 | Chapter 3: The Relational Database Model | Lab 3 Homework Due (11:00 AM) | |
| 4 | Tuesday | Sep 16 | Chapter 7: Introduction to Structured Query Language (SQL) | In-Class Assessment 3 |
| Thursday | Sep 18 | Chapter 7: Introduction to Structured Query Language (SQL) (continued) | Lab 4 Homework Due (11:00 AM) | |
| 5 | Tuesday | Sep 23 | Chapter 5: Advanced Data Modeling | Project 1 Due; In-Class Assessment 4 |
| Thursday | Sep 25 | Chapter 6: Normalization of Database Tables | Lab 5 Homework Due (11:00 AM) | |
| 6 | Tuesday | Sep 30 | Exam 1 Review & Discussion | In-Class Assessment 5 |
| Thursday | Oct 2 | Midterm Exam 1 | Midterm Exam 1 | |
| 7 | Tuesday | Oct 7 | Chapter 8: Advanced SQL | In-Class Assessment 6 |
| Thursday | Oct 9 | Chapter 8: Advanced SQL (continued) | Lab 6 Homework Due (11:00 AM) | |
| 8 | Tuesday | Oct 14 | Chapter 9: Database Design | In-Class Assessment 7 |
| Thursday | Oct 16 | Chapter 10: Transaction Management and Concurrency Control | Lab 7 Homework Due (11:00 AM) | |
| 9 | Tuesday | Oct 21 | Chapter 10: Transaction Management and Concurrency Control (continued) | In-Class Assessment 8 |
| Thursday | Oct 23 | No Class (Fall Break) | ||
| 10 | Tuesday | Oct 28 | Chapter 11: Database Performance Tuning and Query Optimization | Project 2 Due; In-Class Assessment 9 |
| Thursday | Oct 30 | Chapter 16: Database Administration and Security | Lab 8 Homework Due (11:00 AM) | |
| 11 | Tuesday | Nov 4 | Exam 2 Review & Discussion | In-Class Assessment 10 |
| Thursday | Nov 6 | Midterm Exam 2 | Midterm Exam 2 | |
| 12 | Tuesday | Nov 11 | Chapter 15: Database Connectivity and Web Technologies | In-Class Assessment 11 |
| Thursday | Nov 13 | Chapter 12: Distributed Database Management Systems | Lab 9 Homework Due (11:00 AM) | |
| 13 | Tuesday | Nov 18 | Chapter 13: Business Intelligence and Data Warehouses | In-Class Assessment 12 |
| Thursday | Nov 20 | Chapter 13: Business Intelligence and Data Warehouses (continued) | Lab 10 Homework Due (11:00 AM) | |
| 14 | Tuesday | Nov 25 | Chapter 14: Big Data Analytics and NoSQL | Project 3 Due |
| Thursday | Nov 27 | No Class (Thanksgiving) | ||
| 15 | Tuesday | Dec 2 | Project 3 Presentations (Day 1) | Project 3 Presentations |
| Thursday | Dec 4 | Project 3 Presentations (Day 2) & Course Review | Project 3 Presentations | |
| Finals | TBD | Dec 8-12 | Final Exam (Check Canvas for exact date/time) |
Assignments and Due Dates
| Assignment | Due Date & Time | Points |
|---|---|---|
| Lab 1 Homework | Sep 3 - 5:00 PM | 15 |
| In-Class Assessment 1 | Sep 2 - During Class | 10 |
| Lab 2 Homework | Sep 4 - 11:00 AM | 15 |
| In-Class Assessment 2 | Sep 9 - During Class | 10 |
| Lab 3 Homework | Sep 11 - 11:00 AM | 15 |
| In-Class Assessment 3 | Sep 16 - During Class | 10 |
| Lab 4 Homework | Sep 18 - 11:00 AM | 15 |
| Project 1: Database Design & ER Modeling | Sep 23 - During Class | 50 |
| In-Class Assessment 4 | Sep 23 - During Class | 10 |
| Lab 5 Homework | Sep 25 - 11:00 AM | 15 |
| In-Class Assessment 5 | Sep 30 - During Class | 10 |
| Midterm Exam 1 | Oct 2 - During Class | 150 |
| In-Class Assessment 6 | Oct 7 - During Class | 10 |
| Lab 6 Homework | Oct 9 - 11:00 AM | 15 |
| In-Class Assessment 7 | Oct 14 - During Class | 10 |
| Lab 7 Homework | Oct 16 - 11:00 AM | 15 |
| In-Class Assessment 8 | Oct 21 - During Class | 10 |
| Project 2: SQL Programming & Complex Queries | Oct 28 - During Class | 100 |
| In-Class Assessment 9 | Oct 28 - During Class | 10 |
| Lab 8 Homework | Oct 30 - 11:00 AM | 15 |
| In-Class Assessment 10 | Nov 4 - During Class | 10 |
| Midterm Exam 2 | Nov 6 - During Class | 150 |
| In-Class Assessment 11 | Nov 11 - During Class | 10 |
| Lab 9 Homework | Nov 13 - 11:00 AM | 15 |
| In-Class Assessment 12 | Nov 18 - During Class | 10 |
| Lab 10 Homework | Nov 20 - 11:00 AM | 15 |
| Project 3: Comprehensive Database Application | Nov 25 - During Class | 150 |
| Project 3 Presentations | Dec 2 & Dec 4 - During Class | Included in Project 3 |
| Final Exam | Dec 8-12 - During Finals Week | 100 |
Project Descriptions
Project 1: Database Design & ER Modeling
Design a comprehensive Entity-Relationship model for a real-world business scenario, including entities, relationships, attributes, and business rules documentation. This project aligns with Part 1 of the course.
Project 2: SQL Programming & Complex Queries
Develop a complex database application with advanced SQL queries, stored procedures, triggers, and user-defined functions to solve business problems. This project aligns with Part 2 of the course.
Project 3: Comprehensive Database Application
Complete end-to-end database solution including design, implementation, administration, and presentation of a comprehensive business database application. This capstone project aligns with Part 3 of the course.
Policies
Student Responsibilities
- Read assigned chapters and complete hands-on exercises before class
- Participate actively in lab sessions and class discussions
- Complete all programming assignments and projects on time
- Maintain regular backups of all database work
- Keep up with course announcements and materials on Canvas
- Seek help during office hours for complex technical issues
Make-up Policy
There will be no make-up assignments or exams unless circumstances are extreme (e.g., death in the family, documented medical emergency). Since all assignments are made available from the beginning of the semester, requests for extensions are generally not granted. All make-up exams must be scheduled and completed within one week after return to class or a grade of "F" will be assigned.
Academic Integrity
All forms of academic dishonesty will result in a course grade of Failure (F). While collaboration on learning concepts is encouraged, all submitted work must be individual unless explicitly designated as group work. Sharing code or database solutions is considered cheating. Students caught copying will be asked to leave the class and will not be permitted to attend future class meetings.
Excused Absences and Makeup Work
There will be no make-up assignments or exams unless extreme circumstances happen (e.g., death in the family) or student notify excused absence in timely manner. Since all assignments are made available from the beginning of the semester, chances for getting a make-up for assignments are slim. All make-up exams must be scheduled and completed within one week after return to class or a grade of "F" will be assigned.
The University of Minnesota Duluth recognizes that students may need to miss class due to extenuating circumstances. The following is a summary of the official UMD Excused Absences and Makeup Work Policy.
Critical Requirements for Students
- Advance Notification Required: You MUST notify me in advance when possible, or as soon as reasonably possible for urgent circumstances
- Student Responsibility: You are responsible for initiating the request for makeup work - I will not automatically offer it
- Verification Policy: I will request appropriate verification for all absences when reasonable and permitted by university policy
- Timely Communication: Late notification may result in denial of makeup opportunities
Excused Circumstances Include:
Health & Medical
- Illness (physical or mental) or acute injury
- Disability accommodations
- Caring for dependent or immediate family member
Legal & Civic
- Jury duty, court appearances, subpoenas
- Military service and ROTC requirements
- Visa/immigration appointments
Academic & Personal
- NCAA intercollegiate athletic events
- Bereavement and related travel
How to Request Makeup Work:
- Notify me immediately via email (preferred) or in person
- Include details: Your name, course section, specific dates affected, and reason for absence
- Provide verification when requested and appropriate
- Work with me to arrange equitable makeup opportunities
Complete Policy: For full details, appeals process, and additional information, please review the complete policy at https://evcaa.d.umn.edu/excused-absences
Students with Disabilities
It is the policy and practice of the University of Minnesota Duluth to create inclusive learning environments for all students, including students with disabilities. If there are aspects of this course that result in barriers to your inclusion or ability to meet course requirements, please notify the instructor as soon as possible. Contact the Office of Disability Resources at 218-726-6130 for accommodations.
Care for Mental Health
In these difficult times, it is important for us to care for our mental health. So if you feel any anxiety or pressure of any sort, feel free to reach out and tell me or reach out to Counseling services available at UMD Health Services or call 218-726-7913 to schedule a virtual visit. In case of an emergency, please contact The Birch Tree Center's Crisis line at 218-623-1800 or go to the emergency room/urgent care at either St. Luke's Hospital or St. Mary's Hospital. If an ambulance is needed, call 911. If the emergency is non-life-threatening and you do not have a means of transportation, call Campus Police at 218-726-7000). If you have needs that Counseling Services does not treat, they have a case manager who helps connect students to referrals as well as navigating issues with insurance. You can learn more about the broad range of confidential mental health services available on campus at UMD Health Services.
Equity and Diversity
The University provides equal access to and opportunity in its programs and facilities, without regard to race, color, creed, religion, national origin, gender, age, marital status, disability, public assistance status, veteran status, sexual orientation, gender identity, or gender expression.
Academic Policies for Teaching and Learning
For additional descriptions about each of these items, please visit the syllabus statements webpage.
Additional academic policies are available on the Academic Affairs website.
Academic Resources for Students
For additional descriptions about each of these items, please visit the syllabus statements webpage.
Disability Resources
UMD Disability Resources, 258 Kirby Students Center, umddr@d.umn.edu, (218) 726-6130
Academic Support
Library Services
Students can chat with a librarian 24/7, schedule an appointment with a subject librarian, email libaskus@d.umn.edu, or drop-in during the day.
Writing Support
Writers' Workshop: Drop-ins are welcome. To ensure a time slot, schedule an in-person or online appointment.
Health and Safety Resources for Students
For additional descriptions about each of these items, please visit the syllabus statements webpage.
Mental Health and Stress Management
Counseling services at UMD Health Services is free to all enrolled UMD Students, 615 Niagara Court, umdhs@d.umn.edu, (218) 726-8155
Let's Talk Drop-In Consultations
Crisis and Mental Health Emergency
- The Birch Tree Center's Crisis line at (218) 623-1800
- Emergency room/urgent care at either Aspirus St. Luke's Hospital or Essential Health/St. Mary's Hospital
- If an ambulance is needed, call 911
- If the emergency is non-life-threatening and you do not have a means of transportation, call Campus Police at (218) 726-7000
Basic Needs Security
Champ's Cupboard and Champ's Closet located in the Office of Student Life, 245 Kirby Plaza, open Monday through Friday 8:00 a.m. to 4:30 p.m., vcsl@d.umn.edu or (218) 726-8501.
Sexual Harassment, Sexual Assault, Stalking and Relationship Violence
- Reporting concerns
- Free and confidential support
- Requesting accommodations
- Board of Regents Sexual Harassment, Sexual Assault, Stalking and Relationship Violence Policy (definitions)
- University of Minnesota administrative policy (resources, rights, reporting information)
Equity, Diversity, Equal Opportunity, and Affirmative Action
- Reporting misconduct
- UMD resource: Office of Student Conduct & Conflict Resolution, 245 Kirby Plaza, conduct@d.umn.edu, (218) 726-7255
- Board of Regents Equity, Diversity, Equal Opportunity, and Affirmative Action Policy
Additional Resources
UMD Land Acknowledgement
A Land Acknowledgment is a formal recognition of the unique and enduring relationship that exists between American Indians and their territories. The UMD Land Acknowledgement is an opportunity for the entire University community to increase their awareness of the history of the land on which UMD resides.
Artificial Intelligence (AI) Policy
Generative AI systems, such as ChatGPT, may be used for any assignment with appropriate credit. Examples of attribution formats are available from the RMIT University Library. You are responsible for checking outputs for accuracy and/or appropriateness.