Data and Database Modeling
Course title: Data and Database Modeling
Code: FEIT07Z019
Number of credits (ECTS): 6
Weekly number of classes: 2+2+1+0
Prerequisite for enrollment of the subject: None
Course goals/Competences: Data Modeling and design of data structures suitable for optimum operation of databases. Using the basic set of SQL commands for working with databases.
Total available number of classes: 180
Curriculum: Introduction of data structures used in database modeling. The data structures include data objects, associations between objects and rules for performing operations over objects. Modelling of databases regarding user demands. Basic database concepts. Configurations and commands for certain real databases. SQL commands for working with databases.
Literature:
Literature |
||||
Compulsory literature |
||||
No. |
Author |
Title |
Publisher |
Year |
1 |
R. W. Scamell, N. S. Umanath |
Data Modeling and Database Design, 2007 |
Course Technology |
2007 |
2 |
L. Silverston, P. Agnew |
The Data Model Resource Book, Vol. 3: Universal Patterns for Data Modeling |
John Wiley & Sons |
2009 |
3 |
A. Silberschatz, H.Korth, S. Sudarshan |
Database System Concepts, 6th Edition |
McGraw-Hill |
2010 |
Further literature |
||||
No. |
Author |
Title |
Publisher |
Year |
1 |
G. Simsion, G. Witt |
Data Modeling Essentials, 3rd Ed, |
Morgan Kaufmann |
2004 |
2 |
T. Teorey et all |
Database Design: Know It All |
Morgan Kaufmann |
2008 |
3 |
S. Hoberman |
Data Modeler's Workbench: Tools and Techniques for Analysis and Design |
John Wiley & Sons |
2001 |