This course
introduces you to the concepts of Database, Content Organization and some
emerging trends. In any Information Storage and Retrieval System (ISAR),
databases occupy the central position. Creation of efficient databases leads to
successful retrieval of information contained in that database. A database is
an organized collection of related data. In modern library environment,
electronic databases are used to support a wide-range of information management
operations and services. Knowledge in database concepts and applications
becomes essential for the success of information professionals in present
society. This course provides instruction on the database concepts, elements of
DBMS, Database models, and fundamentals of database design, database implementation
with a focus on library and information science practice, use of WINISIS, MySQL
and some emerging trends. Related and current database management technologies
will be used to illustrate the hands-on experiences.
| Course Status : | Completed |
| Course Type : | Core |
| Duration : | 15 weeks |
| Category : |
|
| Credit Points : | 4 |
| Level : | Undergraduate |
| Start Date : | 01 Aug 2019 |
| End Date : | |
| Exam Date : | 09 Nov 2019 IST |
Note: This exam date is subjected to change based on seat availability. You can check final exam date on your hall ticket.
|
S.No |
Title of the Session |
Weeks |
|
1 |
DBMS –Introductory Concepts |
Week - 1
|
|
2 |
Elements of DBMS |
|
|
3 |
Types of Databases and Data Models |
Week - 2
|
|
4 |
Relational Databases and Overview of DB Design |
|
|
5 |
Various Key Constraints in RDBMS |
|
|
6 |
Anomalies and Normalization |
Week – 3 |
|
7 |
File Organization - I |
|
|
8 |
File Organization - II |
|
|
9 |
Search Strategy - I |
Week – 4 |
|
10 |
Search Strategy - II |
|
|
11 |
Content Organization and Formats |
Week – 5
|
|
12 |
Indexing and Indexing Tools |
|
|
13 |
Types of SQL Commands and Introduction to MySQL |
|
|
14 |
Introduction to MySQL Commands - I |
Week - 6
|
|
15 |
Introduction to MySQL Commands – II |
|
|
16 |
Introduction to MySQL Commands – III |
|
|
17 |
Introduction to MySQL Commands – IV |
Week – 7
|
|
18 |
Introduction to MySQL Commands - V |
|
|
19 |
Database Recovery |
|
|
20 |
Transaction Management, Concurrency Control and Deadlock |
Week – 8 |
|
21 |
Textual DBMS Major features |
|
|
22 |
CDS/ISIS for Windows An Introduction |
|
|
23 |
Use of Content Designators in WINISIS |
Week - 9 |
|
24 |
Common Communication Format (CCF) in WINISIS |
|
|
25 |
Steps in Developing Databases in WINISIS |
|
|
26 |
Steps in WINISIS: FDT and Worksheet |
Week -10 |
|
27 |
Steps in WINISIS: Pickup Lists in Worksheet |
|
|
28 |
Steps in WINISIS: Basic Formatting Language |
|
|
29 |
Steps in WINISIS: Advanced Formatting Language |
Week - 11 |
|
30 |
Steps in WINISIS: Field Selection Table |
|
|
31 |
Data Entry and Data Export/Import in WINISIS |
|
|
32 |
Searching and Browsing in WINISIS |
Week – 12 |
|
33 |
Utilities in WINISIS |
|
|
34 |
CDS/ISIS Software Family |
Week – 13 |
|
35 |
Textual Databases Evolution and Evaluation |
|
|
36 |
Introduction to Open Access Database Services |
Week - 14 |
|
37 |
Text Retrieval Engines |
|
|
38 |
Multilingual Text Retrieval |
Week – 15 |
|
39 |
Data Mashup |
|
|
40 |
Linked Open Data for Libraries |
DOWNLOAD APP
FOLLOW US