NORFOLK STATE UNIVERSITY
700 PARK AVENUE * NORFOLK, VIRGINIA * 23504
Robinson Technology Center (RTC)
Office:: (757) 823-9454     Fax: (757) 823-9229
Email: CompSci@nsu.edu

Computer Science Courses

DEPARTMENT OF COMPUTER SCIENCE SYLLABUS

COURSE NUMBER & TITLE:
CSC-420  Database Principles & Design
COURSE CREDITS:
3
PREREQUISITES:
CSC 260 (Computer Programming II)
CO-REQUISITES:
See Instructor
COURSE DESCRIPTION:

An introductory course emphasizing the basic concepts and principles of database systems Topics include introductions to database systems and databases, different database system models, basic systems and language support (SQL) for database systems; relational modes, relational algebra and introductions to relational database design as well as overview of common database system issues.

COURSE MATERIALS / REQUIRED TEXT(s) / SUPPLEMENTARY READINGS:
  • Database System Design, Implementation and Management. 11th edtion.
    By Carlos Coronel, Steven Morris. ISBN:978-1-285-19614-5. Publisher- Cengage Learning

  • Oracle SQL by Example; WEB ISBN 0-13-704734-7.
    Free 24/7 online access is available through Safari via NSU library at
    http://0-proquest.safaribooksonline.com.library.nsu.edu/book/databases/9780137047345

  • References and Supplemental Readings
  • Fundamentals of Database Systems by Elmasri/Navathe;ISBN 0-321-36957-2
  • Database System Concepts, 4th Edition; by Silberschatz, Korth, Sudarshan
  • A Guide to SQL featuring ORACLE, by Philip JPratt
  • An Introduction to Database systems; by C.J.Date

COMPUTER SCIENCE OFFICE LOCATION:

The Department of Computer Science is located in Suite 320 Robinson Technology Center. The individual faculty offices are located within the suite.

COURSE RATIONALE:

This course is a required course for the Bachelor of Science Degree in Computer Science (Information Systems Curriculum BS.CSC.IS). Activities and assignments in this course support our program objectives currently listed on our departmental website (www.cs.nsu.edu/programs/ugradprogram.html).

COURSE GOALS & INTENDED OUTCOMES

    The major goals to be achieved by the student are to:
  • Introduce students to basic database system concepts
  • Introduce students to basic database models
  • Acquaint students with basic database system and language such as Structure Query Language (SQL)
  • Introduce students to different components of SQL that perform different database system transactions
  • Expose students with the relational model and relational algebra expressions
  • Introduce students to relational database design
  • Introduce database security
  • Explain the importance of data security and database secuirty

  • By the end of the course, students should be able to:
  • Describe the hierarchy of database system and database management systems
  • Differentiate among relational, hierarchical, network, and object oriented database system models,
  • Understand and utilize relational model to solve problems relate to database system,
  • Use Structure Query Language (SQL) to retrieve data from a database, update existing data in a database and create and modify database objects,
  • Illustrate the importance and means to maintain database integrity, database security and resolve concurrency issues
  • Explain the importance of maintaining security of the data
  • Design and create basic relational database objects using Oracle DBMS

COURSE OUTLINE

  • Introduction to Database Model
  • Data Models
  • The Relational Database Model
  • Data Modeling
  • Normalization of Database Tables
  • Structured Query Language
  • Database Design Strategies
  • Concurrency Control
  • Query Optimization
  • Database Security

PRIMARY METHOD(S) OF INSTRUCTION / METHODS TO ENGAGE STUDENTS

The primary instructional method for this class will be lecture and discussion. Students will also work in team to design, test and implement a relational database system. The Course management system Blackboard(nsu.blackboard.com) will be used to provide supplemental material and/or to administer some or all of the quizzes and examinations.

GRADING STANDARDS

    At the end of the semester, a letter grade is assigned according to your average score using the following grading scale:
  • A = 90 - 100
  • A- = 87 - 89
  • B+ = 85 - 86
  • B = 80 - 84
  • B- = 77 - 79
  • C+ = 75 - 76
  • C = 70 - 74
  • C- = 67 - 69
  • D+ = 65 - 66
  • D = 60 - 64
  • F = 0 - 59

ACADEMIC INTEGRITY STANDARDS

The department requires all work that contributes to a student's grade to be the unaided work of the student. Copying another's work, working together, asking others for help and giving help are not ethical and prohibited The only allowable source of help is the instructor. These rules apply to homework, tests, quizzes, laboratory exercises, take-home examinations and in-class examinations. When exceptions are made; as in the case of group projects, the cooperation that is allowed will be explained by the instructor. Any violation of the above rules or any other form of dishonesty, for example, changing an answer on an examination paper that has been returned and claiming credit for the corrected answer, will be treated seriously by the Department. In most cases, the students involved will immediately fail the course. Except in exceptional cases, where it can be demonstrated that work has been stolen from a student without the student's knowledge, the same penalties will apply to the provider and the copier.

