Course Title:

Advanced Database

Course Prefix & Number: 

ITSW 2337

Section Number: 

0340

Semester/Year:

2021 SP

Semester Credit Hours:

3

Lecture Hours:

32

Lab Hours:

32

Course Description (NCTC Catalog):

Advanced concepts of database design and functionality. 32 lecture hours + 32 lab hours. At the conclusion of the course a student will be able to: Explain relational database theory; collect and distribute data; analyze data; and perform complex queries, data validation and table relationships.                                                                   

Course Prerequisite(s): ITSW 1307 Introduction to Database

Required Course Materials:

Database Systems: Design, Implementation, & Management, 13th Edition

Carlos Coronel; Steven Morris

ISBN-13: 978-1-305-62790-0

Name of Instructor:

Manuel Trevino, Jr

Campus/Office Location:

Corinth Campus – Room 255

Telephone Number:

940 498 6480

E-mail Address:

mtrevino@nctc.edu

At the successful completion of this course the student will be able to:

Apply the theory, concepts, and skills involving specialized materials, tools, equipment, procedures, regulations, laws, and interactions within and among political, economic, environmental, social, and legal systems associated with the occupation and the business/industry

Demonstrate legal and ethical behavior, safety practices, interpersonal and teamwork skills, and appropriate written and verbal communication skills using the terminology of the occupation and the business/industry

# of Graded Course Elements

Graded Course Elements

Points per Assignment

Total Points

Points Contribution to Overall

8

Lab Assignments

50

400

30.3%

8

Discussion Forum Assignments

20

160

12.1%

2

Projects

100

200

15.2%

8

Quizzes

20

160

12.1%

4

4 Exams & Final Exam  (drop lowest grade if All exams have been taken) 

100

400

30.3%

TOTAL

1320

100%

*Students found plagiarizing in an assignment in this course may receive an "F" for the course along with a report turned into the Dean for Scholastic Dishonesty.

*Students with continued absences and discussion posts that add no value will receive a “0” for the assignment. The class discussion forums and exams will be used to determine regular attendance.

GRADING POLICY

Total

Points

Letter

Grade

Final %

Grading in this course is point driven. The maximum number of points may vary semester to semester.  

Labs and Discussion assignments will be graded within two weeks after due date.

Letter grades for this course will be assigned in accordance with NCTC standard grading policy:

1182 - 1320

A

90 to 100

1050 - 1181

B

80 to 89.9

918 - 1049

C

70 to 79.9

786 - 917

D

60 to 69.9

< 786

F

< 60

• EXPLAIN RELATIONAL DATABASE THEORY;

• COLLECT AND DISTRIBUTE DATA;

• ANALYZE DATA;

• PERFORM COMPLEX QUERIES, DATA VALIDATION AND TABLE RELATIONSHIPS.

Topic

General Description of Subject Matter

Chapter 8 Advanced SQL

Focuses on creating database structures and manipulating the data in tables. The material covers creating databases and objects within the databases, such as tables, indexes, and views. 

Chapter 9 Database Design

An information system performs three sets of services:
• It provides for data collection, storage, and retrieval.
• It facilitates the transformation of data into information.
• It provides the tools and conditions to manage both data and information.

Chapter 10 Transaction Management and Concurrency Control

Emphasize the following points:
• A transaction represents a real-world event such as the sale of a product.
• A transaction must be a logical unit of work. That is, no portion of a transaction stands by itself. For example, the product sale has an effect on inventory and, if it is a credit sale, it has an effect on customer balances.
• A transaction must take a database from one consistent state to another. Therefore, all parts of a transaction must be executed or the transaction must be aborted. (A consistent state of the database is one in which all data integrity constraints are satisfied.)

Chapter 11 Database Performance Tuning and Query Optimization

This chapter focuses on the factors that directly affect database performance.  Because performance-tuning techniques can be DBMS-specific, the material in this chapter may not be applicable under all circumstances, nor will it necessarily pertain to all DBMS types.

Chapter 12 - Distributed Database Management Systems

The most primitive and least effective of the distributed database scenarios is based on a single SQL statement (a "request" or "unit of work") is directed to a single remote DBMS. (Such a request is known as a remote request.).

Chapter 13 Business Intelligence and Data Warehouses

Discuss the need for data analysis and how such analysis is used to make strategic decisions. The computer systems that support strategic decision-making are known as Decision Support Systems (DSS). Explain what a DSS is and what its main functional components are.

Syllabi Statements Spring 2021 - COVID-19 Specific

Conversion of Onsite Classes to Online/Remote Format: North Central Texas College students should be aware that in the event of a college closure due to COVID-19, onsite classes will be converted to an online/remote format. Students should plan ahead to ensure they have access to the computer equipment (either PC, MAC, or tablet), webcam, and internet connectivity to continue their classes in an online/remote format. Please read all your official North Central Texas College student emails as the transition from onsite to online/remote might require a reorganization in your personal situation. Students will be granted a 72-hour transition and grace period. Online classes will continue as scheduled without disruption. Wear a mask, stay safe, and contact your Instructor as the situation arises. These policies and procedures were updated on July 30, 2020 and are subject to change as conditions change.

Face Coverings: Per the North Central Texas College guidance on face coverings on campus, in the instructional setting, faculty and students must wear face coverings, such as masks or face shields. Students without coverings, or those who do not comply with the rules relating to face coverings, will not be able to participate in on-campus classroom activities. To request an exception to this requirement, students should contact the NCTC HR Office of Enrollment Management (ccove@nctc.edu). Failure to comply with the face coverings requirement may result in the Instructor directing the student to leave the classroom. Any student asked to leave the classroom may be referred to the student conduct officer. These policies and procedures were updated on July 30, 2020 and are subject to change.

Temporary COVID-19 Attendance Policy for Face-to-Face Meetings: We are facing an unprecedented situation in which all of us must be flexible and make prudent decisions in the best interest of our families, our campus, and our community. In light of this, North Central Texas College is temporarily establishing the requirement that faculty keep records of student attendance for face-to-face course meetings as well as a documented seating chart. In addition, students who are sick or need to quarantine should not attend classes. Students will not be required to provide formal documentation from a health care provider and will not be penalized for COVID-19 related absences when proper notification to campus health officials is made in accordance with the guidelines stated below.

Faculty will:

• Notify students about important course information and delivery changes through Canvas and campus email.

Students should:

• Provide notification to campus officials (via NCTC Daily Health Check protocol through Canvas) if they have tested positive for COVID-19 or have to quarantine so we can confirm reported absence with instructors, monitor, and assist the campus community.
• Notify instructors in advance of the absence.
• Connect with that class through Webex if the class session is being transmitted in a hybrid fashion.
• Keep up with and/or make up missed classwork or assignments.
• Submit assignments digitally through Canvas or other means as announced by your instructor.
• Work with their instructors to reschedule exams, labs, and other critical academic activities described in the course syllabus.
• Check Canvas and campus email daily to receive important announcements pertaining to the course.

During the spring 2021 semester, faculty with face-to-face meetings will establish assigned seating/work stations to facilitate roll-taking, and, if necessary, contact tracing. Additionally, we ask all members of the College community to be attentive to their health, and safeguard others, by following the CDC’s guideline to “stay home when you are sick.” You should stay home if you have symptoms. More information on what to do if you are sick is available at the CDC’s website.

Additional NCTC information is available at http://www.nctc.edu/coronavirus/index.html