The Data Base course covers concepts of management of data bases stored in information systems. The student studies the basics of query, manipulation and transaction languages through SQL databases.
On completion of the unit, the student will be capable of: | Classification level | Priority |
---|
Percentage ratio of individual assessment | Percentage ratio of group assessment | ||||
---|---|---|---|---|---|
Written exam: | 80 | % | Project submission: | % | |
Individual oral exam: | % | Group presentation: | % | ||
Individual presentation: | % | Group practical exercise: | % | ||
Individual practical exercise: | % | Group report: | % | ||
Individual report: | 20 | % | |||
Other(s): % |
Type of teaching activity | Content, sequencing and organisation |
---|---|
Course + Practical course | Data bases and data base management systems and Conceptual Data Model SQL, integrity and data definition language, and MERISE, Conceptual Data and Conceptual Flow Model Data manipulation language and SQL Data control and transaction language, management of SQL priorities and physical and indexation models. Advanced SQL and OLAP, and Transactions, priorities and indexation Advanced SQL and practical case studies |