Database Management Chapters 1-4 fully solved 2023

Database Management Chapters 1-4The logical layer of the ANSI/SPARC model provides which of the following? A. Physical data independence B. Parent-child relationships C. Logical data independence D. Encapsulation Physical data independence The external layer of the ANSI/SPARC model provides which of the following? A. Physical data independence B. Parent-child relationships C. Logical data independence D. Encapsulation Logical data independence Which of the following is not true regarding user views? A. Application programs reference them. B. People querying the database reference them. C. They can be tailored to the needs of the database user. D. Data updates are shown in a delayed fashion. Data updates are shown in a delayed fashion The database schema is contained in the ____________ layer of the ANSI/SPARC model. logical User views are contained in the ____________ layer of the ANSI/SPARC model external When application programs use flat file systems, where do the file definitions reside? In the application programs Which of the following is true regarding the hierarchical database model? A. It was first developed by Peter Chen. B. Data and methods are stored together in the database C. Each node may have many parents. D. Records are connected using physical address pointers Records are connected using physical address pointers Which of the following is true regarding the network database model? A. It was first developed by E.F. Codd. B. Data and methods are stored together in the database. C. Each node may have many parents. D. Records are connected using common physical address pointers. Each node may have many parents. & Records are connected using common physical address pointers Which of the following is true of the relational database model? A. It was first developed by Charles Bachman. B. Data and methods are stored together in the database. C. Records are connected using physical address pointers. D. Records are connected using common data items in each record. Records are connected using common data items in each record. Which of the following is true regarding the object-oriented model? A. It was first developed by Charles Bachman. B. Data and methods are stored together in the database. C. Data is presented as two-dimensional tables. D. Records are connected using common data items in each record Data and methods are stored together in the database Which of the following is true regarding the object-relational model? A. It serves only a niche market and most experts believe it will stay that way. B. Records are connected using physical address pointers. C. It was developed by adding object-like properties to the relational model. D. It was developed by adding relational-like properties to the object-oriented model. It was developed by adding object-like properties to the relational model. According to advocates of the relational model, which of the following describe the problems with the CODASYL model? A. It is too mathematical. B. It is too complicated. C. Set-oriented queries are too difficult. D. It has no formal underpinnings in mathematical theory. It is too complicated. & Set-oriented queries are too difficult & It has no formal underpinnings in mathematical theory According to advocates of the CODASYL model, which of the following describe the problems with the relational model? A. It is too mathematical. B. Set-oriented queries are too difficult. C. Application systems need record-at-a-time processing. D. It is less efficient than CODASYL model databases. It is too mathematical & Application systems need record-at-a-time processing. & It is less efficient than CODASYL model databases The ability to add a new object to a database without disrupting existing processes is an example of ____________. logical data independence The property that most distinguishes a relational database table from a spreadsheet is the ability to present multiple users with their own _____ views of the data Examples of an entity are A. A customer B. A customer order C. An employee's paycheck D. A customer's name A customer , their order and name Examples of an attribute are A. An employee B. An employee's name C. An employee's paycheck D. An alphabetical listing of employees An employee's name Which of the following denotes the cardinality of "zero, one, or more" on a relationship line? A. A perpendicular tick mark near the end of the line and a crow's foot at the line end B. A circle near the end of the line and a crow's foot at the end of the line C. Two perpendicular tick marks near the end of the line D. A circle and a perpendicular tick mark near the end of the line A circle near the end of the line and a crow's foot at the end of the line Valid types of relationships in a relational database are A. One-to-many B. None-to-many C. Many-to-many D. One-to-one One-to-many Many-to-many One-to-one If a product can be manufactured in many plants, and a plant can manufacture many products, this is an example of which type of relationship? A. One-to-one B. One-to-many C. Many-to-many D. Recursive Many-to-many Which of the following are examples of recursive relationships? A. An organizational unit made up of departments B. An employee who manages other employees C. An employee who manages a department D. An employee who has many dependents An employee who manages other employees Examples of a business rule are A. A referential constraint must refer to the primary key of the parent table. B. An employee must be at least 18 years old. C. A database query eliminates columns an employee should not see. D. Employees below pay grade 6 are not permitted to modify orders. An employee must be at least 18 years old & Employees below pay grade 6 are not permitted to modify orders A relational table A. Is composed of rows and columns B. Must be assigned a data type C. Must be assigned a unique name D. Is the primary unit of storage in the relational model Is composed of rows and columns & Must be assigned a unique name & Is the primary unit of storage in the relational model A column in a relational table A. Must be assigned a data type B. Must be assigned a unique name within the table C. Is derived from an entity in the conceptual design D. Is the smallest named unit of storage in a relational database Must be assigned a data type & Is derived from an entity in the conceptual design & Is the smallest named unit of storage in a relational database A data type A. Assists the DBMS in storing data efficiently B. Provides a set of behaviors for a column that assists the database user C. May be selected based on business rules for an attribute D. Restricts characters allowed in a database column All the above A primary key constraint A. Must reference one or more columns in a single table B. Must be defined for every database table C. Is usually implemented using an index D. Guarantees that no two rows in a table have duplicate primary key values Must reference one or more columns in a single table & Is usually implemented using an index & Guarantees that no two rows in a table have duplicate primary key values A referential constraint A. Must have primary key and foreign key columns that have identical names B. Ensures that a primary key does not have duplicate values in a table C. Defines a many-to-many relationship between two tables D. Ensures that a foreign key value always refers to an existing primary key value in the parent table Ensures that a foreign key value always refers to an existing primary key value in the parent table