Upgrade to remove ads Show
Only A$47.99/year
Terms in this set (39)Record A logically connected set of one or more fields that describes a person, place, or thing. Data and information are essentially the same thing. False Data integrity The condition in which all of the data in the database are consistent with the real-world events and conditions. Field A character or group of characters that has a specific meaning. File A collection of related records. Data Redundancy Situation where different versions of the same data are stored at different places because they werent updated considtently. Metadata Provide a description of the data characteristics and the set of relationships that link the data found within the database. Data anomaly is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions. False End-User Data Raw facts of interest to the end user Metadata describe the data characteristics and the set of relationships that links the data found within a database. True
Entity Represents a particular type of object in the real world. Constraint A restriction placed on the data. Data Definition Language (DDL) Enables a database administrator to describe schema components. Business rules apply to businesses and government groups, but not to other types of organizations such as religious groups or research laboratories. (True or False) False Which of the following is true of business rules? A) they allow the designer to set company policies with regard to data. Answer: B Entity (2) Is anything about which data are to be collected and stored. Model Main function is to help one understand the complexities of the real-world environment. In the context of data models, an entity is a person, place, thing, or event about which data will be collected and stored. (True or False) True Entity relationship Model was developed to allow designers to use a graphical tool to examine structures rather than deacribing them with text. Business Rule A brief, precise, and unambiguos description of a policy, procedure, or principle within a specific organization. If the attribute (B) is functionally dependent on a composite key (A) but not on any subset of that composite key, the attribute (B) is fully functionally dependent on (A). True Foreign Key Primary key of one table that has been placed into another table to create a common attribute. Column Represents an attribute in each table. Entity Integrity The Customer table's primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, and all entries are unique. SELECT Also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition. PROJECT Returns only the attributes requested, in the order in which they are requested. NOT NULL Constraint can be placed on a column to ensure that every row in the table has a value for that column. Referential Integrity Dictates that the foreign key must contain values that match the primary key in the related table, or must contain null. True Relational Algebra defines the theoretical way of manipulating table contents using relational operators. Union-Compatible When two or more tables share the same number of columns, and when their corresponding columns share the same or compatible domains, they are said to be... Existence-Dependent Entity that can exist in the database only when it is associated with another related entity occurrence. Domain The set of possible values for a given attribute. In the entity relationship model, a table row corresponds to an entity instance. True Composite attribute Can be further subdivided to yield additional attributes. An entity in the entity relationship model corresponds to a table in the relationship environment. True Strong Entity If an entity can exist apart from all of its related entities, then it is existence-independent, and it is referred to as? Weak entity Has a primary key that is partially or totally derived from the parent entity in the relationship. False Composite attributes make it easier to facilitate detailed queries. Cardinality Expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity. Recommended textbook solutionsEngineering Electromagnetics8th EditionJohn Buck, William Hayt 483 solutions
Computer Organization and Design MIPS Edition: The Hardware/Software Interface5th EditionDavid A. Patterson, John L. Hennessy 220 solutions
Introduction to the Theory of Computation3rd EditionMichael Sipser 389 solutions Introduction to Algorithms3rd EditionCharles E. Leiserson, Clifford Stein, Ronald L. Rivest, Thomas H. Cormen 720 solutions Sets with similar termsCIS-324 Final54 terms southerngoddess1 214 practice exam169 terms khalsasant Data Management Foundations - C175102 terms autumnoftheseraphs database test 173 terms adrianelemoine Sets found in the same folderDatabase Chapter 266 terms nbana93 Midterm Round 2125 terms Kereev database design20 terms toya13 finals Ch 451 terms rharperAP Other sets by this creatorChapter 4 CISS20111 terms michael_goeins Principles of Management CHP 121 terms michael_goeins EAWS-Airframe15 terms michael_goeins EAWS-Powerplants16 terms michael_goeins Verified questionsCOMPUTER SCIENCE True/False: Loops are more general than recursion. Verified answer
COMPUTER SCIENCE Write a program that alters the behavior of a Parent class using the concept of overriding. Verified answer
COMPUTER SCIENCE Write a Python statement that subtracts the variable down_payment from the variable total and assigns the result to the variable due. Verified answer COMPUTER SCIENCE T F The exit function can only be called from main. Verified answer Other Quizlet setsBronchodilators & Antiglaucoma Medications14 terms bkim01 Quiz 270 terms p4_alliek KIN- Foundations of Structural Kinesiology40 terms Jocelyn_Aguilar84 Generic's AND Trade's84 terms stephanie01132001 Related questionsQUESTION When data is changed in a query datasheet, what happens to the associated data in the table? Do the tables need to have a relationship if you want to create a query that retrieves data from multiple tables? 3 answers QUESTION What can extensive locking in a relational database cause 2 answers QUESTION What program serves as the GUI front end for accessing Sleuth Kit's tools? 15 answers QUESTION Java programs tend to execute faster than programs compiled into machine-dependent code because the Java virtual machine only has to interpret the bytecode. 9 answers Is a character or group of characters that has a specific meaning?field. a character or group of characters that has a specific meaning.
What provide a description of the data characteristics and the set of relationships that link the data found within the database?Metadata describe the data characteristics and the set of relationships that link the data within the database.
What is a DBMS and what are its functions quizlet?What is a DBMS, and what are its functions? Collection of programs, manages the database structure and controls access to data stored in the database. What is structural independence, and why is it important? File structure is changed without affecting the applications ability to access the data.
Which one of the following serves as the intermediary between the user and the database?database management system (DBMS)—Software that serves as an intermediary between the user and the database. The DBMS translates user requests into the computer code that is required to fulfill those requests. A DBMS manages the data stored within the database.
|