AP Notes, Outlines, Study Guides, Vocabulary, Practice Exams and more!

Data management

PT 2520 Unit 10

Subject: 
Rating: 
0
No votes yet

PT2520 Unit 9 Clarence Gross 3/2/13 Threat analysis is about identifying all the ways the database can be harmed. True Accidental threats are as great a danger to a database as intentional ones. True A policy is a set of step by step instructions for accomplishing a task. False A procedure is a set of rules for how to do things. False A disaster recovery plan is a plan for how to recover data and availability after any of various disasters. True A stored procedure is one or more SQL statements grouped to be executed together. True Stored procedures can be used to enforce business rules and make transactions such as updates safer. True The syntax for stored procedures is the same in any database management system. False

PT 2520 Unit 9

Subject: 
Rating: 
0
No votes yet

Jamel Travis 11/17/2012 Homework 9 Threat analysis is about identifying all the ways the database can be harmed. True Accidental threats are as great a danger to a database as intentional ones. True A policy is a set of step by step instructions for accomplishing a task. False A procedure is a set of rules for how to do things. False A disaster recovery plan is a plan for how to recover data and availability after any of various disasters. True A stored procedure is one or more SQL statements grouped to be executed together. True Stored procedures can be used to enforce business rules and make transactions such as updates safer. True The syntax for stored procedures is the same in any database management system. False

PT 2520 Unit 8

Subject: 
Rating: 
0
No votes yet

Jamel Travis 11/10/2012 Homework 8 Authorization is the process of assigning permissions to users. True Authentication is the process of assigning permissions to users. False In SQL Server, a login provides database level permissions. False In SQL Server, the USER is mapped to a login and assigned database permissions. True Permission is an action granted to a database user. True A role is a collection of related permissions True A role consists of ownership of database objects. False A schema consists of ownership of a database objects. True Permission to SELECT allows a user to view data. True Permission to UPDATE allows a user to add records to the database. True

PT 2520 Unit 7

Subject: 
Rating: 
0
No votes yet

PT2520 Clarence Gross 2/9/12 Homework A scalar function operates on one row at a time. True And aggregate function works on multiple rows a time. True Whenever you have an aggregate function in a query criteria, you must use the HAVING keyword. False Any column in a SELECT that contains an aggregate function, but that is not a part of aggregate function, must be addressed in a GROUP BY clause. True An INNER JOIN returns all the records in the joined tables. False There is no error of the following SQL statement: SELECT CustomerCity, Count (CustomerKey) FROM Customer False There is no error of the following SQL statement: SELECT CustomerCity, Count (CustomerKey) FROM Customer GROUP BY CustomerCity WHERE Count(CustomerCity) > 20 True

PT 2520 Unit 5

Subject: 
Rating: 
0
No votes yet

Jamel Travis 10/27/2012 Homework Unit 5 Choosing a database management system requires a great deal of analysis. True When choosing a database management system, you should consider system compatibility and hardware requirements. True Only insert and update statements are part of a database transaction. False Physical design is a column specification that determines what kind of data can be stored in it. True A data type is a column specification that determines what kind of data can be stored in it. True Int, decimal and money are character numeric types. True Char and NChr are variable-length character types. True Varchar and NVarchar are based on the Unicode character types. False NChar and NVchar are based on the Unicode character set. True

PT 2520 Unit 4

Subject: 
Rating: 
0
No votes yet

PT2520 UNIT 4 Clarence Gross 2/2/13 Normalization is the process of removing anomalies from database design. True Not being able to insert data because other data is required is an example of an insertion anomaly. True An insertion anomaly occurs when you enter data inaccurately. False An update anomaly occurs when you have to update the same data in multiple places. True A deletion anomaly occurs when you are unable to delete data in a primary key table because a foreign key table contains records related to that data. False Normal forms are sets of rules designed to remove anomalies and redundancy from database design. False The First Normal Forms removes all repeating groups and arrays. True

PT 2520 Unit 3

Subject: 
Rating: 
0
No votes yet

PT2520 Clarence Gross 1/19/12 Unit 3 The logical design is independent of any database management system. True The physical design is the logical design adapted to the constraints and features of the database management system. True You should always try to create cross relationships between parent and tables. False Naming conventions help support clarity and consistency in database design. True One to one relationships between entities are valid but rare. True Crow?s feet notation conveys more information about cardinality than arrow notation. True In a one-to-many relationship, each row on in the primary key table can be related to any number of rows in the foreign key or child table. True

PT 2520 Unit 2

Subject: 
Rating: 
0
No votes yet

NT 2520 Unit 2 Clarence Gross 1/2/13 A requirement is something a database needs to do in order to fulfill its purpose. True You only need to include the most important stakeholders in the database discussions. True Forms are used for gathering input. True A transaction database is optimized to track transactions in real time. True Data mining uses business intelligence tools and techniques on a variety of data sources brought together in a data warehouses. True The domain is the focus of knowledge area of a database. True Interviews are good for asking open ended questions. True Open ended question are questions that don?t have fixed answers. True Questionnaires are good for asking open ended questions. False

PT 2520 Unit 1

Subject: 
Rating: 
0
No votes yet

PT 2520 Unit 1 Homework Clarence Gross 12/22/12 At its simplest, a database can be seen as a collection of related data. True A delimited file is a file where the length of the file is limited. False A delimited file is one in which the data is separated by a character such as a comma. True All fixed length files are of the same length. True In relational database, logic design is kept separate from physical design. True A hierarchical database is designed with a tree-like structure that resembles a file system. True Codd defined the core principles of a relational database in 1970 True Data redundancy improves the integrity of a database. False In a diagram, crows feet notation conveys more information about the relationships. True

AP Us History Chapter 12

Subject: 
Rating: 
0
No votes yet

Copyright ? Houghton Mifflin Company. All rights reserved. CHAPTER 12 People and Communities in the North and West, 1830?1860 LEARNING OBJECTIVES After you have studied Chapter 12 in your textbook and worked through this study guide chapter, you should be able to: 1. Discuss the characteristics of rural life in American society from 1830 to 1860. 2. Examine the interest in and the emergence of utopian communities in American society during the early nineteenth century, and discuss the ideas associated with these communities. 3. Explain the emergence of California as the population center on the West Coast in the late 1840s and early 1850s, discuss the experiences of ?the forty-niners,? and explain the integration of California into the national market economy.
Subscribe to RSS - Data management

Need Help?

We hope your visit has been a productive one. If you're having any problems, or would like to give some feedback, we'd love to hear from you.

For general help, questions, and suggestions, try our dedicated support forums.

If you need to contact the Course-Notes.Org web experience team, please use our contact form.

Need Notes?

While we strive to provide the most comprehensive notes for as many high school textbooks as possible, there are certainly going to be some that we miss. Drop us a note and let us know which textbooks you need. Be sure to include which edition of the textbook you are using! If we see enough demand, we'll do whatever we can to get those notes up on the site for you!