Practice actual database design implementation and

This preview shows page 3 - 7 out of 14 pages.

Practice actual database design, implementation, and query formulation through a term project. Develop teamwork and communication skills through the course project, which is implemented by a group of students.
Image of page 3

Subscribe to view the full document.

4 CS281 : Course Outline Introduction to Conceptual Database Design o Entity-Relationship (ER) Model Relational Data Model o Basics, integrity constraints, querying, logical database design: ER to relational, views. Relational Algebra Structured Query Language (SQL) o Basic form, set operations, nested queries, aggregate operators, more advanced features such as integrity constraints, table constraints, assertions, triggers.
Image of page 4
5 CS281 : Course Outline (cont.) Query By Example (QBE) Database Application Development and Internet Applications o Introduction to DB application development, JDBC, overview of Internet appications, 3 tier architectures, HTML forms, PHP. Relational Database Design o Functional Dependency Theory Attribute closure, FD set closure, 3NF, BCNF, decomposition lossless-join decomposition, dependency-preserving decomposition. o Normalization of Relations Decomposition into 3NF, BCNF.
Image of page 5

Subscribe to view the full document.

6 CS281 : Course Outline (cont.) Storage and Indexing o
Image of page 6
Image of page 7
You've reached the end of this preview.
  • Spring '10
  • smith
  • Databases, Relational model, Conceptual Database Design

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern