26th April 2016 10:45 AM | |
Shaleen | Re: Mumbai University Database The University of Mumbai is one of the first three state universities of India and the oldest in Maharashtra The University of Mumbai offers Bachelors, Masters and Doctoral courses apart from diplomas and certificates in many disciplines As you are asking about the syllabus of Database Management System from University of Mumbai please have a look on the below given information 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 Relational database model: Logical view of data, keys, integrity rules. Relational Database design: features of good relational database design, atomic domain and Normalization (1NF, 2NF, 3NF, BCNF). 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. Calculus: Tuple relational calculus, Domain relational Calculus, calculus vs algebra, Computational capabilities. Unit- V Constraints, Views and SQL What is constraints, types of constrains, Integrity constraints, Views: Introduction to views, data independence, security, updates on views, Comparison between tables and views SQL: data definition, aggregate function, Null Values, nested sub queries, Joined Relations. Triggers Unit-VI Transaction management and Concurrency Transaction management: ACID properties, serializability and concurrency control, Lock based concurrency control (2PL, Deadlocks),Time stamping methods, Optimistic methods, database recovery management. Practicals 1) Design a Database and create required tables. For e.g. Bank, College Database 2) Apply the constraints like Primary Key , Foreign key, NOT NULL to the tables. 3) Write a sequential statement for implementing ALTER,UPDATE and DELETE 4) Write the queries to implement the joins 5) Write the query for implementing the following functions: MAX(),MIN(),AVG(),COUNT() 6) Write the query to implement the concept of Intergrity constrains 7) Write the query to create the views 8) Perform the queries for triggers 9) Perform the following operation for demonstrating the insertion, updating and Deletion using the referential integrity constraints 10) Write the query for creating the users and their role. For more detail about the syllabus please have a look on the below given PDF Contact Detail 121, Mahatma Gandhi Rd, Kala Ghoda Mumbai, Maharashtra 400001 [MAP]121, Mahatma Gandhi Rd, Kala Ghoda Mumbai, Maharashtra 400001[/MAP] |
26th April 2016 10:43 AM | |
Unregistered | Mumbai University Database Hello sir this is karan and I am looking for the syllabus of Database Management System from University of Mumbai please can you help me in this case |