MASY1-GC 3500 Database Design & Management Spring 2023
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
Database Design & Management
MASY1-GC 3500 | 201 | Spring 2023
Description
This is an introductory course for database management systems and applications. It presents concepts, methodologies, and techniques important for database analysis, design, implementation, and management. The course focuses on the logical, conceptual and physical implementation of relational database management systems so that students can assimilate a basic knowledge of database design as it relates to business rules. The course utilizes a combination of lectures, hands-on computer exercises, examples from Oracle and other leading databases, and real-world database projects to accomplish the learning process.
Prerequisites
MASY1-GC1240 – Information Technology and Data Analytics
Learning Outcomes
At the conclusion of this course, students will be able to:
● Create databases based on the relational database model
● Construct conceptual data logical data models
● Use normalization to providing efficiencies and data integrity
● Transform business requirements into viable, efficient, and reliable databases aligned with business requirements
● Appraise the objectives of data and information management
Communication Methods
Be sure to turn on your NYU Brightspace notifications and frequently check the “Announcements” section of the course site. This will be the primary method I use to communicate information critical to your success in the course. To contact me, send me an email. I will respond within 24 hours.
Structure | Method | Modality
There are 14 session topics in this course. The session topics are organized into three (3) areas of study: 1) History, 2) Learning Principles, and 3) Instructional Design in Practice.
Active learning experiences and small group projects are key components of the course. Assignments, papers, and exams will be based on course materials (e.g., readings, videos), lectures, and class discussions. Course sessions will be conducted synchronously on NYU Zoom, which you can access from the course site in NYU Brightspace.
Expectations
Learning Environment
You play an important role in creating and sustaining an intellectually rigorous and inclusive classroom culture. Respectful engagement, diverse thinking, and our lived experiences are central to this course, and enrich our learning community.
Participation
You are integral to the learning experience in this class. Be prepared to actively contribute to class activities, group discussions, and work outside of class.
Assignments and Deadlines
Please submit all assignments to the appropriate section of the course site in NYU Brightspace. If you require assistance, please contact me BEFORE the due date.
Course Technology Use
We will utilize multiple technologies to achieve the course goals. I expect you to use technology in ways that enhance the learning environment for all students.
Feedback and Viewing Grades
I will provide timely meaningful feedback on all your work via our course site in NYU Brightspace. You can access your grades on the course site Gradebook.
Attendance
I expect you to attend all class sessions. Attendance will be taken into consideration when determining your final grade.
Refer to the SPS Policies and Procedures page for additional information about attendance.
Textbooks And Course Materials
List required and recommended resources. Be sure to include the following information for each:
● Required: Database Systems: Design, Implementation, & Management 13th Edition (January 1, 2018) ISBN-13: 978-1337627900
● We will be using Oracle database for assignments and labs in this course. The below software(s) downloads are free for educational use. You will need to create an account with Oracle. We will connect to NYU Oracle environment, which we will go over in class, step-by-step
● Software(s) used in this class (on your personal PC)
● Oracle SQL Developer - http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html
● Oracle SQL Developer Data Modeler http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html
● Windows only: putty and pscp - Putty https://www.putty.org/
● ASCII text editor - Visual Studio Code
Grading | Assessment
Your grade in this course is based on your performance on multiple activities and assignments. Since all graded assignments are related directly to course objectives and learning outcomes, failure to complete any assignment will result in an unsatisfactory course grade. All written assignments are to be completed using APA format and must be typed and double-spaced. Grammar, punctuation, and spelling will be considered in grading. Please carefully proof-read your written assignments before submitting them for a grade. I will update the grades on the course site each time a grading session has been completed— typically three (3) days following the completion of an activity.
DESCRIPTION
In Class Group Assignments
Class Assignments
Midterm Exam
Final Exam
__________________
TOTAL POSSIBLE
PERCENTAGE
20%
30%
25%
25%
______
100%
See the “Grades” section ofAcademic Policies for the complete grading policy, including the letter grade conversion, and the criteria for a grade of incomplete, taking a course on a pass/fail basis, and withdrawing from a course.
Course Outline
Start/End Dates: 1/25/2023 - 5/3/2023 / Wednesday
Time: 07:00pm -- 09:35pm
No Class Date(s): Spring Break - Wednesday, March 15, 2023
Special Notes:
Session 1 - 01/25/23
Topic Description:
● Setup Environment
● Database tools
Assignments:
● Homework 1 - Database connection
Session 2 – 02/01/23
Topic description –
● Introduction to database and Data Modeling
Assignments:
● Homework 2 – Data models
● Group 1 – Project proposal
Session 3 – 02/08/23
Topic description –
● Loading data into the database using SQL Loader
Assignments:
● Homework 3 – SQL Loader
Session 4 – 02/15/23
Topic description –
● Introduction to SQL
Assignments:
● Homework 4 – Populate HR tables
● Group 2a – Data Model discussion
Session 5 – 02/22/23
Topic description –
● SQL Fundamentals
Assignments:
● Homework 5 – Discussions topic functions and joins
● Group 2 – Data Model final
Session 6 – 03/01/23
Topic description –
● SQL Joins and functions
Assignments:
● Homework 6 – SQL functions
Session 7 – 03/08/22
Topic description –
● Review for Midterm Exam
Assignments:
● Group 3 – Data Load
Session 8 – 03/22/23
Topic description –
● Mid Term Exam – everything we covered up to this point
Assignments:
● None
Session 9 – 03/29/23
Topic description –
● Advanced SQL – Sub Queries
Assignments:
● Homework 7 – Sub Queries
Session 10 – 04/05/23
Topic description –
● Advanced SQL – Top N, Pivot, Merge, and Analytical functions
Assignments:
● Homework 8 – Top N, Pivot, Merge, analytical function
Session 11 – 04/12/23
Topic description –
● Advanced SQL
Assignments:
● Homework 9 – Putting it all together in views
● Group 4 – SQL views
Session 12 – 04/19/23
Topic description –
● Database performance
Assignments:
● Homework 10 - performance
Session 13 – 04/26/23
Topic description –
● Final Exam
Assignments:
● None
Session 14 – 05/03/23
Topic description –
● Final Presentation
Assignments:
● Final Deliverables due
2023-01-30