data modeling
Vilnius Gediminas Technical University
Jelena Mamčenko
Lecture Notes on INFORMATION RESOURCES
Part I
Introduction to Dta Modeling and MSAccess
Code FMITB02004
Course title Information Resourses
Course volume 3,0 cr. (4,50 ECTS cr.)
Teaching methods (Full-time, daytime studies):
Lectures - 16 h per semestre
Laboratory works - 32 h per semestre
Individual work - 72 h per semester
Course aim
Understandig of models and system of information resourses.
Jelena Mamčenko
Introduction to Data Modeling and MSAccess
CONTENT
1
2
3
4
5
6
Introduction to Data Modeling ............................................................................................................... 5
1.1
Data Modeling Overview ............................................................................................................... 5
1.1.1
Methodology .......................................................................................................................... 6
1.1.2
Data Modeling In the Context of Database Design................................................................ 6
1.1.3
Components of A Data Model................................................................................................ 6
1.1.4
Why is Data Modeling Important? ......................................................................................... 6
1.1.5
Summary ................................................................................................................................ 7
1.2
The Entity-Relationship Model ...................................................................................................... 7
1.2.1
Basic Constructs of E-R Modeling......................................................................................... 7
1.2.2
Entities.................................................................................................................................... 7
1.2.3
Special Entity
Jelena Mamčenko
Lecture Notes on INFORMATION RESOURCES
Part I
Introduction to Dta Modeling and MSAccess
Code FMITB02004
Course title Information Resourses
Course volume 3,0 cr. (4,50 ECTS cr.)
Teaching methods (Full-time, daytime studies):
Lectures - 16 h per semestre
Laboratory works - 32 h per semestre
Individual work - 72 h per semester
Course aim
Understandig of models and system of information resourses.
Jelena Mamčenko
Introduction to Data Modeling and MSAccess
CONTENT
1
2
3
4
5
6
Introduction to Data Modeling ............................................................................................................... 5
1.1
Data Modeling Overview ............................................................................................................... 5
1.1.1
Methodology .......................................................................................................................... 6
1.1.2
Data Modeling In the Context of Database Design................................................................ 6
1.1.3
Components of A Data Model................................................................................................ 6
1.1.4
Why is Data Modeling Important? ......................................................................................... 6
1.1.5
Summary ................................................................................................................................ 7
1.2
The Entity-Relationship Model ...................................................................................................... 7
1.2.1
Basic Constructs of E-R Modeling......................................................................................... 7
1.2.2
Entities.................................................................................................................................... 7
1.2.3
Special Entity
References: 2. Approach. The Benjamin/Cummings Publishing Company, 1991. 3. Date, C. J. An Introduction to Database Systems, 5th ed. Addison-Wesley, 1990. 5. Kroenke, David. Database Processing, 2nd ed. Science Research Associates, 1983 8. Simsion, Graeme. Data Modeling Essentials: Analysis, Design, and Innovation. International ThompsonComputer Press, 1994. 9. Teory, Toby J. Database Modeling & Design: The Basic Principles, 2nd ed.. Morgan KaufmannPublishers, Inc., 1994