Additionally,
The Department of Computer Science employs a no tolerance policy on cheating. Cheating includes, but is not limited to, copying others work, misrepresenting the work of others as your own (includes online sites and the use of code provided by online sites), plagiarism, sharing when unauthorized, and the use of cell phones and/or electronic media when unauthorized. The following outlines the departmental procedure if a student is suspected of cheating during their academic tenure with the Computer Science Department at Norfolk State University.

    Offense 1 –
  • The student will receive a grade of ZERO on the assignment AND a note will be placed in the student’s permanent departmental file. Non- CS Majors will receive a ZERO and be reported to the chair of their respective department.
  • Offense 2 –
  • The student will receive a letter grade of ‘F’ for the course AND the student will be reported to the Office of Student Rights and Responsibilities for adjudication.

    Class Attendance Policy: University
  • The University expects students to attend all classes and required meetings involving course work. While unnecessary absences are discouraged, the University recognizes that, on occasion, students may have legitimate reasons for being absent from class such as representing the University in official activities, illness or personal emergencies.
  • Each student has the responsibility to confer with his instructors regarding all absences or intended absences. If sudden departure from the campus prevents a student from communicating with each of his instructors, the student who is absent for an emergency or extraordinary reasons is expected to notify the Office of the Student Personnel Deans Instructors are not required to give students makeup work for assignments or tests, etc. missed during unexcused absences.
  • Excuses for verifiable illness may be obtained from the Health Center Written verification for extended illnesses must be submitted to the Student Personnel Dean's Office.

SCHOOL-WIDE TUTORING SERVICES STATEMENT

The college of Science, Engineering, and Technology provides tutoring services through the STARS Tutoring Center for those NSU student who may be experiencing difficulties in Mathematics, Computer Science, Engineering, Biology, Chemistry, Nursing, Technology and Physics courses. The STARS office is located in Suite 100, RTC. This service is free of charge and provided to NSU students only. You can access information about this service by going to http://stars.nsu.edu.

AMERICANS WITH DISABILITIES ACT (ADA) STATEMENT

In accordance with Section 504 of the Rehabilitation Act of 1973 and the Americans with Disabilities Act (ADA) of 1990, we ask if you have a disability or think you have a disability, please contact O.A.S.I.S., the Office of Accessibility Services, upon registration at Norfolk State University to confidentially discuss any accommodation needs.

    Audrey M. Wells, Coordinator, O.A.S.I.S.
    Office of Accessibility Services and International Student Services
    Norfolk State University, 700 Park Ave., Student Services Center, Suite 110, Norfolk, VA. 23504
    Phone: 757-823-8325, Fax: 757-823-2640, Email: amwells@nsu.edu

UNIVERSITY ASSESSMENT STATEMENT

As part of NSU's commitment to provide the environment and resources needed for success, students may be required to participate in a number of university-wide assessment activities. The activities may include tests, surveys, focus groups and interviews, and portfolio reviews. The primary purpose of the assessment activities is to determine the extent to which the university's programs and services maintain a high level of quality and meet the needs of students. Students will not be identified in the analysis of results. Unless indicated otherwise by the instructor, results from University assessment activities will not be computed in student grades.

WRITING COMPETENCY ASSESSMENT

All first-time freshmen and readmitted students entering Fall 2001 and thereafter and transfer students entering Fall 2002 and thereafter are required to take an exit examination to assess writing competency. After completing ENG 102, students must register for ENG 299 (no credit, no charge) until successfully passing the Examination of Writing Competency. Degree-seeking students at the baccalaureate level are required to take the writing examination before completing 90 semester hours. Associate degree-seeking students must take the exam no later than one semester prior to the anticipated date of graduation. For more information, refer tot he NSU Undergraduate catalog.

UNIVERSITY WIDE & COURSE-SPECIFIC REQUIREMENTS

    Information Technology Literacy
  • Learning foundation skills (hardware, software, and operating systems).

    Critical Thinking
  • Solving problems utilizing application software from a narrative description.
  • Knowing the appropriate software application to apply to a specific task.

    Laboratory
  • Demonstrating proficiency in utilizing software applications.
CLASS ATTENDANCE POLICY

A student is expected to attend all classes. The student assumes all responsibility for work missed due to an absence. Make-up work may be permitted at the discretion of the instructor. Refer to the NSU Student Handbook (https://www.nsu.edu/Assets/websites/student-affairs/student-handbook/NSU-Student-Handbook.pdf)

NSU EMAIL ACCOUNT

In an effort to keep student informed about Norfolk State University updates and account information, students must check their official NSU email account frequently. You may access your official NSU email account through the MyNSU portal at https://www.nsu.edu/mynsu/index. Once there, follow instructions provided to login to the MyNSU portal (NOTE: you access your NSU email from within the MyNSU portal).

DISCLAIMER: The instructor reserves the right to revise the syllabus as appropriate and will make reasonable attempts to notify students.