It203 – Final Exam Review

In: Computers and Technology

Submitted By Blagevil
Words 1035
Pages 5
IT203 – Final Exam Review

1. Redundancy refers to what database condition?

The same data is recorded in more than one place in the same database.

You have more than one database devoted to the same thing.

2. Which statement best describes the function of a primary key?

It uniquely identifies each record.

3. Which statement best describes the function of a foreign key?

A foreign key is the primary key of one table repeated in another table in order to create a relationship between the tables.

4. What is SQL?

It is the language relational databases use to create database objects and to manipulate and retrieve data.

5. A database entity can best be described as _____________.

something the database is concerned with about for which data can be stored

6. Which of the following best defines the term “database requirement”?

Something a database must do to fulfill its business function

7. Which of these best defines “data integrity”?

The accuracy and correctness of the data in the database

8. A document that has the primary purpose of summarizing and displaying data is called a _____.

report

9. The focus of a database, the business problem it is designed to solve, is called _____.

the domain of the database

10. Observing people at work to see how they interact with the data is called _____.

work shadowing

11. An attribute or combination of attributes that could be used as the primary key for an entity is a
___________.

candidate key

12. A key that consists of two or more attributes combined to make a unique value is called a _______.

composite key

13. Which of the following statements is an advantage of a natural key?

A natural key helps protect data integrity by preventing accidental entry of duplicate rows.

14. A natural key is __________.

an attribute that naturally…...

Similar Documents

Final Exam

...Class, there is a final exam study guide in doc sharing. Please be sure to review it in detail! I would also like to provide more information on the final: * The Final Exam covers all the TCOs and all the course materials. * This exam is worth 250 points in total, which includes 12 multiple-choice questions at five points each for a total of 60 points, one essay question at 30 points, four essay questions at 40 points each for a total of 190 points. * You have three hours and 30 minutes to complete this exam. * This exam contains two pages. You don't need to complete them in order. My suggestion is to start with the 5 essay questions (page 2) and then go back to the multiple choice questions leaving about 1 hour for the multiple choice. This allots approximately 30 minutes to each essay (2.5 hours) and 5 minutes to each multiple choice (1.0 hours). Multiple Choice: there is one multiple choice question from each of the following chapters: 1, 2, 3, 4, 5, 6, 8, 9, 12, 14, 16, 17. Essay Question Topics: 30 point question (there is one of these) you will be given 6 transactions, and asked to indicate which fund each transaction would be recorded in. The fund summary document and week 1 & 2 document should be helpful here, as well as the notes you have taken on each fund. Review chapters 2, 4, 5, 6, 7 on what transactions are accounted for in each fund. 40 point essay questions (there are 4 of these) 1. Question covering uses of the......

Words: 350 - Pages: 2

Entrepreneurship Final Exam Review

...the good of the team q. Avoids distractions x. Trust one another xi. We will engage in unfiltered constructive conflict around ideas xii. We will commit to decisions and plans of action xiii. We will hold one another accountable for delivering against those plans xiv. And we will focus on the achievement of collective results r. Angels and VC Firms- Structure, review process, characteristics * Criteria for committing to venture: * Strong management team * Product and/or market opportunity must be sizeable * Technology or other differentiation * Business opportunity must show significant potential for capital appreciation * Stage I: Preliminary screening * Initial evaluation of a deal * Begins with the receipt of company information * Stage II: Agreement on principal terms between entrepreneur and venture capitalist * Stage III: Due diligence * Stage of deal evaluation * Stage IV: Final approval * Document showing the final terms of the deal Channel Selection Cash flow versus net income * Primary methods for determining the worth of a company * Present value of future cash flow: based on projections of its future sales and profits * Multiples and comparables analysis of comparable firms Sequence for preparing a forecast, breakeven analysis and formula Elements of a contract * Four essential items in an agreement to......

Words: 2753 - Pages: 12

It 203 Final Exam Review March 7th, 2013

