Database Questions Pg.76

In: Computers and Technology

Submitted By shoojon
Words 310
Pages 2
Homework Review Questions

1 Define the following terms as they apply to the relational model of data: Domain – Set of atomic (indivisible) values. Attribute – it describes a component of the database, such as a table or a field. N-tuple – in mathematics, an ordered set of n elements called its components or coordinates. Relation Schema – It is representation of database highlighting relationships that we have created. Relation State – set of tuples that have the same attributes. Degree of a relation – number of attributes n of its relation schema. Relational Database Schema – Tables, columns and relationships that make up a relational database. Relational database state – is a union of all the individual relation states, whenever the database is changed a new state arise.
2 Why are tuples in a relation not ordered? - A Relation is defined as a set of tuples. Mathematically, elements of a set have no order among them: tuples in a relation do not have any particular order. In other words, a relation is not sensitive to the ordering of tuples. Tuple ordering is not part of a relation definition because a relation attempts to represent facts at a logical or abstract level. 3 Why are duplicate tuples not allowed in a relation? - Duplicate tuples are not allowed in a relation because it violates the specifications of the relational integrity constraints, particularly the key constraint which states that no two tuples can have the same values for their attributes at any relation state of a database. 4 What is the difference between a key and a superkey? - Superkey is any subset of attributes that uniquely identifies the tuples of a relation. This subset need not be minimal, that is, one can remove some attributes from it and it is still uniquely identifying. If all redundant attributes are removed you get a subset what is called primary…...

Similar Documents

Database Questions Pg.80

...Alex Swan Mr. Davis 9/18/12 Homework Review Questions 3.1 Define the following terms as they apply to the relational model of data: Domain – Set of atomic (indivisible) values. Attribute – it describes a component of the database, such as a table or a field. N-tuple – in mathematics, an ordered set of n elements called its components or coordinates. Relation Schema – It is representation of database highlighting relationships that we have created. Relation State – set of tuples that have the same attributes. Degree of a relation – number of attributes n of its relation schema. Relational Database Schema – Tables, columns and relationships that make up a relational database. Relational database state – is a union of all the individual relation states, whenever the database is changed a new state arise. 3.2 Why are tuples in a relation not ordered? - A Relation is defined as a set of tuples. Mathematically, elements of a set have no order among them: tuples in a relation do not have any particular order. In other words, a relation is not sensitive to the ordering of tuples. Tuple ordering is not part of a relation definition because a relation attempts to represent facts at a logical or abstract level. 3.3 Why are duplicate tuples not allowed in a relation? - Duplicate tuples are not allowed in a relation because it violates the specifications of the relational integrity constraints, particularly the key constraint which states that no two tuples...

Words: 943 - Pages: 4

Database

...DSS 630 Database Management Systems Theory and Practice COURSE EXPECTATION FORM Course Description: The implementation of technology such as bar codes and scanners enable organizations to accumulate large volumes of data. Further, as the technology to collect data gets cheaper and more simplified, business organizations gather and process a huge amount of data and information. Thus, data management has become a key function for many organizations. Managers need high-quality information to manage change in a turbulent, global environment. Business organizations use information systems to store and retrieve data, the raw material in knowledge-based economies. This repository of data is organizational memory. Databases are an important component of the organizational memory. Thus, information systems professionals should develop a comprehensive understanding of data management principles to fully utilize the organizational role of information technology. This course provides core skills of data management for the relational database management systems. This course will review the theoretical concepts and applications of a modern relational database management system. In addition to a basic theoretical presentation of the database design concepts, students will be required to design and develop a database application using a modern fourth generation language system. This course teaches students data modeling and......

Words: 1374 - Pages: 6

Database

