Foundational Database Review Questions TB-25. Describe why database design is im
ID: 3838128 • Letter: F
Question
Foundational Database Review Questions
TB-25. Describe why database design is important for modern organizations.
TB-26. Compare and contrast the primary key, combination key, and foreign key within an entity.
TB-27. Describe the three types of relationships in a relational database.
TB-28. What is the purpose of a secondary key?
TB-29. What is an entity-relationship diagram, and why is it useful?
TB-30. What is the relational model?
TB-31. Why is redundancy undesired?
Foundational Hardware Review Questions
TB-1. IS hardware is classified into what three major types?
TB-2. Describe various methods for entering data into and interacting with a computer.
TB-3. How do computers represent data internally?
TB-4. Describe the role of a motherboard.
TB-5. What determines the speed of a CPU?
TB-6. Compare and contrast the different types of secondary data storage.
TB-7. What are output devices? Describe various methods for providing computer output.
Explanation / Answer
TB-25. Describe why database design is important for modern organizations.
The main motto of any organization is to improve the efficiency and reduces the overall costs. A database management system plays key role in an organization it manages data efficiently and allows users to perform multiple tasks with ease. Taking time to design a database saves time and makes work efficient during development.
TB-26. Compare and contrast the primary key, combination key, and foreign key within an entity.
A primary has a column or combination of columns that contain values that uniquely identify each row in the table, those columns is called the primary key of the table.
Example: EMP_ID from employee information table contained fields like EMP_ID,EMP_Name,EMP_Location,EMP_Designation.EMP_ID is Primary key.
A Foreign Key is a column or combination of columns that is used to establish and provides a link between the data in two tables and the data is controlled by storing it in foreign key table.
Example: EMP_ID is primary key in one tables and having another table with same primary key and has a link to the main table then that EMP_ID column is foreign key in second table.
A Combination key is also called as composite key, is a combination of two or more columns in a table is used to uniquely identify each row in the table.
TB-27. Describe the three types of relationships in a relational database.
One-to-one: In this relationship both tables has only one record on either side of the relation.
One-to-many: The table contains primary key has only one record and it may contain relation to none, one or more records in related table.
Many-to-many: Each record in both tables can relate to any number of records in related table.
TB-28. What is the purpose of a secondary key?
The purposing of secondary key is indexing the data, for fast search. When a record is selected as primary then other records would be secondary keys we can search using that fields for fast accessing the data.
TB-29. What is an entity-relationship diagram, and why is it useful?
An Entity relationship diagram is a graphical representation of an information system it describes the relation between people, objects, works, events conducted with in the system. It is Data modeling technique which helps to define a bussiness process to use to implement a relational database.
TB-30. What is the relational model?
A Relational Data model is a way of dealing the data by managing ,storing and processing the data. It has properties and capabilities required to process data with storage efficiency.
TB-31. Why is redundancy undesired?
The un-used or repeated data in the database increase the redundancy, due to repeated or un-used records or data the efficiency of a database is reduced and performance degraded so redundancy undesired.
TB-1. IS hardware is classified into what three major types?
Input Technologies: Used to provide information into the computer. Keyboards, mouse etc.
Processing technologies: The resources which are processing the inputs into outputs, such as mobile, super computers etc.
Output technologies: Devices deliver information in user understandable format, such as monitors etc.
TB-2. Describe various methods for entering data into and interacting with a computer.
Using input devices Keyboards, micro-phones and web-cams etc. by using an input technologies we can interact with computer.
TB-3. How do computers represent data internally?
In a computer the data internally represented as Binary digit or Bit
TB-4. Describe the role of a motherboard.
It is the main component which allows communication between all components in the computer to process the operation.
TB-5. What determines the speed of a CPU?
RAM - Random access memory
TB-7. What are output devices? Describe various methods for providing computer output.
Monitors, Projectors etc. Interactive method by taking input from input device processing it and presenting to output device.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.