Show Home Subjects Solutions Create Log in Sign up Upgrade to remove ads Only ₩37,125/year
Terms in this set (20)What is a primary key? a field (or group of fields) that uniquely identifies a given entity in a table Which of the following illustrates the primary concepts of the relational database model? entities, attributes, keys, and relationships Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a table? entity What is the role of a foreign key? It is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables. What is the primary problem with redundant information? It is difficult to determine which values are the most current., It is often inconsistent, It is difficult to determine which values are the most accurate. What are rules that enforce basic and fundamental information-based constraints? relational integrity constraint What is one of the biggest pitfalls associated with real-time information? It continually changes Which of the following lists include all of the five characteristics common to high-quality information? accuracy, completeness, consistency, timeliness, and uniqueness What compiles all of the metadata about the data elements in the data model? data dictionary Which of the following is true in regard to the elimination of redundant information? improves information quality What is a technique for documenting the entities and relationships in a database environment? entity-relationship diagram What is a collection of related data elements? record What expresses the specific number of instances in an entity? cardinality What occurs between two entities in which an instance of one entity can be related to many instances of a related entity? one-to-many relationship What is a characteristic of a table? field What is composed of rows and columns that represent an entity? Table What is a primary key? a field that uniquely identifies a given record in a table What is a foreign key? a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables What occurs between two entities in which an instance of one entity can be related to only one instance of a related entity? one-to-one relationship What occurs when two entities can be related to each other in many instances? many-to-many relationship Recommended textbook solutionsComputer Organization and Design MIPS Edition: The Hardware/Software Interface5th EditionDavid A. Patterson, John L. Hennessy 220 solutions
Engineering Electromagnetics8th EditionJohn Buck, William Hayt 483 solutions
Introduction to the Theory of Computation3rd EditionMichael Sipser 389 solutions
Starting Out with C++ from Control Structures to Objects8th EditionGodfrey Muganda, Judy Walters, Tony Gaddis 1,294 solutions Sets with similar termsISYS 210 Appendix C21 terms shelby_elkins INFORMATION SYSTEMS45 terms pipervwright MIS Final Exam - APPENDIX C (Databases)12 terms josie_dexter Chapter 6 Designing Database10 terms quizzyquizface Sets found in the same folderMIS quiz 510 terms trisharam96 IS Exam 3128 terms augcollier MSIS 5.233 terms RachelEBellah MIS Chapter 668 terms vickycasado Other sets by this creatorQuiz 4 study guide29 terms MerlottiLorenzo Quiz 1 study guide10 terms MerlottiLorenzo Other Quizlet setsCSIT 120 Study Guide Exam 1 Chapters 1-322 terms ichefdan Test 134 terms mgorovoy COB 204 1st exam36 terms austint0012 APRD Exam 3 Study Guide31 terms lindseyhallen Related questionsQUESTION Information about a particular SmartData data value is stored in which chronicles master file? 2 answers QUESTION Which two configurations can an admin use to help users manage search results? 2 answers QUESTION The difference between FAT12/16 and FAT32 boot sector is that the FAT32 sector includes data to make the file system more scalable and flexible. 5 answers QUESTION Which statement about spreadsheets is true? 4 answers What are the primary concepts of a relational database model?In a relational database, all data is held in tables, which are made up of rows and columns. Each table has one or more columns, and each column is assigned a specific datatype, such as an integer number, a sequence of characters (for text), or a date.
What is primary key in relational DBMS quizlet?A primary key is a field in a table which is unique and enables you to identify every record in that table.
What is an example of a relational database quizlet?For example, SQLite is a relational database management system. SQLite contains the most minimal set of SQL commands which are the same across all RDBMSs.
What is a relational database quizlet?Relational Database. A database consisting of more than two related tables. The relationship between the tables is created by placing a primary key of the primary in to the secondary table. Database Tables.
|