#1
| |||
| |||
UPTU DBMS Question Paper |
#2
| |||
| |||
Re: UPTU DBMS Question Paper
Dr. A.P.J. Abdul Kalam Technical University, Lucknow formerly Uttar Pradesh Technical University is a public university in the Indian state of Uttar Pradesh set up by the government of Uttar Pradesh on 8 May 2000 As per your request below I am providing you the UPTU DBMS Question Paper: DBMS Syllabus: UNIT I INTRODUCTION AND CONCEPTUAL MODELING: Introduction to File and Database systems- Database system structure Data Models Introduction to Network and Hierarchical Models ER model Relational Model Relational Algebra and Calculus. UNIT II RELATIONAL MODEL: SQL Data definition- Queries in SQL- Updates- Views Integrity and Security Relational Database design Functional dependencies and Normalization for Relational Databases (up to BCNF). UNIT III DATA STORAGE AND QUERY PROCESSING: Record storage and Primary file organization- Secondary storage Devices- Operations on Files- Heap File- Sorted Files- Hashing Techniques Index Structure for files Different types of Indexes- B-Tree - B+Tree Query Processing. UNIT IV TRANSACTION MANAGEMENT: Transaction Processing Introduction- Need for Concurrency control- Desirable properties of Transaction- Schedule and Recoverability- Serializability and Schedules Concurrency Control Types of Locks- Two Phases locking- Deadlock- Time stamp based concurrency control Recovery Techniques Concepts- Immediate Update- Deferred Update - Shadow Paging. UNIT V CURRENT TRENDS: Object Oriented Databases Need for Complex Data types- OO data Model- Nested relations- Complex Types- Inheritance Reference Types - Distributed databases- Homogenous and Heterogenous- Distributed data Storage XML Structure of XML- Data- XML Document- Schema- Querying and Transformation. Data Mining and Data Warehousing Contact: Dr. A.P.J. Abdul Kalam Technical University IET Campus, Sitapur Road Lucknow, Uttar Pradesh 226021 Phone: 0522 273 2193 |
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
UPTU MBA question paper | mamta | Online MBA Discussions | 2 | 7th March 2018 01:36 PM |
Fluid Mechanics Question Paper UPTU | Unregistered | Main Forum | 1 | 2nd June 2017 11:55 AM |
Wireless Communication UPTU Question Paper | Unregistered | Main Forum | 1 | 9th May 2017 09:34 AM |
UPTU Hydrology Paper | Unregistered | Main Forum | 1 | 14th November 2016 05:39 PM |
UPTU Microprocessor Question Paper | Unregistered | Main Forum | 1 | 10th November 2016 06:56 PM |
UPTU Paper Pattern | Unregistered | Main Forum | 1 | 9th November 2016 09:32 AM |
Hindustan Paper Corporation Limited Sample Question Paper | Unregistered | Main Forum | 1 | 4th November 2016 11:33 AM |
UPTU Sample Paper | Unregistered | Main Forum | 1 | 3rd November 2016 08:46 AM |
UPTU Cyber Security Question Paper | Unregistered | Main Forum | 1 | 1st November 2016 05:10 PM |
UPTU CCP Question Paper | Unregistered | Main Forum | 1 | 26th October 2016 01:35 PM |
UPTU Paper 1 | Unregistered | Main Forum | 1 | 15th October 2016 06:32 PM |
Fluid Machinery Question Paper UPTU | Unregistered | Main Forum | 1 | 15th October 2016 12:09 PM |
Industrial Psychology UPTU Paper | Unregistered | Main Forum | 1 | 13th October 2016 04:49 PM |
UPTU Model Paper | Unregistered | Main Forum | 1 | 29th September 2016 05:00 PM |
DBMS University Question Paper with Answers | Unregistered | Main Forum | 0 | 17th July 2015 10:12 AM |
UPTU previous year question paper | arun15marn | Main Forum | 1 | 9th November 2012 04:58 PM |
UPTU SEE Paper Pattern | lingashival | Main Forum | 1 | 3rd November 2012 06:55 PM |
UPTU Question Paper Solution | dipjyoti456 | Main Forum | 1 | 16th October 2012 02:29 PM |
UPTU Paper Code | bp.bhanu | Main Forum | 1 | 25th July 2012 12:57 PM |
EAMCET Question Paper Previous Question Paper | revhanuk_bram | Main Forum | 1 | 24th July 2012 01:41 PM |
|