Land Acknowledgment

York University recognizes that many Indigenous Nations have longstanding                relationships with the territories upon which York University campuses are located that precede the establishment of York University. York University acknowledges its           presence on the traditional territory of many Indigenous Nations. The area known as   Tkaronto has been care taken by the Anishinabek Nation, the Haudenosaunee            Confederacy, and the Huron-Wendat. It is now home to many First Nation, Inuit, and   Métis communities. We acknowledge the current treaty holders, the Mississaugas of   the Credit First Nation. This territory is subject of the Dish with One Spoon Wampum   Belt Covenant, an agreement to peaceably share and care for the Great Lakes region (LA&PS Land Acknowledgement).

Course Overview

Course Description

An  examination  of  databases,  trends  in  database  management  systems  and  their application in a wide range of organizational areas. The course provides an overview of database processing in modern organizations and discusses current and emerging trends in database processing. The course illustrates the range of choices available for data and knowledge  management  by  examples  relevant  to  different  types  of  organizations. Students are exposed to a range of software tools, including tools for designing data models and implementing those models in relational database management systems.

Prerequisites: AP/ITEC 1000 3.00, AP/ITEC 1010 3.00, AP/ITEC 1620 3.00, AP/ITEC 2610 3.00, AP/ITEC 2620 3.00, SC/MATH 1190 3.00, SC/MATH 2320 3.00, SC/MATH 2565 3.00.

Course Learning Objectives

By the end of this course, students will be able to:

•    recognize and explain basic database concepts and terminology

•    identify the informational needs within an organization

•    formulate user and organizational informational requirements

•   design a conceptual information model that satisfies these requirements and represent it (as an Entity-Relationship diagram) using the Entity-Relationship modeling language

•   evaluate the quality of conceptual models expressed as Entity-Relationship diagrams

•    revise conceptual models expressed as Entity-Relationship diagrams

•   translate conceptual models represented as Entity-Relationship diagrams into relational data models

•    recognize and explain functional dependencies

•    recognize and explain normal forms (for relational data models)

•    evaluate the quality of relational models

•    revise (normalize) relational data models

•   translate relational models into database schema using SQL, and implement the translation in a relational database management software (e.g. PostgreSQL, MS SQL Server, ORACLE, MySQL, etc.)

•    design queries and express them in Relational Algebra

•    design queries and express them in Relational Algebra

•    use SQL to interact with relational database management systems.

•    understand major concurrency control algorithms.

•    Interpret and comparatively criticize database system architectures.

•    understand security and integrity policies relating to databases

•    understand the basic principles behind data warehousing and preparation for data analytics

•   to work in teams to design and implementing database projects

Course Format and Organization

ITEC 3220 Section N meets once a week for lectures. Class time will be used for lectures, active learning activities and discussion.   While the lectures are designed to be self- contained, you are strongly encouraged to read from the recommended textbooks to get a better understanding of the material covered and to learn about related topics not covered in class. The lectures will consist of a combination of slide-supported and live demo presentations.

Technical Requirements

ITEC 3220 Section N students will interact with the course materials, the course director as well as with one another via e-Class. Lectures will be delivered in person.

Should it become necessary to deliver lectures over Zoom, students will need to use      Passport York to join the Zoom meeting. In case of technical difficulties accessing Zoom lectures via web browsers, consider installing the Zoom app on your device.  Join the     Zoom lectures will require connecting with the SSO option selected.

Using Zoom

Students shall note the following:

•     Zoom is hosted on servers in the United States and Canada. Recordings done since May 1, 2022 are stored in Canada. For more information, please refer to the notes on Zoom Privacy and Security provided by Information Security at    York.

•     If you have privacy concerns about your data, provide only your first name or a nickname when you join a session.

•    The system is configured in a way that all participants are automatically notified when a session is being recorded. In other words, a session cannot be recorded without you knowing about it.

Here are some useful links for student computing information, resources, and help:

• Student Guide to eClass

• Zoom@YorkU Best Practices

• Zoom@YorkU User Reference Guide

• University Information Technology (UIT) Student Services

• Student Guide to eLearning at York University

To determine Internet connection and speed, there are online tests, such as Speedtest, that can be run. If you need technical assistance, please consult the University Information Technology (UIT) Student Services web page. For more specific assistance, please write to askit@yorku.ca.

