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.