A student successful in this course will be able to:
- create and read, accurately, ER and EER diagrams,
- map a conceptual DB design into a set of relations,
- create and understand queries written in relational algebra, SQL, and relational calculus to perform common information processing and analytics tasks,
- identify and derive the functional dependencies in a domain,
- normalize a relational database to a required normal form,
- create a concurrent database application with full ACID properties,
- be aware of and know the basics of with distributed key-value stores, columnar databases and document databases,
- to programatically discover, use and provide web services, in their DB applications.