X
X
X

X
Swayam Central

Database and Content Organisation

By   |  

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.



Learners enrolled: 854

SUMMARY

Course Status : Ongoing
Course Type : Core
Duration : 15 weeks
Start Date : 01 Aug 2019
End Date :
Exam Date : 09 Nov 2019
Category :
  • Library and Information Sciences
  • Level : Undergraduate

    COURSE LAYOUT

    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

    BOOKS AND REFERENCES

    Will be added along with the eContent

    INSTRUCTOR BIO

    COURSE CERTIFICATE

    DOWNLOAD APP

    FOLLOW US