Database Question - Redundancy Wastes Space

Database question 2 T/F Redundancy wastes space because you are storing the same data in more than one place True T/F A Spreadsheet's data-sharing features allows multiple employees to update data in one spreadsheet at the same time False T/F An attribute is a characteristic or property of an entity True T/F A relationship is an association between attributes False T/F A database will not only hold information about multiple types of entities, but also information aobut hte relationships among these multiple entities True T/F In a database, each entity has it's own table True T/F The attributes of an entity become the rows in the table False T/F In an entity-relationship (E-R) diagram, rectangles represent entities and lines represent relationships between connected entities True T/F Programs created with Visual Basic, Java, Perl, PHP, or C++ can access the database directly, rather than having to access it through the DBMS False T/F Sharing data is one advantage of database processing True Storing the same data in more than one place is called Redundancy A(n) ______ is a person, place, object, event, or idea for which you want to store and process data. Entity A(n) ______ is a characteristic or property of an entity Attribute A(n) _____ is the computer counterpart to an ordinary paper file you might keep in a file cabinet or an accounting ledger Data File The _____ of an entity became the columns in the database table Attributes An association between entities is known as a(n) _____ Relationship A visual way to represent a database is with a(n) Entity-Relationship diagram Popular ______ include Access, Oracle, DB2, MySQL, and SQL Server DBMSs During the _____ process, a database expert determines the structure of the required database Database Design ______ are screen objects used to maintain, view, and print data from a database Forms T/F In a nondatabase, file-oriented environment, data is often partitioned into several disjointed systems with each system having its own collection of files True An integrity constraint is a rule that _____ Data must follow in the database A database has _____ if the data in it satisfies all established integrity constraints Integrity _____ is the prevention of unauthorized access to the database Security A(n) _____ frees programmers who write database access programs from having to engage in mundane data manipulation activities, such as adding new data and deleting existing data Data Base Management System A person who is in charge of a database within an organization is often called the database Administrator A good _____ should provide an opportunity for users to incorporate integrity constraints when they design the database Data Base Management System A DBMS lets you assign users to _____ Groups _____ is a property that lets you change the structure of the database without requiring you to change the programs that access the database Data Independence One disadvantage of a database system is _____ A larger file size Access assigns the default name ______ to the first new table you create Table1 The _____ is the main control center for opening and working with database objects. Navigation Pane The ______ Toolbar provides one-click access to commonly used commands, such as Save Quick Access The _____ tab provides options for adding, removing, and formatting the fields in a table Fields The _____ window is the program window that appears when you create a new database or open an existing database Access The ______ provides the main Access commands organized by task into tabs and groups Ribbon The first step in organizing data into a database is to identify the individual _____ Fields The content of any given field is the _____ Field Value Which of the following could be defined as a field in a database? Customer Name Order Number Phone Number Data from separate tables can be connected by specifying a Common Field T/F A collection of fields describing a person, a place, an object, and event, or an idea is a table True T/F A single set of field values within a table is a record True T/F A database is a collection of related tables True T/F A collection of related tables is called a Relational Database True T/F You connect the records in separate tables through a common field that appears in both tables True T/F A primary key in one table cannot be used as foreign key in a different table False T/F Although a field has unique values in the table in which it is the primary key, it does not have to have unique values in the table in which it is the foreign key True T/F A relational DBMS controls the storage of databases on disk and facilitates the creation, manipulation, and reporting of data True T/F Like spreadsheets, a DBMS can handle massive amounts of data and can easily form relationships among multiple tables False T/F Only one user can retrieve and analyze data that was entered into a database by others. False T/F A relational database handles entities, attributes, and relationships by storing each entity in it's own table True T/F The attributes of an entity become the rows or records in a table False T/F A relation is essentially just a two-dimensional table True T/F In a relation, the order of the columns is immaterial True T/F In a relation, the order of rows is important False T/F A relational database is a collection of relations True T/F An unnomalized relation is a table that has more than one row False T/F The secondary key provides an important way of distinguishing one row in a table from another False T/F QBE is a visual approach to writing queries True Access automatically adds double quotation marks around values in the design grid that are formatted as Text fields when you run the query or move the insertion point to another cell in the design grid True A relation is a(n) Table Based on the statement below, which of the following is the primary key? Part (PartNum, Description, OnHand, Class, Warehouse, Price) PartNum When duplicate column names exist in a database and you need to indicate the column to which you are referring, _______ Write both the table name and the column name, separated by a period Rows are also called Tuples The _____ key of a table is the column or collection of columns that uniquely identifies a given row in that table Primary The compound criteria (conditions) are created by using ______ AND or OR Count, Sum, Avg, Max, and Min are a few of the built-in statistics or _____ functions that can be used in a query Aggregate If you are sorting records by more than one field, the more important field is called the ______ Primary sort key A query that changes data is a(n) _____ query Update A _____ query creates a new table using the query results Make-Table The _____ command within relational algebra takes a vertical subset of a table PROJECT Based on the Customer table, which command lists all information from the table concerning customer 524? CustomerNum CustomerName Street City State Zip SELECT Customer WHERE CustomerNum = 524 GIVING Answer The _____ command within relational algebra includes the word OVER followed by a list of columns to be included PROJECT Which operation will allow you to extract data from more than one table? Join You can restrict the output from a join to include only certain columns by using the _____ command PROJECT Two tables are considered to be _____ compatable if they have the same number of columns and their corresponding columns represent the same type of data Union The _____ operator is performed by the SUBTRACT command in relational algebra Difference The _____ operator is used to concatenate every row in the first table with every row in the second table Product The product of two tables is also called the _____ product Cartesian Using the product operator, if table A has 4 rows and table B has 4 rows, the number of rows in the product of these two tables is _____ 16 Which of the following is the most logical data type to use if a field will contain long comments or explanations? Long Text In the accompnying figure, the _____ is indicated by the red brackets Field Properties Pane