This website uses cookies to ensure you have the best experience. Learn more

Ist 210 Chapter 6 Help Guide

1201 words - 5 pages

Section 1: True/False Questions (each question has 1.5 pt)
Please circle the correct answer:
1. The ER diagram represents the conceptual database as viewed by the end user.

True False

2. Attributes do not have a domain.

True False

3. Ideally, a primary key is composed of several attributes.

True False

4. Connectivities and cardinalities are established by business rules.

True False

5. Relationship participation is not very important when designing a database.

True False

6. In order to meet performance requirements, you may have to Denormalize portions of the database design.

True False

7. Because a partial dependency can ...view middle of the document...

a. maximum
b. minimum
c. exact
d. maximum and minimum

5. A ____ key is a key that consists of more than one attribute.
a. primary
b. foreign
c. composite
d. domain

6. A ____ attribute need not be physically stored within the database.
a. composite
b. multivalued
c. single-valued
d. derived

7. If an entity can exist apart from one or more related entities, it is said to be ____-independent.
a. existence
b. relationship
c. business
d. weak

8. A ____ relationship exists when three entities are associated.
a. unary
b. binary
c. ternary
d. weak

9. Attributes may share a:
a. name
b. domain
c. location
d. table

10. Which of the following might be represented with a single-valued attribute?
a. Person’s phone number(s)
b. Car’s color
c. Employee’s educational background
d. Computer’s processor speed

11. Making sure all ____ are identified is the most important part of a database designer’s job.
a. business rules
b. cardinalities
c. derived attributes
d. relationships

12. A table that displays data redundancies yields ____.
a. inconsistencies
b. anomalies
c. fewer attributes
d. more entities

13. Which of the following should not be placed in a relational table?
a. Entity
b. Attribute
c. Relationship
d. Repeating group

14. In BCNF, every ____ in a table is a candidate key.
a. determinant
b. entity
c. primary key
d. atomic attribute

15. Which of the following is not an example of denormalization?
a. converting a 3NF to 2NF
b. converting a 2NF to 1NF
c. converting a 3NF to 1NF
d. converting a 3NF to BCNF

16. Given the table EMP_PROJ (PROJ_NUM, EMP_NUM, PROJ_NAME, EMP_NAME, JOB_CLASS, CHG_HOURS, HOURS), which of the following is a partial dependency?
a. PROJ_NUM ( PROJ_NAME
b. JOB_CLASS ( CHG_HOUR
c. PROJ_NUM, EMP_NUM ( HOURS
d. PROJ_NUM, EMP_NUM ( CHG_HOURS

17. A relation is not in 1NF if:
a. it has multiple candidate keys
b. all of the key attributes are defined
c. there are repeating groups in the table
d. all attributes are dependent on the primary key

18. For most business transactional databases, we should normalize relations into:
a. 1NF
b. 2NF
c. 3NF
d. 6NF

19. A ____ entity has a primary key that is partially derived from the parent entity in the relationship.
a. Strong
b. weak
c. business
d. relationship

20. The SQL command that lets you list the table contents is ____.
a. INSERT
b. SELECT
c. COMMIT
d. UPDATE

21. The ____ command is used to modify the table by deleting a column.
a. DROP
b. ALTER
c. DELETE
d. ERASE

22. The basic SQL aggregate function that gives the total...

Other Papers Like Ist 210 Chapter 6 Help Guide

Fedexx Essay

653 words - 3 pages ). Item 6. Selected Financial Data. Furnish the information required by Item 301 of Regulation S-K (§ 229.301 of this chapter). Item 7. Management’s Discussion and Analysis of Financial Condition and Results of Operations. Furnish the information required by Item 303 of Regulation S-K (§ 229.303 of this chapter). Item 8. Financial Statements and Supplementary Data. (a) Furnish financial statements meeting the requirements of Regulation S

No Choice Essay

928 words - 4 pages DIF: Average REF: Learn more about this question in Economics Principles and Practices, pages 6-7, and in the Reading Essentials and Study Guide, Chapter 1, Section 1.  For additional practice, complete Chapter 1, Section 1, of the Interactive Tutor Self-Assessment CD-ROM, and visit this book's Online Learning Center at epp.glencoe.com. NOT: Pages 6-7 2. ANS: A PTS: 1 DIF: Easy REF: Learn more about this question in Economics Principles and

Marketing

644 words - 3 pages environment will affect the attractiveness of a potential foreign market, how to describe the major tariff blocs and so on. Chapter 7, which is socio-cultural, taught me how the socio-cultural environment might affect the attractiveness of a potential market. Noticing that chapter 6 and 7 help for my colleagues to do competitor analysis and segmentation analysis, I recommended these chapters to them and shared my knowledge with them. By reading the

Milk as Glue

1846 words - 8 pages Chapter I: Introduction A.            Background of the Study The scientific name of glue is “Cyanoacrylates”. Glue is the chief topic in this investigatory project. Glue is widely used worldwide. From schools to offices, from homes to buildings, glue is always present to help in individuals in their daily lives. This material can be used in simple works or as an emergency utensil; from torn books to stripped parts of paper works; this tool is

Busn 278 Homework Es

1126 words - 5 pages . | Question : | (TCO 1) The type of budget that allows for adjustments to unpredictable changes is called a: | |   | Student Answer: | |  static budget |   | | |  flexible budget |   | | |  continuous budget |   | | |  master budget |   | Instructor Explanation: | Chapter 1, Page 6 | | |   | Points Received: | 4 of 4 |   | Comments: | | | |  2. | Question : | (TCO 2) Using the table “Paint Sales Time

Bible 104, Theology, Apologetics

772 words - 4 pages BIBL-104 Study Guide Week 2 STUDY GUIDE: MODULE 2 As you read this week’s textbook reading assignments, take notes in response to these questions and statements. This study guide will help you to prepare for your quiz. Harbin. Chapter 2 1. What is the term toledot, and why is it important? Toledot- translated to mean "generations" or an “account”. It explains the accounts of creations & generations. 2. What is the

Ap Literature

663 words - 3 pages . Symbols show what the text cannot and they help guide you to a more complete understanding of the literature. * The recognition of patterns help make it easier to read complicated literature because they help recognize the relationships between ideas. In advanced literature all of the ideas are mixed in a more complex way so if you are used to looking for patterns while reading it will help ease the complexity * While reading this book

Recruitment

627 words - 3 pages ) ACKNOWLEDGEMENT I express my sincere gratitude to my industry guide Mr./Ms.________________, (Designation)________________, (Company) _________________, for his/her able guidance, continuous support and cooperation throughout my project, without which the present work would not have been possible. I would also like to thank the entire team of _____________________________, for the constant support and help in the successful completion of

Content and Structure Report and Defense

926 words - 4 pages . To use in chapter 3 and 4. 3) To find theoretical models to use in chapter 3, 4 and 5. 4) To find information and models to give better policy recommendations in chapter 6. 5) Sometimes to find a research model for chapter 1; then they look back). Ch3: Results/ answers on research question chapter 1.5. Findings are well-described (Application of generally accepted theories and frameworks), detailed and flow easily. Visual