...Client/Server is a system. It is not just hardware or software. It is not necessarily a program that comes in a box to be installed onto your computer’s hard drive. Client/Server is a conglomeration of computer equipment, infrastructure, and software programs working together to accomplish computing tasks which enable their users to be more efficient and productive. Client/Server applications can be distinguished by the nature of the service or type of solutions they provide. Client/Server Computing is new technology that yields solutions to many data management problems faced by modern organizations. Client/Server Computing: An Introduction, features objective evaluations and details of Client/Server development tools, used operating system, database management system and its mechanism in respect of Client/Server computing and network components used in order to build effective Client/Server applications. vi Preface Last but not the least, this work is primarily a joint work with a number of fellow teacher who have worked with us. My parents, wife Meera, and our children, Akanksha and Harsh. I am particularly grateful to Dr. A. P. Singh, Principal, Udai Pratap Inter College, Varanasi; Dr. D. S. Yadav, Sr. Lecturer, Department of Computer Science and Engineering, IET, Lucknow; Dr. A. K. Naiyak, Director IIBM, Patna, former President of IT and Computer Science Section of Indian Science Congress Association; Prof. A. K. Agrawal, Professor and Ex-Head of Department,......

Words: 79055 - Pages: 317

Database Questions Pg.80

...Alex Swan Mr. Davis 9/18/12 Homework Review Questions 3.1 Define the following terms as they apply to the relational model of data: Domain – Set of atomic (indivisible) values. Attribute – it describes a component of the database, such as a table or a field. N-tuple – in mathematics, an ordered set of n elements called its components or coordinates. Relation Schema – It is representation of database highlighting relationships that we have created. Relation State – set of tuples that have the same attributes. Degree of a relation – number of attributes n of its relation schema. Relational Database Schema – Tables, columns and relationships that make up a relational database. Relational database state – is a union of all the individual relation states, whenever the database is changed a new state arise. 3.2 Why are tuples in a relation not ordered? - A Relation is defined as a set of tuples. Mathematically, elements of a set have no order among them: tuples in a relation do not have any particular order. In other words, a relation is not sensitive to the ordering of tuples. Tuple ordering is not part of a relation definition because a relation attempts to represent facts at a logical or abstract level. 3.3 Why are duplicate tuples not allowed in a relation? - Duplicate tuples are not allowed in a relation because it violates the specifications of the relational integrity constraints, particularly the key constraint which states that no two tuples can have the......

Words: 331 - Pages: 2

Database

... FUNDAMENTALS OF Database Systems SIXTH EDITION This page intentionally left blank FUNDAMENTALS OF Database Systems SIXTH EDITION Ramez Elmasri Department of Computer Science and Engineering The University of Texas at Arlington Shamkant B. Navathe College of Computing Georgia Institute of Technology Addison-Wesley Boston Columbus Indianapolis New York San Francisco Upper Saddle River Amsterdam Cape Town Dubai London Madrid Milan Munich Paris Montreal Toronto Delhi Mexico City Sao Paulo Sydney Hong Kong Seoul Singapore Taipei Tokyo Editor in Chief: Acquisitions Editor: Editorial Assistant: Managing Editor: Senior Production Project Manager: Media Producer: Director of Marketing: Marketing Coordinator: Senior Manufacturing Buyer: Senior Media Buyer: Text Designer: Cover Designer: Cover Image: Full Service Vendor: Copyeditor: Proofreader: Indexer: Printer/Binder: Cover Printer: Michael Hirsch Matt Goldstein Chelsea Bell Jeffrey Holcomb Marilyn Lloyd Katelyn Boller Margaret Waples Kathryn Ferranti Alan Fischer Ginny Michaud Sandra Rigney and Gillian Hall Elena Sidorova Lou Gibbs/Getty Images Gillian Hall, The Aardvark Group Rebecca Greenberg Holly McLean-Aldis Jack Lewis Courier, Westford Lehigh-Phoenix Color/Hagerstown Credits and acknowledgments borrowed from other sources and reproduced with permission in this textbook appear on appropriate page within text. The interior of this book was set in Minion and Akzidenz Grotesk. Copyright © 2011,......

Words: 181574 - Pages: 727

