Currently I am taking database management system and my teacher wants my to fill
ID: 3679905 • 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. information
2. Herman Hollerith
3. databases are used to store data by special language called SQL and PL/SQL.
4. Database.
5. Herman Hollerith founded The Tabulating Machine Company.
6. Data Definition Language.
7. SELECT, FROM and semicolon example: SELECT * FROM EMP;
8. '%' matches any group of characters of any length.
9. False. Because AND followed by OR only.
10. records
11. high-cardinality, normal-cardinality, and low-cardinality
12. associative entity
13. recursive entity
14. entity relationship modeling
15. when a relationship is optional then the value of the modality is zero. so it requuires minimum one.
16. update, delete, search, and insert (one table to another)
17. self joining
18. False
19. Data security, Data backup and recovery, concurrency control
20. data model
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.