Mba 6301 Business Ethics

3592 words - 15 pages -Graded): See Study Guide  Chapter 4: Ethics and Financial Reporting  Chapter 6: Strategic Planning, Corporate Culture, and Corporate Compliance  Supplemental Reading: See Study Guide  Suggested Further Reading: See Study Guide  Assessment MBA 6301, Business Ethics 8 MBA 6301, Business Ethics Unit VII Review: Read: Submit: Course Schedule Developing and Evaluating a Strong Ethical Focus

Digital Learning and Academic Performance of Intermediate Pupils

3267 words - 14 pages that they always encounter and utilize from day to day. This study may promote modern way of learning that can widen the pupil’s knowledge. This can also be their guide in boosting their confidence level and their attitude towards learning. Parents. The results of this study help the parents to know how they will become or had been a contributing factor in the effects of digital learning to their children, be it positive or negative. It may

Related Essays

Kommunikation Im Bewerbungsgespräch Essay

1436 words - 6 pages größter Erfolg?“ o „Was war bisher Ihr bestes Erlebnis in Ihrem Leben?“6 Grundlage einer guten Antwort ist hier die umfangreiche Selbstanalyse. Persönliche Stärken können dabei sein, Belastbarkeit, Sorgfalt, Kommunikationsfähigkeiten, Teamfähigkeit oder das Verhandlungsgeschick. Auch berufliche Spezialisierungen in Marketing, Vertrieb, Informatik oder Rechnungswesen dürfen durchaus als persönliche Stärken ausgelegt werden. Inhalt der Antwort: Die

Cognitive Methods Essay

513 words - 3 pages Klauer, Karl C., Voss, Andreas, Stahl, Christopher (2011). Cognitive Methods in Social Psychology, Inferring Latent Processes After reading the article, in my opinion this is an analysis of a professional issue? This article is basically a guide line of information for researchers and students, who have issues with understanding the cognitive process, how these methods interfere or contribute with our daily lives. The main purpose of this

Macro Management Essay

4663 words - 19 pages measurement of national income and measurement of inflation, apart from different models of output | |and income determination and related concepts. | |6 |National Income: Introduction |Text Book, Chapter 3 | |7 |National Income aggregates, Measurement of National

Two Million Dollar Procurement For The Purchase Of Vehicles For The Fleet Of Trucks

684 words - 3 pages trucks and cars for DHS).  2. Evaluate the pros and cons of sealed bidding contracts and negotiated contracts, emphasizing which one would be best for this purchase. (Dr. Vic’s Tips, p.p. 53-66 of our Compton text covers both sealed bidding and the negotiation process in depth, please use information from this source as well as Chapter 14 of Feldman. For sealed bidding Pros you can certainly discuss their common uses, p.p. 209-210, Feldman