...record in the secondary or child entity Many-to-many: means the each record in the primary entity can have many related records in a second entity and each record in the second entity can have many related records in the primary entity. 1. Type of entities a. Domain entities: Are entities that related directly to the business of the database (track customer order, inventory) b. Linking entities: Are used to resolve many-to-many relationships into two one-to-many relationships c. Lookup entities: Are essentially utility entities. They store list of data the other tables need to lookup (Names, States Country names or abbreviations) d. Weak entities: Is an entity that is dependent on another entity for its meaning Normalization and Design Review: Deletion Anomalies: Where deleting one piece of data inadvertently causes other data to be lost Normal Forms: Each normal form is a set of rules designed to reduce or eliminate various anomalies First Normal Forms: It removes all repeating groups or arrays (entities are, every attribute represents only one valve, there are no repeating groups or arrays, each row is unique) Third Normal Forms: It refers to removing transient dependencies. Physical Design 1. Choosing DBRS: a. Compatibility with your network and operating systems b. Hardware and software requirements for the DBRS c. Features of the DBRS in relation to your database requirements d. Familiarity and expertise in DBMS for database developers and IT......

Words: 1187 - Pages: 5

Exam Review

...Review Exam 2 1. Planet X has a radius 3 times larger than the earth’s radius. How does this planet’s volume compare to Earth’s volume? a. The volume is 3 times larger than the Earth’s radius. b. The volume is 1/9 the Earth’s radius. c. The volume is 27 times the Earth’s Radius. d. The volume is 1/27 times the Earth’s radius. 2. The moons X and Y orbit 2 different planets. They have the same orbital velocity, but the distance of X from its planet is 2 times the distance of planet Y from its planet. Which planet has more Mass? PLANET X 3. The Earth’s average density is 5.5 kg/L. A planet discovered orbiting another star has an average density of 3.2 kg/L. What does this tell us about this planet? e. The planet must be farther from the star than Earth. f. The planet must have a smaller mass than the Earth, so the mass per Liter is less. g. The planet must be made of a higher proportion of gases and ices than the Earth. h. The planet must have a larger volume than the Earth making the density decrease because matter is more spread out. i. The planet must be terrestrial, with lots of rock and metal. 4. Galaxy Sand and Galaxy Witch are the same distance from Earth, but the angular diameter of Sand is 2X larger. How do the physical diameter’s compare? j. Sand is ½ the diameter of Witch. k. Sand is 2x the diameter of Witch. l. Sand is ¼ the diameter of Witch. m. It cannot be......

Words: 2025 - Pages: 9

Final Exam Review - Mth

...Final Exam Review 1. Topics to study a) Chapter 2 – Fundamentals of Logic b) Chapter 3 – Set Theory c) Chapter 4 – Induction and the Division Algorithm d) Chapter 5 & 7 – Relations and Functions e) Chapter 1 – Combinatorics f) Chapter 8 – Inclusion/Exclusion Principle 2. Chapter 2 – Fundamentals of Logic a) Logical Connectives i) Conjunction ii) Disjunction iii) Negation iv) XOR v) Implication vi) Bi-Direction b) Truth Table construction 8. Construct a truth table for each of the following compound statements, where p, q, r denote primitive statements. Tell whether the given statement is a tautology. a. ¬ (p Ú ¬q) → ¬p p q ¬q ¬p p Ú ¬q ¬ (p Ú ¬q) ¬ (p Ú ¬q) → ¬p 0 0 1 1 1 0 1 0 1 0 1 0 1 1 1 0 1 0 1 0 1 1 1 0 0 1 0 1 The statement is a tautology. b. p → (q → r) p q r q → r p → (q → r) 0 0 0 1 1 0 0 1 1 1 0 1 0 0 1 0 1 1 1 1 1 0 0 1 1 1 0 1 1 1 1 1 0 0 0 1 1 1 1 1 The statement is not a tautology. c. (p → q) → r p q r p → q (p → q) → r 0 0 0 1 0 0 0 1 1 1 0 1 0 1 0 0 1 1 1 1 1 0 0 0 1 1 0 1 0 1 1 1 0 1 0 1 1 1 1 1 The statement is not a tautology. d. (p → q) → (q → p) p q p → q q → p (p → q) → (q → p) 0 0 1 1 1 0 1 1 0 0 1 0 0 1 1 1 1 1 1 1 The statement is not a tautology. e. (p  (p → q)) → q p q p → q p  (p → q) (p  (p → q)) → q 0 0 1 0 1 0 1 1 0 1 1 0 0 0 1 1 1 1 1 1 The statement is a tautology. f. (p  q) → p p q p  q (p  q) →......

