#1
31st December 2015, 05:00 PM
| |||
| |||
DBMS Notes for MBA
I want to get information about the DBMS Notes for MBA, so here can you provide me information about its notes with details?
|
#2
31st December 2015, 05:01 PM
| |||
| |||
Re: DBMS Notes for MBA
As per your demand here I am providing you information about the DBMS Notes for MBA, but here you did not mention name of university, so here I am providing you a generally notes, which is almost same at all university. Here I am providing you information about it as you want. Unit – I Introduction to Databases and Transactions: What is database system, purpose of database system, view of data, relational databases, database architecture, transaction management Unit- II Data Models: The importance of data models, Basic building blocks, Business rules, The evolution of data models, Degrees of data abstraction. Unit-III Database Design, ER-Diagram and Unified Modeling Language: Database design and ER Modelverview, ER-Model, Constraints, ER-Diagrams, ERD Issues, weak entity sets, Codd’s rules, Relational Schemas, Introduction to UML Unit- IV Relational Algebra and Calculus: Relational algebra: Introduction, Selection and projection, set operations, renaming, Joins, Division, syntax, semantics. Operators, grouping and ungrouping, relational comparison. Unit- V Constraints, Views and SQL: What is constraints, types of constrains, Integrity constraints, SQL: Data definition, aggregate function, Null Values, nested sub queries, Joined relations. Unit-VI Transaction management and Concurrency control: Transaction management: ACID properties, serializability and concurrency control, Lock based concurrency control (2PL, Deadlocks),Time stamping methods, optimistic methods, database recovery management. INTRODUCTION TO DATABASE MANAGEMENT SYSTEM: Unit Structure 1.0 Objectives 1.1 Introduction 1.2 What is Database Management System 1.3 History of Database System 1.4 Purpose of Database System 1.5 Advantages and Disadvantages of Database System 1.6 Summary 1.7 Model Questions UNIT 1MODULE 1: INTRODUCTION Database systems – Definition – Components – Advantages – Objectives – Evolution. Definition : DBMS A database management system is a collection of programs that managesthe database structure and controls access to the contents.Well known DBMSs includeOracle,IBM DB2,Microsoft SQL Server,PostgreSQL, MySQLandSQLite. Evolution of database and DBMS technology coincided with the availability of direct-accessstorage (disks and drums) from the mid-1960s onwards. The term represented acontrast with the tape-based systems of the past, allowing shared interactive use rather than daily batch processing. . Two developments of noteare theObject databaseand theXML database.The vendors of relational databases have fought off competition from these newer models by extending the capabilities of their own products to support a wider variety of data types. General-purpose DBMS A DBMS has evolved into a complex software system and its development ADVANTAGES OF DBMS • Duplication of same data in different files. • Wastage of storage space, since duplicated data is stored. • Errors may be generated due to updating of the same data in different files. • Time in entering data again and again is wasted. • Computer Resources are needlessly used. • It is very difficult to combine information. For example: - Let us consider an example of student's result system. Suppose that inSTUDENT file it is indicated that Roll no= 10 has opted for 'Computer' course but inRESULT file it is indicated that 'Roll No. =l 0' has opted for 'Accounts' course. Thus,in this case the two entries for z particular student don't agree with each other. Thus,database is said to be in an inconsistent state. So to eliminate this conflictinginformation we need to centralize the database. Here I am providing you name of some best colleges; Top MBA colleges in India Sr. No. Colleges City 1 Indian Institute of Management Ahmedabad 2 Indian Institute of Management Bangalore 3 Indian Institute of Management Calcutta 4 Indian Institute of Management Lucknow 5 Institute of Rural Management Anand 6 Xaviers Labour Relation Institue Jamshedpur 7 Management Development Institute Gurgaon 8 Indian Institute of Management Indore 9 S.P. Jain Institute of Management and Research Mumbai 10 Indian Institute of Foreign Trade Delhi 11 Narsee Monjee Institute of Management Studies Mumbai 12 International Management Institute New Delhi 13 Faculty of Management Studies Delhi 14 Institute of Management Technology Ghaziabad 15 Jamnalal Bajaj Institute of Management Studies Mumbai 16 Xavier Institute of Management Bhubaneshwar 17 T.A. Pai Management Institute Manipal 18 Xavier Institute of Management & Entrepreneurship Bangalore 19 Fore School of Management New Delhi 20 Loyola Institute of Business Administration Chennai 21 Vinod Gupta School of Management IIT Kharagpur 22 Symbiosis Centre for Management and HRD Pune 23 NITIE Mumbai 24 Nirma Institute of Management Ahmedabad 25 K.J. Somaiya Institute of Management Studies and Research Mumbai 26 Department of Management Studies, REC Trichy 27 Department of Business Administration Aligarh 28 L.B. Shastri Institute of Management New Delhi 29 Symbiosis Institute of Business Management Pune 30 IILM New Delhi 31 ICFAI Business School Hyderabad 32 Goa Institute of Management Goa 33 Department of Management Studies, University of Madras Chennai 34 Indian Institute of Social Welfare and Business Management Kolkata 35 Vignana Jyothi Institute of Management Secunderabad 36 Graduate School of Business and Administration Ghaziabad 37 Prestige Institute of Management and Research Indore 38 ITUC School of Management Hyderabad 39 Institute of Productivity and Management Ghaziabad 40 School of Management Pondicherry 41 Institute of Management Development & Research Pune 42 Jaipuria Institute of Management Lucknow 43 BPHE's Institute of Management Studies, Career Devt & Research Ahmednagar 44 M.S. Patel Institute of Management Studies Baroda 45 Department of Business Administration, Vellore Engineering College Vellore 46 BK School of Business of Management Ahmedabad 47 Institute of Management in Kerala Thiruvananthapuram 48 School of Communication & Management Studies Cochin 49 Punjab School of Management Studies, Punjab University Patiala 50 Department of Business Administration Guwahati 51 SDM Institute for Management Development Mysore 52 Pt. Jawaharlal Nehru Institute of Business Management Ujjain 53 Badruka College Hyderabad 54 G.H. Patel PG Institute of Business Management Vallabh Vidya Nagar 55 Institute of Management Studies, Devi Ahilya University Indore 56 University Business School Chandigarh 57 IIAM Vizag 58 National Institute of Management Calcutta 59 R.A. Podar Institute of Management Jaipur 60 School of Business Management, Sri Venkateswara University Tirupati 61 Sri Sringeri Sharada Institute of Management New Delhi 62 Christ College Institute of Management Bangalore 63 Vaikunth Mehta National Institute of Cooperative Management Pune 64 IPE Hyderabad 65 Bharathidasan Institute of Management Tiruchirapalli 66 Institute of Technology and Science Ghaziabad 67 University Department of Management Sciences Pune 68 School of Management Studies Hyderabad 69 Bharathiar School of Management and Entrepreneurship Development Coimbatore 70 ITM Mumbai 71 Amity Business School Noida 72 Shiva Shivani Institute of Management Hyderabad 73 Kousali Institute of Management Studies Dharwad 74 Sri Siddhartha Institute of Management Studies Tumkur 75 Rajagiri School of Management, Kalamassery Kerala 76 Abdul Qadir Jeelani Centre for PG Studies Vishakapatnam 77 FMS BHU Varanasi 78 AV College Hyderabad 79 Vasantrao Patil Institute of Management Studies and Research Miraj 80 Institute of Productivity and Management Meerut 81 KLS Institute of Management Education and Research Belgaum 82 L.N. Welingker Mumbai 83 Mt. Carmel Institute of Management Bangalore 84 Amrita Institute of Management Coimbatore 85 EMPI New Delhi 86 Assam Institute of Management Guwahati 87 Xavier's Institute of Social Service Ranchi 88 Department of Business Administration Burdwan 89 Sinhgad Institute of Management Pune 90 Indian Institute of Science and Management Ranchi 91 Indian Institute of Modern Management Pune 92 Pendekanti Institute of Management Hyderabad 93 Ambedkar Institute of Management Studies Vishakapatnam 94 Department of Management Studies, University of Roorkee Roorkee 95 Bharati Vidyapeet's Institute of Management Mumbai 96 Sultan-Ul-Uloom College of Business Administration Hyderabad 97 Dr. Gour Hari Singhania Institute of Management Kanpur 98 Department of Management, Babasaheb Ambedkar Marathwada University Aurangabad 99 N.L. Dalmia Institute of Management Studies and Research Mumbai 100 Jagan Institute of Management Studies Delhi |