Databases

...Why Normalization Failed to Become the Ultimate Guide for Database Designers? Marin Fotache Alexandru Ioan Cuza University of Iasi, Romania Faculty of Economics and Business Administration Dept. of Business Information Systems Blvd. Carol I, nr. 22, Iasi, 700505, Romania Tel: + 40 744 497 654, Fax: + 40 232 217 000 fotache@uaic.ro ABSTRACT With an impressive theoretical foundation, normalization was supposed to bring rigor and relevance into such a slippery domain as database design is. Almost every database textbook treats normalization in a certain extent, usually suggesting that the topic is so clear and consolidated that it does not deserve deeper discussions. But the reality is completely different. After more than three decades, normalization not only has lost much of its interest in the research papers, but also is still looking for practitioners to apply it effectively. Despite the vast amount of database literature, comprehensive books illustrating the application of normalization to effective real-world applications are still waited. This paper reflects the point of 1 view of an Information Systems academic who incidentally has been for almost twenty years a practitioner in developing database applications. It outlines the main weaknesses of normalization and offers some explanations about the failure of a generous framework in becoming the so much needed universal guide for database designers. Practitioners might be interested in finding out (or......

Words: 12110 - Pages: 49

Cis 106 Chapter 2 Relational Databases and Queries Multiple Choice Questions

...CIS 106 Chapter 2 Relational Databases and Queries Multiple Choice Questions http://homeworktimes.com/downloads/cis-106-chapter-2-relational-databases-queries-multiple-choice-questions/ 1.) When entering, deleting, or editing table data: A.) The table must be in Design View B.) The table must be in Datasheet View C.) The table may be in either Datasheet or Design View D.) Data may be entered only in a form 2.) Which of the following is true for the Query Wizard? A.) You can only select tables as a source B.) No criteria can be added C.) Fields from multiple tables are not allowed D.) You do not need a summary 3.) Which of the following was not a suggested guideline for designing a table? A.) Include all necessary data B.) Store data in its smallest parts C.) Avoid calculated fields D.) Link tables using common fields 4.) A query’s specifications providing instructions about which records to include must be entered: A.) On the Show row of the query design grid B.) On the Sort row of the query design grid C.) On the Criteria row of the query design grid D.) On the Table row of the query design grid 5.) An illustration of a one-to-many relationship would be: A.) A person changes his/her primary address B.) A customer may have multiple orders C.) A branch location has an internal branch ID code D.) A balance field is totaled for all accounts for each person 6.) When adding criteria to the query design view: A.) The value you...

Words: 403 - Pages: 2

Cis 106 Chapter 2 Relational Databases and Queries Multiple Choice Questions

...CIS 106 Chapter 2 Relational Databases and Queries Multiple Choice Questions http://homeworktimes.com/downloads/cis-106-chapter-2-relational-databases-queries-multiple-choice-questions/ 1.) When entering, deleting, or editing table data: A.) The table must be in Design View B.) The table must be in Datasheet View C.) The table may be in either Datasheet or Design View D.) Data may be entered only in a form 2.) Which of the following is true for the Query Wizard? A.) You can only select tables as a source B.) No criteria can be added C.) Fields from multiple tables are not allowed D.) You do not need a summary 3.) Which of the following was not a suggested guideline for designing a table? A.) Include all necessary data B.) Store data in its smallest parts C.) Avoid calculated fields D.) Link tables using common fields 4.) A query’s specifications providing instructions about which records to include must be entered: A.) On the Show row of the query design grid B.) On the Sort row of the query design grid C.) On the Criteria row of the query design grid D.) On the Table row of the query design grid 5.) An illustration of a one-to-many relationship would be: A.) A person changes his/her primary address B.) A customer may have multiple orders C.) A branch location has an internal branch ID code D.) A balance field is totaled for all accounts for each person 6.) When adding criteria to the query design view: A.) The value you...

Words: 403 - Pages: 2

Cis 106 Chapter 2 Relational Databases and Queries Multiple Choice Questions

...CIS 106 Chapter 2 Relational Databases and Queries Multiple Choice Questions http://homeworktimes.com/downloads/cis-106-chapter-2-relational-databases-queries-multiple-choice-questions/ 1.) When entering, deleting, or editing table data: A.) The table must be in Design View B.) The table must be in Datasheet View C.) The table may be in either Datasheet or Design View D.) Data may be entered only in a form 2.) Which of the following is true for the Query Wizard? A.) You can only select tables as a source B.) No criteria can be added C.) Fields from multiple tables are not allowed D.) You do not need a summary 3.) Which of the following was not a suggested guideline for designing a table? A.) Include all necessary data B.) Store data in its smallest parts C.) Avoid calculated fields D.) Link tables using common fields 4.) A query’s specifications providing instructions about which records to include must be entered: A.) On the Show row of the query design grid B.) On the Sort row of the query design grid C.) On the Criteria row of the query design grid D.) On the Table row of the query design grid 5.) An illustration of a one-to-many relationship would be: A.) A person changes his/her primary address B.) A customer may have multiple orders C.) A branch location has an internal branch ID code D.) A balance field is totaled for all accounts for each person 6.) When adding criteria to the query design view: A.) The value you...

Words: 403 - Pages: 2

Database Revision Questions for Computer Science and Technology

...Review Questions 24 I Chapter 1 Databases and Database Users 1.1. Define the following terms: data, database, DBMS, database system, database catalog, Program-data independence, user view, DBA, end user, canned transaction, deductive Database system, persistent object, meta-data, transaction-processing application. 1.2. What three main types of actions involve databases! Briefly discuss each. 1.3. Discuss the main characteristics of the database approach and how it differs from traditional file systems. 1.4. What are the responsibilities of the DBA and the database designers? 1.5. What are the different types of database end users? Discuss the main activities of each. 1.6. Discuss the capabilities that should be provided by a DBMS. Exercises 1.7. Identify some informal queries and update operations that you would expect to apply to the database shown in Figure 1.2. 1.8. What is the difference between controlled and uncontrolled redundancy? Illustrate with examples. 1.9. Name all the relationships among the records of the database shown in Figure 1.2. 1.10. Give some additional views that may be needed by other user groups for the database Shown in Figure 1.2. 1.11. Cite some examples of integrity constraints that you think should hold on the Database shown in Figure 1.2. Chapter 2 Database System Concepts and Architecture Review Questions 2.1. Define the following terms: data model, database schema, database state, internal Schema, conceptual schema, external schema, data......

Words: 803 - Pages: 4

Database

... FUNDAMENTALS OF Database Systems SIXTH EDITION This page intentionally left blank FUNDAMENTALS OF Database Systems SIXTH EDITION Ramez Elmasri Department of Computer Science and Engineering The University of Texas at Arlington Shamkant B. Navathe College of Computing Georgia Institute of Technology Addison-Wesley Boston Columbus Indianapolis New York San Francisco Upper Saddle River Amsterdam Cape Town Dubai London Madrid Milan Munich Paris Montreal Toronto Delhi Mexico City Sao Paulo Sydney Hong Kong Seoul Singapore Taipei Tokyo Editor in Chief: Acquisitions Editor: Editorial Assistant: Managing Editor: Senior Production Project Manager: Media Producer: Director of Marketing: Marketing Coordinator: Senior Manufacturing Buyer: Senior Media Buyer: Text Designer: Cover Designer: Cover Image: Full Service Vendor: Copyeditor: Proofreader: Indexer: Printer/Binder: Cover Printer: Michael Hirsch Matt Goldstein Chelsea Bell Jeffrey Holcomb Marilyn Lloyd Katelyn Boller Margaret Waples Kathryn Ferranti Alan Fischer Ginny Michaud Sandra Rigney and Gillian Hall Elena Sidorova Lou Gibbs/Getty Images Gillian Hall, The Aardvark Group Rebecca Greenberg Holly McLean-Aldis Jack Lewis Courier, Westford Lehigh-Phoenix Color/Hagerstown Credits and acknowledgments borrowed from other sources and reproduced with permission in this textbook appear on appropriate page within text. The interior of this book was set in Minion and Akzidenz Grotesk. Copyright © 2011,......

Words: 181574 - Pages: 727

Database Questions Pg.80

... Offa, Kwara State, Nigeria. PERSONAL SKILLS: • Software Developer: Writing programming code such as Vb.net, Java and PHP. • Excellent knowledge of computer like Microsoft word, Excel, Access, Database computation and internet. WORK EXPERIENCES: NYSC [2012] National Youth Service Corps. Department of Planning, Research & Statistics, Ministry of Information: Uyo, Akwa-Ibom State, Nigeria.  Job Responsibilities: Research, evaluate and recommend new                       technologies for service delivery and improvement.                        Also Design, develop, program, install, implement, conduct research                       and maintain internal data processing computer systems and assist in                       training less experienced staff. INEC [2011] Independent National Electoral Commission:                    Job Responsibilities: Aggregation of Data and Running of Automatic Fingerprint Identification System (AFIS) in 2011 Voters’ Registration Exercise. SIWES [2009] Students Industrial Work Experience Scheme.    Topstock Computer Technology: Offa, Kwara State, Nigeria. Job Responsibilities: Maintaining applications and database by evaluating client needs, analyzing requirements and developing application software. AWARDS OF EXCELLENCE: INEC [2011] Independent National Electoral Commission: Letter of Commendation ...

Words: 480 - Pages: 2

Database Questions Pg.80

...This document has been removed....

Words: 480 - Pages: 2

Database Design Chapter 1 Review Questions

...organize data in a database. Its functions are data dictionary management, data storage management, data transformation and presentation. 5. Structural independence exists when you can change the file structure without affecting the application's ability to access the data. If it did not exist, any change to a files structure would require several extra steps for every single record in the file. 6. Data is raw facts that have not been processed. Information is data that has been processed and given context. Databases help to organize the manipulation of data to create information by providing an organizational structure that makes relationships and connections between data explicit. 7. The DBMS serves as the intermediary between the user and the database. Some advantages are improved data sharing, data security, data access, decision making, and increased end-user productivity. Disadvantages are increased costs, management complexity, maintaining currency, vendor dependence, and frequent upgrade cycles. 8. The databases are single user database, desktop database, multiuser database, workgroup database, enterprise database, centralized database, distributed database, operational/transactional/production database, and data warehouse. 9. The main components are hardware, software, people, procedure, and data. 10. Metadata is data about data, through which the end user data is integrated and managed. 11. A poorly or incorrectly designed database can......

Words: 480 - Pages: 2

Database Desighn Chaper 11 Review Questions

...Chapter 11 Review Questions 1. It is a process that is done locally on a client. The performance tuning will send a query to the server and come back with an answer in a certain amount of time with the little resources being used on the server side. 2. This process is being done on the server with the DBMS. The best way to this is to see how long a response takes from a client machine to the DBMS. The faster the response the better. 3. Performance tuning would mostly be focusing on input/output (I/O). Measuring the performance of how fast data is moved through the disks on the server. You don’t want the server to always use I/O instead they are going to want the data cashed because it doesn’t have to search the disks to retrieve the data. 4. Database statistics are measurements from the DBMS. They usually look at tables, columns and indexes that are being used. By measuring those that can see the performance of the system and make critical decisions to make the system better. 5. There are many different programs out there that can measure database statistics. Some commands that are built in the system to obtain the stats are to use to ANALYZE command. 6. Most measurement that are typical are the number of disk blocks being utilized, also the number of rows and how long the length of the rows are. Also including the smallest value within each column, including column that also are utilizing indexes. 7. They are two different command......

Words: 761 - Pages: 4