Question: 1. An example of a database management system (dhms) is in the set: a. Gedit, Pico, Notepad b. Windows 10, Linux Ubuntu, Apple OS c.

 1. An example of a database management system (dhms) is in

the set: a. Gedit, Pico, Notepad b. Windows 10, Linux Ubuntu, Apple

1. An example of a database management system (dhms) is in the set: a. Gedit, Pico, Notepad b. Windows 10, Linux Ubuntu, Apple OS c. Microsoft Word, Word Perfect, Open Office d. Microsoft Access, Oracle llg, MySQL e. none of the above 2. Some of the advantages of using a dkms instead of the traditional file system are: a. Provision of data model, query language, concurrency control b. Provision of data security and data independence c. Separation of data from program using its 3 level data architecture d. All of the above e. none of the above 3. The 3 level data architecture for representing data by the dkms are called: a. External, conceptual and physical (or internal) levels b. First, second and third levels e. Foot, middle and top levels d. All of the above e. none of the above 4. The dumg uses the database catalog (metadata) and a catalog has the following: a. Description of the structure (e.g., tables, views) of the primary database b. Actual data values of the database c. Replication of data and programs d. All of the above e. none of the above 5. A database is a a. record b. collection of interrelated data. e. field d. a file none of the above e. B R 6. Which statement best describes the relationship shown in the Figure 1 above? a. Each B record can relate to only one record of C while each C record can relate to multiple records of B through R. b. Each B record can relate to multiple records of C while each C record can relate to only one record of B through R. c. Each B record can relate to only one record of C and each C record can also relate to only one record of B through R. d. There can be multiple records of B and C related through R. e. None of the above 7. Using Figure 1, the participation constraint with double lines states that has total participation in the relationship R, which means that: a. Not all records of relation C bave to participate in this relationship R. b. All records of relation must participate in this relationship R to exist. c. All records of relation B must participate in this relationship R to exist. d. All of the above. e. None of the above 8. In a simple database that models "employees work for departments", the ER model can be used to identify the following entities and relationships in this piniworld: a. Employees, projects, worked. 29. b. Employees, dependents, dependents..of. c. Employees, departments, works for. d. All of the above. e. None of the above. 9. In a simple database that models "employees work for departments", in the ER model, a possible cardinality constraint on the database can be described as: a. Each Employee record can work for only one Department while each Department can have multiple Employees working for it_(N:1). b. Each Employee can work for multiple Departments while each Department can have only one Employee working for it_(1:N). c. Each Employee can work for only one Department and each Department can also have only one employee working for it (1:1). d. There can be multiple Employees and Department related through work for M:N)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!