Office Hours: Monday, Friday 1000-1300

Phone: 0695 489 424

E-mail: narasimharao@unyt.edu.al

Course Website: https://sites.google.com/site/databasesystemsfall2015/

 

 

Course Description

 

This course follows a step-by-step introduction to the topics concerning database concepts, basic SQL SELECT statements, table creation and management, constraints, data manipulation and transaction control, additional database objects, user creation and management, joining data from multiple tables, and exploring SQL topics in application development. This course also explores database design concepts including entity-relationship diagrams and normalization. This course is also designed to provide a working introduction to PL/SQL programming within the Oracle RDBMS environment. The course begins with an introduction to the PL/SQL language fundamentals of block program structure, variables, cursors, exceptions, stored procedures, functions, and triggers.

 

Prerequisite: Data Structures.

 

 

Required Readings, Text

 

Casteel, Joan, Oracle 10g: SQL.  Course Technology Incorporated, 2005, ISBN 1-4188-3629-X.

Casteel, Joan, Oracle 10g Developer: PL/SQL Programming. Course Technology Incorporated, 2008, ISBN 13: 978-1-4239-0136-5 © 2008, ISBN 10: 1-4239-0136-3

 

 

Recommended Reading

 

  1. Silberschatz, H.F. Korth, S. Sudarshan : Database System Concepts (5th Edition) McGraw-Hill

 


Course Objectives

 

Upon completion of this course, students should be able to:

  • Describe the features of database management systems.
  • Construct database models from informal descriptions, and translate between such models.
  • Implement, manipulate and query relational databases.
  • Understand querying from multiple tables.
  • Understand different database objects.
  • Create PL/SQL program blocks.
  • Identify and use appropriate programming constructs to fulfill application logic needs.
  • Manipulate database tables using PL/SQL programming.
  • Build error trapping facilities within PL/SQL programs.
  • Create PL/SQL program units including: procedures, functions, triggers, and packages.

 

Content of the Course

 

  • Purpose of a database system, data models, database languages.
    Design issues, Entity-Relationship diagrams, mapping to tables
    Relational database design concepts, decomposition and normalization, integrity constraints.
  • Retrieving Data Using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables
  • Using Sub queries to Solve Queries
  • Using the Set Operators
  • Manipulating Data
  • Using DDL Statements to Create and Manage Tables
  • Creating Other Schema Objects
  • Designing PL/SQL Code
  • Creating Stored Procedures
  • Creating Stored Functions
  • Creating Packages
  • Working with Packages
  • Creating Triggers

 


Course Requirements

 

Participation: Participation extends beyond mere attendance. Expect your instructor to keep track of how often you contribute to class discussion (as a whole), particularly during the panel discussion section. You may miss up to three classes without penalty – your first two absences count whether you have a good excuse or not. Each absence beyond the first three will cost you points off of your participation grade. The only exceptions to this rule are severe illness (doctor’s note required) and UNYT approved trips/activities. Appropriate documentation for absences beyond the first three is necessary the class day directly before or after the one you miss. In general: this class is intensive and interactive. Missing class could seriously affect your grade! Students are reminded not to approach the instructor for copies of the previous week’s materials during immediately before, during, or immediately after class. Students are expected to collect materials from their classmates or see the instructor during consultation hours.

 

Exams: Two examinations will be taken, a midterm and a final exam covering all course content during the final examination period. Test format may combine a mixture of short answer, true/false, matching, sort answer, and one or two essay questions covering all readings, lecture, hand-out and class discussion content.

 

Final Examination: TBA 

 

General Requirements

 

Late assignments and absence from tests will not be tolerated.  In the event of illness or emergency, contact your instructor IN ADVANCE to determine whether special arrangements are possible. The University’s rules on academic dishonesty (e.g. cheating, plagiarism, submitting false information) will be strictly enforced. Please familiarize yourself with the STUDENT HONOUR CODE, or ask your instructor for clarification.

 

Learning Difficulties: If you feel that you have encountered special learning difficulties or serious problems that interfere with your studies, please make an appointment with UNYT Counseling Center, Dr. E Cenko (enilacenko@unyt.edu.al) and/or the Academic Support Center, Dr. A Canollari (albanacanollari@unyt.edu.al).  For more information, please contact me and or your academic advisor.
Criteria for Determination of Grade, including Evaluation Methods

 

Assignments 30%
Midterm 30%
Final 40%

 

Note: Late submissions to assignments will be penalized with a deduction of 20% for every day of late submission. All submissions should be made through Turnitin. Any submission beyond the deadline as indicated in Turnitin will be regarded as late submission.

 

Grading Scale

 

