Role

• Guided students on database design principles—including entity-relationship diagrams, business rules, and SQL queries—through dedicated office hours and in-class support, enhancing learners’ technical skills.
• Developed detailed grading rubrics to ensure consistent and fair assessment, provided comprehensive written feedback, and efficiently imported final grades into the Canvas LMS by leveraging Microsoft Excel functions (pivot tables and XLOOKUP) to merge data from multiple workbooks.

Course Description

Goal:

The goal of this course is to provide students with knowledge and skills necessary to produce a well-designed database that enables the timely delivery of accurate information in a useful form

Objectives:

Upon completion of this course students will be able to:

• Explain basic database concepts and terminology
• Identify information needs within an organization
• Formulate user and organizational requirements for a database
• Design a conceptual model that satisfies these needs and requirements using a relational data / entity relationship model
• Normalize this relational data / entity relationship model
• Implement the corresponding logical model in a relational database management software (e.g. MS ACCESS, MS SQL Server, etc.)
• Design SQL queries for a relational database to satisfy users’ information needs

Content:

• Overview of databases and database design
• Components of a database
• Conceptual design and Entity Relationship Diagram (ERD)
• The relational model
• Normalization
• Logical design
• Querying a database using SQL
• Issues and Trends in DBMS
• Creating a database