Science - Course - Database Systems

Data models and database systems architectures. Conceptual data modeling using entity-relationship diagrams (ERD and Enhanced ERD). The relational database models. Mapping conceptual data models into physical relational design. Theory of functional dependencies and normalization. Relational algebra and tuple relational calculus. Data definition and retrieval using SQL language. Pre-req.: CBIO 301 and CMPS 242. * The practical part of this course, provided by the department of Mathematics and Computer Science, will be adjusted accordingly for the group of Biology/Biochemistry students enrolled in the Computational Biology track. Students will devise efficient solutions to real-world data management problems on realistic data sets. Performance tuning of relational databases, querying graph-structured databases, querying streaming databases, indexing high-dimensional data, managing uncertainty in databases, information retrieval in databases, and implementation of database internals. Students will use an open-source database management system and a programming language API