Words: 842 - Pages: 4

Exam Review

...Review for Exam 1 Chapters 1-4 Chapter 1 |1. |An information system can be defined as: | |A) |An organized combination of people, hardware, software, communications networks, and database resources. | |B) |As a system that collects, transforms, and disseminates information in an organization. | |C) |Is composed of hardware, software, networks, and data resources. | |D) |All of the above would apply to the definition of an information system. | | |Ans:  D | |2. |In the internetworked E-business enterprise, an extranet refers to: | |A) |A network inside the enterprise. | |B) |A network between an enterprise and its trading partners. | |C) |A local area network within the enterprise. | |D) |A wide area network within the enterprise. ...

Words: 1030 - Pages: 5

Nt1310 Final Exam Review

...NT1310 Final Exam Review 1. What unit of measurement is a tenfold logarithmic ratio of power output to power input Answer: Decibels is a unit of measurement that describes logarithmic ratio 2. What type of tool would be best for add connectors to twisted-pair cable Answer: Crimpers 3. If the tip wire in your pair is white/blue, what color would you expect the ring to be Answer: Blue 4. How many pairs of wires are in a binder group Answer: 25 5. What is added to fiber-optic cabling to provide additional support Answer: Nylon and Aluminum Coatings 6. What layer of the OSI reference model do routers work on Answer: Layer 3 7. What are examples of a makeshift tools Answer: Tennis Ball and Duct Tape 8. What should be included in cabling system documentation Answer: Network Diagrams 9. What is refraction Answer: Is the bending of light as it passes through a medium 10. What was the first full-scale commercial application of fiber-optic communication systems Answer: AT&T installed the first fiber optic cable system in 1977 11. How are optical fibers and copper different Answer: Digital transmission is superior to analog transmission by analog is affected by attenuation and nature 12. How is digital data transmission superior to analog data transmission Answer: It is not affected by attenuation or electrical impulses 13. How does dispersion affect optical fiber Answer: It blurs the signal and......

Words: 751 - Pages: 4

Pols Final Exam Review

...Federal Government Exam 1 Review: The first exam will consist of questions generated from the following review sheet. Make sure you understand each of these topics before proceeding to the test. The exam will be timed so you will not have the ability to peruse your notes or retake the exam. The exam itself will consist of 30 multiple choice questions and you will have 35 minutes to complete the exam. Federalism: The Basic elements of a Federal system of government (i.e. how is it structured/how power is shared) • Layers of gov • Equal power • Distinct powers Powers of the federal government: delegated powers, implied powers (necessary and proper clause), and concurrent powers. • Delegated Powers: (expressed/enumerated powers) powers given to the federal government directly by the constitution. Some most important delegated powers are: the authority to tax, regulated interstate commerce, authority to declare war, and grants the president role of commander and chief of the military • Implied Powers: Powers not expressed in the constitution, but that can be inferred. “Necessary and proper clause” • Concurrent powers: powers shared by both levels of government. Ex: Taxes, roads, elections, commerce, establishing courts and a judicial system • Reserved powers: powers not assigned by the constitution to the national government but left to the states or the people. Guaranteed by the 10th amendment. Include “police power”-health and......

Words: 37488 - Pages: 150

Exam Review

