Database Questions Pg.80

In: Computers and Technology

Submitted By darkstone
Words 331
Pages 2
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 same values for their attributes at any relation state of a database.
3.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…...

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 Questions Pg.76

...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...

Words: 310 - Pages: 2

Database

...CHAPTER 4 RELATIONAL DATABASES SUGGESTED ANSWERS TO DISCUSSION QUESTIONS 4.1 Contrast the logical and the physical view of data and discuss why separate views are necessary in database applications. Describe which perspective is most useful for each of the following employees: a programmer, a manager, and an internal auditor. How will understanding logical data structures assist you when designing and using database systems?</para></question><question id="ch04ques02" label="4.2"> Databases are possible because of their database management system (DBMS). As shown in Figure 4.2, the DBMS is a software program that sits between the actual data stored in the system and the application programs that use the data. As shown in Figure 4.4, this allows users to separate the way they view the data (called the logical view) from the way the data is actually stored (the physical view). The DBMS interprets the users' requests and retrieves, manipulates, or stores the data as needed. The two distinct views separate the applications from the physical information, providing increased flexibility in applications, improved data security, and ease of use. In a database system, the manager will rarely need to understand or be familiar with the physical view of the data. Nor, in most instances, will the internal auditor and the programmer as most everything they do involves the......

Words: 4830 - Pages: 20

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 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

Hlt 362 Exercise 24 Questions to Be Graded 80

...HLT 362 EXERCISE 24 Questions to be Graded 80 Click Link Below To Buy: http://hwcampus.com/shop/hlt-362-exercise-24-questions-to-be-graded-80/ EXERCISE 24 1. What is the r value listed for the relationship between variables 4 and 9? 2. Describe the correlation r = -0.32** using words. Is this a statistically significant correlation? Provide a rationale for your answer. 3. Calculate the percentage of variance explained for r = 0.53. Is this correlation clinically important? Provide a rationale for your answer. 4. According to Table 2, r = 0.15 is listed as the correlation between which two items? Describe this relationship. What is the effect size for this relationship, and what size sample would be needed to detect this relationship in future studies? 5. Calculate the percentage of variance explained for r = 0.15. Describe the clinical importance of this relationship. 6. Which two variables in Table 2, have the weakest correlation, or r value? Which relationship is the closest to this r value? Provide a rationale for your answer. 7. Is the correlation between LOT-R Total scores and Avoidance-Distraction coping style statistically significant? Is this relationship relevant to practice? Provide rationales for your answers. 8. Is the correlation between variables 9 and 4 significant? Is this correlation relevant to practice? Provide a rationale for your answer. 9. Consider two values, r = 0.08 and r = -0.58. Describe them in......

Words: 325 - Pages: 2

Hlt 362 Exercise 24 Questions to Be Graded 80

...HLT 362 EXERCISE 24 Questions to be Graded 80 Click Link Below To Buy: http://hwcampus.com/shop/hlt-362-exercise-24-questions-to-be-graded-80/ EXERCISE 24 1. What is the r value listed for the relationship between variables 4 and 9? 2. Describe the correlation r = -0.32** using words. Is this a statistically significant correlation? Provide a rationale for your answer. 3. Calculate the percentage of variance explained for r = 0.53. Is this correlation clinically important? Provide a rationale for your answer. 4. According to Table 2, r = 0.15 is listed as the correlation between which two items? Describe this relationship. What is the effect size for this relationship, and what size sample would be needed to detect this relationship in future studies? 5. Calculate the percentage of variance explained for r = 0.15. Describe the clinical importance of this relationship. 6. Which two variables in Table 2, have the weakest correlation, or r value? Which relationship is the closest to this r value? Provide a rationale for your answer. 7. Is the correlation between LOT-R Total scores and Avoidance-Distraction coping style statistically significant? Is this relationship relevant to practice? Provide rationales for your answers. 8. Is the correlation between variables 9 and 4 significant? Is this correlation relevant to practice? Provide a rationale for your answer. 9. Consider two values, r = 0.08 and r = -0.58. Describe them in......

Words: 325 - Pages: 2

80/20 Rule

...Learning Game Project: 80/20 Rule Report Table of Contents I. 80/20 Rule Concept: An Overview…………………………………..……………pg. 1 II. 80/20 Rule Concept: Importance and Implications in Business.....……………….pg. 1 III. Learning Game Description…………………………………….…………………pg. 1 IV. Resources………………………………………………………………………….pg. 2 I. 80/20 Rule Concept: An Overview The 80/20 rule is a well-known, theory that can be broadly applied to many different situations and areas of study. It originates from an observation made by Vilfredo Pareto, an Italian economist who noted that eighty percent of the land in Italy belonged to only twenty percent of the people. The idea, also known as Pareto’s principle, preaches that in anything (situation, process, event, etc.) just a small percentage is truly important while the rest is of little significance. Furthermore, it is crucial to note that the exact proportions or numerical values associated to this ideology are irrelevant. In essence, the premise upon which the principle is based assumes most results or outcomes stem from very few causes. Simply, the majority or best results that can be produced are derived from specific efforts or actions. II. 80/20 Rule Concept: Importance and Implications in Business In the business world, a strategy chosen and implemented by an enterprise is especially important in successfully achieving the outlined goals. Furthermore, the strategy should be one that is built upon a sound understanding of......

Words: 1024 - Pages: 5