Mumbai University

Introduction to file and Database Management Systems

Overview of Database Management.
1.1 Shortcomings of a file management system.
1.2 Difference between a database and a database system.
1.3 Benefits of database approach.
1.4 Data independence.
1.5 Data abstraction - Thee ANSI / SPARC architecture.
1.5.1 The external level.
1.5.2 The conceptual level.
1.5.3 The internal level.
1.5.4 Mappings between levels.
1.5.5 Data independence.
1.6 The database management system.
1.7 The database administrator.
1.8 Database users.
1.9 Overall database system architecture.

UNIT 2

2. Data Models.
2.1 The entity relationship model.
2.1.1 Entity sets, relationship sets.
2.1.2 Mapping cardinalities.
2.1.3 Primary key specification.
2.1.4 Entity relationship diagram.
2.1.5 Weak entities.
2.1.6 Extended E-R features.
2.1.7 Design of an ER schema.
2.1.8 Reducing an ER schema to tables.

UNIT 3

4. File Structures.
4.1 Fixed length records.
4.2 Sequential file organization.
4.3 Clustering file organization.
4.4 Data dictionary storage

5. Indexing and hashing.
5.1 . Types of indices.
5.1.1 Ordered indices.
5.1.2 B*- Tree index files.
5.1.3 B- Tree index files.
5.2. Hashing.
5.2.1 Static Hashing.
5.2.2 Dynamic Hashing.
5.3 Comparison of ordered indexing and hashing.
5.4 Multiple keys access.

Related pages

BUSINESS DATA PROCESSING

BUSINESS DATA PROCESSING Introduction to Business Organization : Need , Structure and nature of Information Systems – data processing activities-Management Information Systems .Introduction to structured programming . Typical analysis of systems like –Inventory, Accounting, Payroll, Production, etc. Introduction to Input / Output and Data Storage devices : their organisation and .....

Operating Systems

Unit-I: 1.1 Operating System Overview Operating Systems objectives & functions, the evolution of operating Systems, Major Achievements, Examples of Operating systems. WS: Chap.2.1 to 2.5 1.2 Process Description & Control Process states, Process Description, Process Control, Processes & Threads, Examples of Process Description & Control. WS: Chap. 3.1 to 3.6 1.3 .....

OPERATING SYSTEMS

OPERATING SYSTEMS Introduction to history of operating systems : Early batch systems, multiprogramming, timesharing, distributed O.S and multiprocessor O.S. Basic concepts: Processes, files, system calls, shell, layered structure v/s monolithic structure of O.S. Processes : Process model, process states, process hierarchies, implementation of processes, data structures used such as process .....

DATA BASE MANAGEMENT SYSTEMS

DATA BASE MANAGEMENT SYSTEMS Basic Concepts: Purpose of DBS, data obstruction, data models, instances and schemes, data independence, DDL, DML, DB manager, DB administrator, DB users, database system architecture. Entity Relationship Model: Entity & entity sets, relationships & relationship sets, attributes, mapping constants, keys, ER diagram, generalization, aggregation. Relational Model: .....

STRUCTURED SYSTEMS ANALYSIS AND DESIGN

STRUCTURED SYSTEMS ANALYSIS AND DESIGN THE SYSTEMS APPROACH : Background , reasons for adopting systems approach. Using systems approach for problem solving, and information systems design, Determining the scope and structure of a system. INFORMATION SYSTEM : Classification , transaction Processing systems , OLTP , Decision support systems , Management .....

THE LINUX OPERATING SYSTEM

Unit-IV: 4.1. Operating Systems & LINUX, History of LINUX& UNIX, LINUX Overview, Shell: Bourne, Kron & C-shell, File structure: Directories & files, Utilities: Editors, Filters & Communications. RP: Chap.1 Pages: 3 to 11. Installing LINUX: Hardware & Software Requirements, Creating LINUX partition, creating Install Disks, Installing Open LINUX System, Network .....

ELECTIVE I-1 ADVANCED COMPUTER ARCHITECTURE

ELECTIVE I-1 ADVANCED COMPUTER ARCHITECTURE Introduction to parallel processing: Trends towards parallel processing, parallelism in uniprocessor systems, parallel computer structure, architectural classification schemes. Memory and input output systems, memory structure hierarchy, addressing scheme for main memory, virtual memory systems, memory allocation and management strategies, virtual memory of X86 processors, cache .....

