Currently I am taking database management system and my teacher wants my to fill
ID: 3679826 • Letter: C
Question
Currently I am taking database management system and my teacher wants my to fill in these fill in the blank questions.
1.A single piece of data is a _______________________.
2.______________________________invented the first punched card.
3.Name one challenge with storing data today.
4.Software to manage data is called __________________________.
5.Herman Hollerith founded ______________________________.
6.DDL is known as ______________________________________.
7.A basic SQL statement has the following 3 parts _______________, _____________________ and __________________________.
8.In the like clause, what matches any group of characters of any length? _________________
9.T or F, Or comes before And?
10. The where-clause limits the number of ______________ that are selected from the database.
11.Three typical cardinalities are ________________________, _______________________________, and _______________________________
12.Intersection data is the same as this type of entity _________________________.
13.A relationship of one entity to occurrences of the same type of entity is called _______________________________.
14.A ________________________________ involves 3 different entity types.
15.Modality is _____________________________________________.
16.Four operations that can be performed on stored data are ______________________________ , _______________________________, _______________________________, _______________________________
17.The ability to tie pieces of related data together is called ____________________________.
18.In general data redundancy is good for a system. T or F. ______________
19.Name three data control issues.
20.Hierarchical databases are known as ______________________ approaches to database.
Explanation / Answer
1. Field/object
2. Herman Hollerith
3. retriving stored data
4. data management software
5.The Tabulating Machine Company
6.Data Definition Language
7. select, column names, table name
8. %*
9. F
10. number of matches to given condition
11.High-cardinality,Normal-cardinality,Low-cardinality
12. many-to-many relationship
13.Unary Relationship (recursive)
14.relationship/business
15.Modality are the indicators of the business rules around a relationship.
16. create,read,update,delete
17.table
18.False
19.Data security,Backup and Recovery,Concurrency Control
20. SEMISTRUCTURED database
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.