Databases systems minimizes data: a Integrity b. Independence c. Breaches d. Red
ID: 3855502 • Letter: D
Question
Databases systems minimizes data: a Integrity b. Independence c. Breaches d. Redundancy e. Inequality Which of the following is the correct order of the data hierarchy, from smallest to largest? a. bit, byte, field, file, record, database b. bit, byte, field, record, file, database c. byte, bit, field, record, file, database d. byte, bit, field, file, record, database e. bit, field, record, byte, file, database A _____ is a set of programs that provide users with tools to add, delete, access, modify, and analyze data stored in a _____ a. Website, file b. Database, file c. Information system, database d. Database management system, database e. File management system, database A key to design a functional database is a data: a. File b. Entity c. System d. Model e. Hierarchy Which of the next statements about the Relational Database Model is NOT true? a. It is based on the concept of two-dimensional tables b. It increases data integrity c. Data are stored in a flat-file d. Contains records and attributes e. It prevents data isolation Customer is the _____ in Customer File and the _____ in the Order File. a. primary key, foreign key b. primary key, identifier c. entity, attribute d. secondary key, identifier e secondary key, primary key A _____ relationship exist when an association is maintained within a single entity. a Binary b. Complex c. Unary d. Connective e Closed In a relational database, each row represents a(n) _____ and each column represents a(n) _____ a. Instance, attribute b. Entity, attribute c. Field, record d. Property, identifier e. Record entity The entity-relationship diagram uses the _____ symbol to represent the cardinality of a relationship. a. Circle b. Arrow c. Diamond d. SquareExplanation / Answer
9. Database system minimizes data redundancy.
d is correct answer.
when the database is created, it always follows normalization of data in the table or Relation. Normalization is the process to organize the attributes i.e. columns and relations i.e. tables. Hence it removes the repeated data or redundancy and improves integrity of data. different types of normalization is used in different cases.
10. Correct answer is option b.
bit- it is smallest unit of representing data . value can be either 0 or 1.
BYTES- eight bits make a byte. it represents character or special symbols in databse.
Fields- it consists of group of characters to identify the properties, status or characteristics of an real time entity like person, object, things, place, action. in database it is known as attributes of an entity. it makes the columns of databse.
Record- it a row in the relation or table which stores the values of attributes of an entity. it represents a unique entity value. it is also known as tuple.
File- it is a group of related records. like a table which stores information about a system or real entity eg bank, may consists of files, bank branches, bank employess, bank customers etc related to banks. in each file their will be a uniqe key or combination of two or more unique keys which identifies the record known as primary and secondary keys respectively.
database- group of logically related files or records is a database. it is maintained by the DBMS, DATABASE MANAGEMENT SYSTEM.
11. CORRECT answer is D.
DBMS is a system software to create , manage, changes data in database. all the creation ,modifications, updations like add, delete, save , create , update can be done on database using DBMS using different queries. EXAMPLES ARE MySQL, PostgreSQL, Microsoft Access, SQL Server, FileMaker, Oracle, RDBMS etc.
12. correct answer is E.
IT MAINLY IMPLEMETS analysis and its results. like financial planning, performance mangement etc. its main key is hierarchy.
13. correct answer is E.
relational model does not prevents data isolation rather it implements it. . as it results in complete and correct data which is not affected by any other user query.
rest all options are true for RDBMS.
14. A is correct answer.
customer no uniquely identifies the customer in a file hence primary key.
in order file it will be uniquely identifies a record in combination with order no. as the same customer can place different orders too.
note- example given not visible properly hence i can not explain it respectively.
15. correct answer is C.
16. correct answer is A. already discussed in part 10. row represents record or tuples or an instance of a real entity.
column represents its characteristics , status or fields.
17.correct answer is E.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.