...Final Exam Review Outline The final exam will be cumulative, though with more emphasis on the post-midterm material. Below is a list of topics covered by the exam. Pre-midterm 1. Prove basic properties of the integers using only the axioms. 2. Find the negation, converse, and contrapositive of a statement. 3. Use the following techniques of proof: proof by contradiction proof by contrapositive proof by induction or strong induction 4. Prove an “if and only if” statement. Prove two sets are equal. 6. State and use the definitions of union, intersection and complements of sets Cartesian product of two sets equivalence relation equivalence class 7. Binomial Theorem definition of binomial coefficients Binomial Theorem (Thm 4.21) Post-midterm (Note: theorems and propositions listed are useful statements that you may quote and use in your proofs. You must quote the statement, NOT the number of the theorem or proposition!) 1. Number Theory Division Algorithm (Thm 6.13) greatest common divisors Euclid’s Lemma (Prop 6.31) Unique factorization theorem (Thm 6.32) Integers mod n 2. Real numbers upper and lower bounds supremum (least upper bound) and infimum (greatest lower bound) Completeness Axiom 3. Limits Absolute values as distances, the triangle inequality (Prop 10.10) definition of convergence to a limit (be able to state the......

Words: 308 - Pages: 2

Final Exam

...Final Exam Review Basics B i • • Basic terminology and concepts Layered model (physical to application) Internet Layering • • • • • • • • Level 5 Level 4 Level 3 Level 2 -- Application Layer (rlogin, ftp, SMTP, POP3, IMAP, HTTP..) -- Transport Layer(a k a Host-to-Host) Layer(a.k.a Host to Host) (TCP, UDP) -- Network Layer (a.k.a. Internet) y ( ) (IP, ICMP, ARP) -- (Data) Link Layer / MAC sub-layer (a.k.a. N t ( k Network Interface or kI t f Network Access Layer) -- Physical Layer • Level 1 Final Exam Review Physical Layer • • • • Time and frequency domains. Bandwidth Band idth and data rate rate. Analog and digital transmission. Simplex, half-duplex and full-duplex transmission Final Exam Review Physical Layer ( Ph i l L (cont’d) ’d) • • • • Transmission impairments. Decibel. S/N ratio. Channel capacity. – Nyquist Nyquist. – Shannon. • Types / properties of media – Copper (UTP: Cat-3, Cat 5) Cat 3, Cat-5) – Fiber. Final Exam Review Physical Layer (cont’d) (cont d) • Data encoding – Analog-to-digital. • (Time sampling / amplitude quantization) – Digital-to-analog. • (D t reconstruction) (Data t ti ) – Transmission modes. • S Synchronous. h • Asynchronous. Final Exam Review Data Li k L D Link Layer Error Control • • Framing Error detection / correction schemes schemes. • Parity. • Hamming distance • CRC (polynomial encoding) . Final Exam Review Data Li k L D Link Layer Flow Control • Acknowledgement • Stop and Wait • PAR (P i i A k (Positive Acknowledgement with l...

Words: 858 - Pages: 4

Ma 170 Final Exam Answers ( Week 8 Review )

...MA 170 Final Exam Answers ( Week 8 review ) http://www.projbid.com/downloads/ma-170-final-exam-answers-week-8-review/ Points Awarded 100.00 Points Missed 0.00 Percentage 100% Determine whether the system of linear equations has one and only one solution, infinitely many solutions, or no solution. Find all solutions whenever they exist. 1. A) one and only one solution 1. B) one and only one solution 1. C) one and only one solution 1. D) infinitely many solutions 1. E) no solution Points Earned: 4.0/4.0 Solve the linear system of equations 1. A) Unique solution: 1. B) Unique solution: 1. C) Infinitely many solutions: 1. D) No solution Points Earned: 4.0/4.0 Find the simple interest on a $400 investment made for 5 years at an interest rate of 7%/year. What is the accumulated amount? 540. A) The simple interest is $140, the accumulated amount is $540. B) The simple interest is $115, the accumulated amount is $515. C) The simple interest is $120, the accumulated amount is $520. D) The simple interest is $125, the accumulated amount is $555. Points Earned: 4.0/4.0 Find the present value of $40,000 due in 4 years at the given rate of interest 8%/year compounded monthly. 948. A) The present value is $28,948.67. B) The present value is $29,433.94. C) The present value is $29,076.82. D) The present value is $29,748.06. Points Earned: 4.0/4.0 Solve the system of linear equations using the Gauss-Jordan......

Words: 1203 - Pages: 5

Alberta Social 9 Final Exam Partial Review

...businesspeople. Other – People accepted as immigrants for humanitarian or compassionate reasons. Immigration and Refugee Protection Act of 2002 * Establishes categories of who can come to Canada * Makes sure that Canadian benefit socially, culturally and economically from immigration * Looks to respect bilingualism, multiculturalism * Makes sure the regions of Canada benefit financially * Tries to develop official minority language communities * Reunite families * Promotes integration of immigrants 2006-2007 Plans and Priorities (pg. 168) Steps to Immigrate * You have done one already… take the test! * Applies to economic immigrants only * Complete a formal application * Pass a medical exam (why do you think this is important?) * Pass a security check (why do you think this is important?) * How might assessing the health, background and experience of immigrants connect to Canadians’ right to “security of the person” under the Charter of Rights and Freedoms? Importance of Health * Every economic immigrant must prove they are healthy before immigrating to Canada * If you are immigrating for family or refugee, this does NOT apply * Need to make sure Canadians’ health is not at risk * Infectious disease * Mental disorder * Shouldn’t have anything that requires lots of care(i.e. tax $$$$) Immigration and Refugee Protection Act 2002 * Refugee - A person who seeks refuge......

Words: 6111 - Pages: 25

Final Exam Review-

...Final Exam Review- Hitzig parts 1-3 1. Revenue Recognition: General: 25-1 The recognition of revenue and gains of an entity during a period involves consideration of the following two factors, with sometimes one and sometimes the other being the more important consideration: ← a. Being realized or realizable. Revenue and gains generally are not recognized until realized or realizable. Paragraph 83(a) of FASB Concepts Statement No. 5, Recognition and Measurement in Financial Statements of Business Enterprises , states that revenue and gains are realized when products (goods or services), merchandise, or other assets are exchanged for cash or claims to cash. That paragraph states that revenue and gains are realizable when related assets received or held are readily convertible to known amounts of cash or claims to cash. ← b. Being earned. Paragraph 83(b) of FASB Concepts Statement No. 5, Recognition and Measurement in Financial Statements of Business Enterprises , states that revenue is not recognized until earned. That paragraph states that an entity's revenue-earning activities involve delivering or producing goods, rendering services, or other activities that constitute its ongoing major or central operations, and revenues are considered to have been earned when the entity has substantially accomplished what it must do to be entitled to the benefits represented by the revenues. That paragraph states that gains commonly result from transactions and other......

Words: 1877 - Pages: 8

Sp2750 Final Exam Review

...SP2750 – Final Exam Review 1.A group is defined as a collection of individuals _______. a. Whose interactions are not structured by rules & norms b. Who are not capable of influencing each other c. Who are trying to satisfy some personal need through joint association d. With different goals or values | 2.To be effective, group members do NOT need to ________. a. Commit to mutual goals b. Ensure accurate communication among members c. Belong to more than one group d. Participate in spirited dialog | 3.Ethnocentrism _______. a. Moderates cultural conditioning b. Regards one’s own ethnic group, nation, religion, culture, or gender as being more correct than others c. Believes that most other people share their stereotypes about ethnicity d. Is a prejudice directed at people because of their race or ethnic membership | 4.Which statement is true about the theory of the field of group dynamics? a. Developed in North American in the 20th century b. Focuses on advancing knowledge about the nature of group life c. Studies the behavior in groups. d. All of the above e. None of the above | 5.Which are characteristics of an effective group? a. Leadership & participation that are distributed to only a few members b. Accurate & complete communication c. A commitment to goals that reflect members’ interdependence d. Fair & complete review of all alternative positions | 6.Which is not an element of trust? a. Openness b.......

Words: 1831 - Pages: 8

It203 - Database Development Exam 2 Review

...IT203 Assignment Review for Exam 2 Name:  Celsa Morales   1. A well-formed XML document is syntactically correct   2. An XML document stores data in a hierarchical structure.  Is this statement? True or False   3. The CarbonCopy table contains the following data:   ID ConID TakenBy 1. 1334 FM22 2. 2343 JS10 3. 1001 MS01 4. 1454 MS01 5. 0989 JS10 6. 0989 MS01 You execute the following query: SELECT*FROM CarbonCopy where ID=5 How many rows should the result return? 0 4. You need to return a list of students from the Student table where the student’s e-mail address ends in “edu.”  Would the following SQL query return this information?  Yes or No   SELECT Email, LastName, FirstName from STUDENT WHERE Email like ‘%edu’   5. Will the following SQL statement return employee first and last names from the Pimp table sorted by last name in ascending order? Yes or No SELECT LastName, FirstName FROM Pimp ORDER BY LastName   6. When joining two tables on a single join condition, the Cartesian product refers to all possible rows in the result, including non-qualifying rows.  Is this statement? True or False   7. A join provides a way to logically recombine data from tables separated during the normalization process.  Is this statement? True or False     8. Will the following SQL statement return a single row, knowing that PimpID is the primary key of the Pimp table?  Yes or No   SELECT FirstName, LastName FROM PIMP WHERE PimpID=’FM22’   9. Would the......

Words: 1285 - Pages: 6