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-422   Database Implementation
COURSE CREDITS:
3
PREREQUISITES:
Data Structures, UNIX and C, and Database Principles and Design
CO-REQUISITES:
See Instructor
COURSE DESCRIPTION:

A second database course for computer science majors with information system emphasis. Topics include database design methodology and tools, data organizations concepts, database applications design and implementation, database application programming using embedded SQL, and database administrations. Project(s) of more significant size and complexity will be completed during the semester.

COURSE MATERIALS / REQUIRED TEXT(s) / SUPPLEMENTARY READINGS:
    Required Text:
  • Database System Concepts by Silberschatz, Korth, Sudarshan Oracle PL/SQL by Example 4th Edition, by Benjamin Rosenzweig and Elena Silvestrova. ISBN 0-13-978-0-13-714422-8

  • References:
  • Oracle Pl/SQL 101, by Allen
  • Database Management Systems, by Ramakrishnan and Gehrke
  • Oracle PL/SQL Programming, by Urman, McgrowHill
  • The WebPage Workbook, by Groves, Franklin, Beedle & Associates
  • Perl 5 How-to, Asbury, Waite Group Press
  • Learning to Use Windows Applications Microsoft Access 2 for Windows, Chelly, Cashman, Pratt

Purchase books/supplies Online at NSU Barnes & Nobles Bookstore (http://norfolkstate.bncollege.com)

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 core courses for the Bachelor of Science Degree in Computer Science with Information System Specialty

COURSE GOALS & INTENDED OUTCOMES

    Main Objective:
  • To introduce students to database design and development process.
  • To introduce students to the life cycle of database applications.
  • To acquaint students with various database application development tools.
  • To introduce students to database administration
  • Measureable Objectives:
  • To independently analyze and develop database system specifications for an enterprise of relative large size.
  • To understand the various data organizations and their effects on database performances.
  • To represent the meanings and interactions of real-world enterprises in a conceptual schema through entity-relationship (E-R) data model.
  • To identify and develop useful database applications independently using Oracle PL/SQL and/or embedded SQL.

COURSE OUTLINE

  • Overview of Database Systems
  • Review of Database Design and Normal Forms
  • Database Front End System
  • Overview of Data Organizations
  • Overview of Database Reports
  • Database Application Development with PL/SQL and Embedded SQL
  • Database Administration and Database Security Reinforcement
  • Exposure to other database RDBMS or application development tools (optional)

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

Instruction will be conducted in the format of classroom lectures. In addition to text books adopted for the class, supplemental web resources are available through Blackboard.

GRADING STANDARDS

Test and Quizzes 20%
Semester Project 30%
Homework and Laboratory Assignments 30%
Final Examination 20%
    Grading Policy and Important Examination Dates
  • Completion of all required course works is the responsibility of each individual student. Students who turned in works that are identical or similar in ways that collaborations among students are suspected will be penalized by receiving a zero grade for the assignment in question.
  • All assignments are to be submitted through the Digital Drop Box utility of Blackboard by the respective due time/date unless stated otherwise by your instructor.
  • No late work will be accepted / graded after discussions of solutions with or without your presence.
  • Quizzes may be given on-line through Blackboard and/or during scheduled classroom meeting time. On-line quizzes must be completed and submitted within the given time frame and time limit. Any on-line quizzes completed beyond the given time frame/time limit will not be graded, and a score of zero (0) will be posted for the quiz.
  • Midterm Examinations are to be given inside classroom on Wednesday of the Midterm Week.
  • No make-up quizzes, Midterm or Final examinations will be given.

  • The instructor reserves the right to revise the grading criteria as appropriate and will make reasonable attempts to notify students

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.

OTHER REQUIREMENTS
    TECHNICAL REQUIREMENTS
  • Personal computer with Internet connection, web browser MS Internet Explorer, word processor MS Word, remote login program such as PuTTY, and file transfer program such as psFTP.
    NOTE: You may use the computers open labs on the first and second floors of RTC. All required hardware and software are available on computers in these laboratories. Please observe all laboratory rules and posted laboratory hours. Oracle SQL Worksheet and Oracle Forms Builder are also available on PCs in all Computer Science Laboratories. Additionally, The SUN Workstations in RTC-207 can be used to access UNIX and Oracle directly without remote connecting. Optionally, you may install Oracle Personal Version that come with one of the texts to complete your laboratory assignment.
  • You still need to submit the required deliverables through Blackboard Messages even if you’re using your own computer and software.
  • Student must be proficient in the following prior to taking this class: Using an operating system (windows 2000 or Windows XP), keyboarding, creating documents with MS Word, Notepad, and WordPad, and navigating the World-Wide-Web with a web browser. Optionally, experience with UNIX operating system.

    COMPUTER SYSTEM ACCOUNTS
    The following computer accounts will be created for all students enrolled in the class:
  • Individual username and password ( to access the UNIX system.)
  • Individual username and password ( to access the Oracle database running on the UNIX system.)
  • Individual username and password ( to use the personal computers to access files on the CS Departmental server.)

    COMMUNICATIONS OUTSIDE THE CLASSROOM
  • Consultations can be conducted in the instructor’s office during scheduled office hours posted next to my office door.
  • Blackboard Messages can be used to conduct more private electronic communications among fellow students and between students and instructor. BB Messages will also be used to submit deliverables for grading. Please check your BB Messages Inbox regularly.
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.