www.Vidyarthiplus.com VIDYARTHIPLUS - ANNA UNIVERSITY ONLINE STUDENTS COMMUNITY III SEMESTER - B.E – COMPUTER SCIENCE AND ENGINEERING QUESTION BANK - CS6302 DATABASE MANAGEMENT SYSTEMS UNIT I 1. What are the disadvantages of file processing system? 2. Explain the basic structure of a relational database with an example. 3. What do you mean by weak entity set? 4. Give example for one to one and one to many relationships. 5. What is the need of normalization? 6. Write a note on functional dependencies
Premium Database SQL Relational model
1. Describe the relations that would be produced by the following relational algebra operations a) ПhotelNo(σprice>100(Room)) It will produce a single attribute (hotelNo) giving the number of hotels room prices greater 100. b) σHotel.hotelNo=Room.hotelNo(Hotel X Room) A join produce of hotel and room containing all the attributes of both. c) ПhotelName(Hotel Hotel.hotelNo=Room.hotelNo (σprice>100(Room))) It is a join of hotel and room with the price greater than 100. d) Guest(σdateTo>’1-June-12’(Booking)
Premium Relational model Relation
Mobile Database Systems [ 1 ] Jerri Scott Technical Essay #1 Mobile Database Systems MGT – 5151 Database Systems Management November 7‚ 2010 [ 2 ] Due to the increasing utilization of mobile networks and devices‚ mobile database systems have become a prominent method of data access. Data maintenance becomes a necessity for users who require mobility. Therefore‚ the usage of mobile database systems provides a convenient way of data creation‚ collection and management through mobile
Premium Databases Database Mobile device
Hospital-Based Database System (A Case Study of BIRDEM) Rosina Surovi Khan Department of Computer Science and Engineering Ahsanullah University of Science and Technology (AUST) Dhaka‚ Bangladesh Email: surovi99@yahoo.com Abstract— As technology advances‚ information in different organizations of Bangladesh can no more be maintained manually. There is a growing need for the information to become computerized so that it can be suitably stored. This is where databases come into the picture. Databases are convenient
Premium Relational model SQL Entity-relationship model
Brief Introduction to Database Concepts Andrea Rodr´ ıguez Summer School - Castell´n 2004 o Department of Computer Science University of Concepci´n‚ Chile o http://www.inf.udec.cl/∼andrea andrea@udec.cl 1 Introduction Information and data are different. Information is understood by a person. Data are values stored on a passive medium like a computer disk. The purpose of a database management system (DBMS) is to bridge the gap between information and data - the data stored in memory or on disk
Premium Relational model Unified Modeling Language Entity-relationship model
Research Database Assignment Form Type your answers to the following questions using complete sentences and correct grammar‚ spelling and syntax. Click “Save as” and save the file with your last name and assignment‚ e.g.‚”NR449_Research_Database_Smith” Submit to the Research Database basket in the Dropbox by 11:59 p.m. MT Sunday at the end of Week 5. The guidelines and grading rubric for this assignment may be found in Doc Sharing. Name: Nicole Felix Describe briefly your topic of interest (15
Premium Health care Health care provider
ACSG 552 – 01. Processor Florence Appel Advanced Database Class- Spring 2009. Assignment #01. Friday‚ January 23‚ 2009 Due in class on Thursday‚ Jan. 22. o Chapter 2 ▪ Review Questions‚ pp. 54-55: 2‚ 5‚ 6‚ 9‚ 18‚ 19 ▪ Problems‚ pp. 55-59: 1‚ 2; 12-15; 19-21; 22; 25abcde Chapter 02: Review Questions: pp. 54-55. #02) What is a business rule‚ and what is its purpose in data modeling? The business rule is a brief‚ precise and ambiguous
Premium Relational model Database Relational database
Concurrency Control in Database Systems Key Points The purpose of concurrency control is to ensure that one user’s work does not inappropriately influence another user’s work. In some cases‚ these measures ensure that a user gets the same result when processing with other users as that person would have received if processing alone. In other cases‚ it means that the user’s work is influenced by other users but in an anticipated way. When many transactions take place at the same time‚ they are
Premium
Overview of Database Concepts TRUE/FALSE 1. A database is a physical storage device for data. ANS: F PTS: 1 REF: 2 2. A field is a basic unit of data also referred to as a record. ANS: F PTS: 1 REF: 3 3. A character is a basic unit of data and can consist of a number‚ letter‚ or special symbol. ANS: T PTS: 1 REF: 3 4. A collection of fields is a file. ANS: F PTS: 1 REF: 3 5. A collection of records is a file. ANS: T PTS: 1 REF: 3 6. A field in the logical design of a database corresponds
Premium Database normalization SQL Data modeling
Database Concepts Terminology In general‚ there are many acronyms and a lot of terminology used throughout the entire Information Technology (IT) field that is not used anywhere else. In this paper‚ I will briefly describe the following five terms: Online Analytical Processing (OLAP)‚ Data warehouse‚ data mart‚ three-tier architecture‚ and Active Server Pages. Online Analytical Processing OLAP "On-Line Analytical Processing - A category of applications and technologies for collecting‚ managing
Premium World Wide Web Web server