Software requirements for course work:

•    PostgreSQL

•    Adobe Acrobat (or other document visualization tool with support for pdf files)

•   A text editor that can export documents in the pdf format

Software recommendations

•   A GUI style access to PostgreSQL database management systems, e.g., pgAdmin PostgreSQL Tools

•    DIA drawing software https://sourceforge.net/projects/dia-installer/

Recommended documentation resources:

• PostgreSQL Reference Documentation

•   Additional database design and SQL exercises: Interactive Tutoring from Kennesaw State University (ADbC)

Course Communication Plan and Office Hours

•    Course announcements will be made in class and/or via e-Class.

•    When communicating with the instructor, use your York University email account, include [ITEC3040] on the subject line and your full name and student ID at end of the email. If you are experiencing an emergency,     please include 'URGENT' in the subject line of your email.

•     Students can communicate with one another using the discussion forums set up on eClass)

• Office hours are held after each lecture (in the lecture room) and by appointment.

Course Evaluation

Assessment Descriptions

First assignment evaluates knowledge and skills related to designing conceptual data models based on textual descriptions of a problem domain, translating        them into relational data models, qualitatively assessing them (wrt criteria         codified as normal forms) as well as revising them.

The second assignment evaluates knowledge and skills related to translating relational data models into relational database schemas and the formulation of queries on           relational schemas using Relational Algebra and SQL.

Submitting Assignments

Solutions for assignments should be submitted digitally via eClass. Assignments for this course must be received within the timeframe specified for the assignment handout.

Working in teams

You have the option of partnering with other students for each of your assignments.   Partners will receive the same mark for joint assignments. Working with a partner has the potential to lighten your workload and enhance your learning or to increase your   workload and impair your learning, depending on how you work together. Remember that you are responsible for learning the course material underlying all parts of the      assignments. You will have the most success if you truly work together.

Remarking Requests

If you feel there was an error in the marking of an assignment or midterm, you may request that it be remarked. You must give a specific reason for the remark request, referring to a possible error or omission by the marker. You must submit any remark request within a week of getting back the marked work. Submit your request to your instructor in person or via email.

Late Work Policy

Unexpected problems sometimes make it difficult to submit assignments on   time . You can submit an assignment after the due date as long as it is no       more than 24 hours late . If an assignment is submitted more than 30 minutes after the due date , it will be considered a full day late and will incur a penalty of 15% . Assignments that are more than 24 hours late will not be accepted.

Missed Tests and Exams

If you miss an assignment due to illness or other circumstances covered by relevant York University policies, the weight of the assignment will be distributed to the weight of the other assignments (provided that you submit appropriate documentation). If you miss one of the term tests, the weight will be added to the weight of the final exam (provided that you  submit  appropriate  documentation,  according  to  the  relevant  York  University policies).

If you are unable to complete the homework or if you miss a test due to major illness or other circumstances outside of your control, notify the instructor as soon as possible, if you wish to request special consideration. Contact the instructor even before you can arrange to submit supporting documentation. It is always easier to resolve such situations earlier rather than later.

If you are unable to write a final exam at the scheduled time - due to illness, a personal or family emergency, or religious commitment - you can petition to write the final exam at a later date. Contact the School of Information Technology ([email protected])  as  soon as possible. (Note that final exams and deferred final exams are NOT scheduled by course instructors.) More information on academic decisions and petitions can be    found at https://www.yorku.ca/laps/itec/academic-resources/academic-advising/.

Grading

The grading scheme for this course conforms to the 9-point system used in               undergraduate programs at York University. For a full description of the York grading system, visit the York University Academic Calendar.

Course Schedule: Weekly Readings and Activities

Optional Materials

Recommended textbooks

•   “Database Systems the Complete Book", 3rd edition, H. Garcia-Molina, J. D. Ullman and J. Widom.

•   “Database Systems, Design, Implementation, and Management”, 13th Edition, C. Coronel and S.  Morris

Course Schedule

[The table below represents the number of weeks in a typical 3.0 credit course. For a   6.0 or 9.0 credit course, you will need to add additional rows in order to represent all 24 weeks of your course.]