Letter Grade Percent (%) Quality Points Generally Accepted Meaning
      A 96-100 4.00 Outstanding work
      A- 90-95 3.67
      B+ 87-89 3.33 Good work, distinctly above average
      B 83-86 3.00
      B- 80-82 2.67
      C+ 77-79 2.33 Acceptable work
      C 73-76 2.00
      C- 70-72 1.67
      D+ 67-69 1.33 Work that is significantly below average
      D 63-66 1.00
      D- 60-62 0.67
      F 0-59 0.00 Work that does not meet minimum standards for passing the course

 

 


Course Outline

 

Week Topics Chapter

Readings

Exams
1 Overview of Database Concepts

DDL and DML statements

Chapter 2

Chapter 3

2 Data Manipulation and Transaction Control Statements Chapter 5
3 Constraints Chapter 4
4 Additional Database Objects

User Creation and Management

Chapter 6

Chapter 7

5 Database Design and E-R diagrams Relational Database Design, Storage and File Structure, Normalization Chapter 6

Chapter 7

Chapter 11

 

6 Single Row and Group Functions, Restricting and Sorting data, Views Chapter 8

Chapter 10

Chapter 11

Chapter 13

7 Mid-term Exam
8 Joins Chapter 9
9 Sub-queries and Merge Chapter 12
10 Introduction to PL/SQL

Basic PL/SQL block structures

Chapter 1

Chapter 2

11 Cursors and Exception Handling Chapter 4
12 Stored Procedures Chapter 5
13 Stored Functions and Packages Chapter 6

Chapter 7

14 Triggers Chapter 9
15 Final Exam

 

Textbook: Casteel, Joan, Oracle 10g: SQL.  Course Technology Incorporated, 2005, ISBN 1-4188-3629-X.

Casteel, Joan, Oracle 10g Developer: PL/SQL Programming. Course Technology Incorporated, 2008, ISBN 13: 978-1-4239-0136-5 © 2008, ISBN 10: 1-4239-0136-3

  1. Silberschatz, H.F. Korth, S. Sudarshan : Database System Concepts (5th Edition) McGraw-Hill


Bibliography (Additional Readings)

 

Atre, Shaku (1988) Database: Structured Techniques for Design, Performance, and Management, 2nd Edition, John Wiley & Sons, USA

Benynon-Davies, Paul (2004) Database Systems, Third Edition, Palgrave Macmillan, China

Brookshear, J Glenn (2005) Computer Science an overview, Eighth Edition, Addison-Wesley, USA
Clanchy, John; Ballard, Brigid (ed) (1997) Essay writing for students : a practical guide, 3rd Edition, Longman, South Melbourne, Australia
Connolly, Thomas; Begg, Carolyn (1999) Database Systems A Practical Approach to Design,

Elmasri, Ramez; Navathe, Shamkant B (2000) Fundamentals of Database Systems, 3rd Edition, Addison-Wesley, USA
Harrington, Jan L (2002) Relational Database Design Clearly Explained, Second Edition, Morgan Kaufmann, USA

Hawryszkiewycz, Igor T (1984) Database Analysis and Design, Science Research Associates, USA

Hawryszkiewycz, Igor T (1990) Relational Database Design : An Introduction, Prentice Hall, Parramatta, NSW, Australia

Kifer, Michael and Bernstein, Arthur and Lewis, Philip M (2005) Database Systems: An Application-Oriented Approach, Second Edition, Addison Wesley, USA

Kroenke, David M (1992) Database Processing : Fundamentals Design Implementation, 4th Edition, Macmillan, USA

Larson, James A (1995) Database Directions, Prentice Hall, USA

Pratt, Philip J and Adamski, Joseph J (1994) Database Systems : Management and Design, Third Edition, boyd & fraser publishing company, USA
Rob, Peter and Coronel, Carlos (1997) Database Systems : Design, Implementation, and Management, 3rd Edition, Course Technology, International Thomson Publishing, USA

Oracle in a Nutshell, by Rick Greenwald, David C. Kreines, Orielly Press

PL/SQL Programming, 3rd Edition, By Steven Feuerstein, Bill Pribyl, Orielly Press.

 

Technology Expectations

 

  • Software Required: Oracle 10g//11g, Microsoft SQL Server.
  • Students must keep copies of all assignments and projects sent by e-mail.
  • Assignments are to be word-processed. Continuing and regular use of e-mail is expected.

 

Date: September 10, 2015                              Prepared by:  Dr. Narasimha Rao Vajjhala

 

Faculty: Arts & Sciences.

Department: Comp.Science.

Grade: Undergraduate.

Majors: Computer Sciences.

Study Fileds: Computer Science and Management of Information Systems.

Course Year: 2.

Course Program: UNYT.

Scheduele: THU 09-12:00

Instructor: Rao Narasimha Vajjhala

Credits: 3

Prerequisite: Data Structures