Principles of Rational Database Management System

UNIT 1 1. The relational database model. 1.1 Structure of relational database. 1.2 Relational algebra, extended relational algebra. 1.3 Relational calculus. 1.4 Modification of database. 1.5 Views. 2. Integrity constraints. 2.1 Domain constraints. 2.2 Referential integrity constraints. 2.3 Triggers. 2.4 Functional dependencies. 3. Controlling database access - users, groups, user authentication, user profiles and roles. UNIT 2 4. Structured .....

SYSTEMS PROGRAMMING

SYSTEMS PROGRAMMING Introduction to system programs and system programming, review of different System programs such as assemblers, loaders, linkers, compilers, interpreters, operating systems, device drivers etc. Elements of assembly language programming, overview of assembly process, design of one-pass and two pass assemblers, macros and macro processors, design of a macro .....

C PROGRAMMING

C PROGRAMMING · Features of C, ANSI C, structure of a C program. · Character set, variable names, data types, constants and declarations, scope and lifetime of variables. · Arithmetic, logical, relational, increment, bitwise, assignment operators and expressions, conditional expressions, precedence of order of evaluation and type conversion. · Basic .....

Recently Visited Pages

• Master of Science (Physical Therapy)
  Master of Science (Physical Therapy) M.Sc. (P.T.) Minimum Admission Requirement: 0.1057 Every candidate for admission to the course for the degree of Master of Science (.....)
• M.E. Degree Course : Computer Engineering
  College enrolling the students for the said course :- 1. Mahatma Gandhi Mission’s, College of Engineering and Technology, Junction of (.....)
• Foundation course in Fine art (Dance)
  Foundation course in Fine art (Dance) Duration: Two years Minimum Admission Requirement A candidate for being eligible for admission to the Foundation Course in Dance shall have (.....)
• M.Sc. Degree Course: Information Technology
  M.Sc. degree course in Information Technology conducted by : University Department of Information Technology, Vidyanagari Campus, Kalina, Santacruz (East), Mumbai – 400 098. Phone: (.....)
• Doctor of Hygiene
  Information about this course is coming soon. (.....)
• COMPUTER METHODOLOGY AND ALGORITHMS
  COMPUTER METHODOLOGY AND ALGORITHMS. SORTING : Bubble Sort, Selection Sort, Saker Sort, Insertion Sort, Shell Sort, Quick Sort, Heap Sort, Merge Sort, Radix Sort. Searching: (.....)
• SOCIOLOGY
  Courses available: M.A. ( Pt. I) M.A. ( Pt. II ) M.Phil Ph.D Intake Capacity: M.A. ( Pt. I) : 150 M.A. ( Pt. II ) (.....)
• M.E. Degree Course : Plastic Engineering
  M.E. degree Course in Plastic Engineering conducted by : University of Mumbai Institute of Chemical Technology, Nathalal Parikh Marg, Matunga (E), (.....)
• The General Applied Component Group
  The information about this course is coming soon. (.....)
• M.Sc. Degree Course: Analytical Chemistry
  M.Sc. degree course in Analytical Chemistry conducted by : University Department of Chemistry Vidyanagari Campus, Kalina, Santacruz (East), Mumbai – 400 098. Phone: 2652 6091 (.....)
• Master of Education (M.Ed)
  Master of Education(M.Ed) Duration: 2 Years Eligibility: B.Ed College/Subject: Refer the list of Colleges in the Booklet i.e. Information & Academic Centre 2002-2003. (.....)
• Bachelor of Dental Surgery
  Information about this course is coming soon. (.....)
• Advanced Diploma Course in Russian
  Advanced Diploma Course in Russian Duration: One year (part-time) Minimum Admission Requirement: 0.2679 Eligibility: A candidate for being eligible for admission to the Advanced Diploma Course in (.....)
• Bachelor of Science (Audiology and Speech Rahabilitation
  Bachelor of Science (Audiology and speech Rehabilitation) B.Sc. (A.S.R.) Minimum Admissions Requirement Eligibility: A candidate for being eligible for admission to the Bachelor of (.....)
• APPLIED PHYSICS II
  APPLIED PHYSICS II Theory of production of X-rays: Continuous and Characteristic X-rays spectra, X-ray diffraction, Laue spots, Braggs law and Moseleys law. Determination of crystal (.....)