Recall that a database has many types of users, each of whom may require a different...

Recall that a database has many types of users, each of whom may require a different view of the database. The database user responsible for creating database accounts in a DBMS like Oracle is called the:
1. The database administrator (DBA)
2. Database end user
3. DBMS system builder
4. Database designer
5. none of the above

Which of the following can be an example of a multi-valued attribute in ER modeling of a database?

address
last name
middle name
country
none of the above

One limitation of traditional file system, which runs programs with data, that is solved by using a database management system is:
1. Provision of data independence
2. Separation of data from program using the three data level architecture
3. Replication of data and programs
4. Use of the internet
5. none of the above
In a database, integrity constraints must not be violated after any database update. Given a database table with schema Customer (Id, Fname, Lname, phone), which has a state having the two tuples <1, ‘Mark’, ‘Adam’, ‘416-555-2233’> and
<2, ‘Pat’, ‘Moore’, ‘519-333-6161’>, what integrity constraint is violated by inserting the following new tuple into Customer
<1, NULL, ‘Hardy’, ‘226-222-1234’>.
1. Semantic Integrity constraint
2. Foreign key referential integrity constraint
3. Primary Key integrity constraint
4. All of the above
5. none of the above

Expert Solution

Recall that a database has many types of users, each of whom may require a different view of the database. The database user responsible for creating database accounts in a DBMS like Oracle is called the:

Answer: a. The database administrator (DBA)

Explanation: In a database management system, the database administrator is responsible for locking and unlocking user accounts.

Which of the following can be an example of a multi-valued attribute in ER modeling of a database?

Answer: a. address

Explanation: An address consists of many atomic parts, thus it is a multivalued attribute.

One limitation of traditional file system, which runs programs with data, that is solved by using a database management system is:

Answer: a. Provision of data independence

Explanation: Changing files changes programs in a traditional file system.

In a database, integrity constraints must not be violated after any database update. Given a database table with schema Customer (Id, Fname, Lname, phone), which has a state having the two tuples <1, ‘Mark’, ‘Adam’, ‘416-555-2233’> and
<2, ‘Pat’, ‘Moore’, ‘519-333-6161’>, what integrity constraint is violated by inserting the following new tuple into Customer
<1, NULL, ‘Hardy’, ‘226-222-1234’>.

Answer: c. Primary Key Integrity constraint

Explanation: Id 1 already exists and it is primary key so the value of primary key cant be repeated.

venereology answered 2 years ago

Consider a game with two players, each of whom has two types. The types of player...

Consider a game with two players, each of whom has two types. The types of player 1 are T1 = (a,b). The types of player 2 are T2 = (c,d). Suppose the beliefs of the types are p1(c/a) = p2(a/c) = 0.25 and p1(c/b) = p2(a/d) = 0.75. Is there a common prior? If yes, construct one; if no, prove why not.

There are many different types of pressures that may change our behaviors and attitudes. Discuss these...

There are many different types of pressures that may change our behaviors and attitudes. Discuss these types of pressures with examples to each type.

Your database contains a role called nurse and many users who have that role. One of...

Your database contains a role called nurse and many users who have that role. One of the users in the system is jackie. You need to write statements to implement the following privileges: All nurses should have read access to the shifts table; Jackie happens to be a nurse, but also has administrative duties and should be able to update, insert, and delete from the shifts table. Write SQL that accomplishes this

Research Paradigms: Different kinds of research require different types of paradigms. Identify three types of research...

Research Paradigms: Different kinds of research require different types of paradigms. Identify three types of research and the appropriate paradigm for each.

Thinking about the types of users: Internal and External users, How do each type of user...

Thinking about the types of users: Internal and External users, How do each type of user effect the accounting process in an organization? What types of users have the most impact and why? responses must be 100 words minimum.

Imagine an island with many people on it, each of whom can catch some number of...

Imagine an island with many people on it, each of whom can catch some number of fish or pick some number of coconuts (each person's numbers being different from the rest). Now imagine that they discover a new invention--the ladder! The ladder allows every person to pick twice as many coconuts as before. a. What happens to the marginal cost of fish for each person and what happens to the marginal cost of coconuts? b. Sketch the PPF and show...

For each of the following users, (i) explain what accounting information they require about a business...

For each of the following users, (i) explain what accounting information they require about a business and (ii) name two statements or reports in which such information are available? Investors Banks Production manager Divisional manager Human resource manager responsible for performance management

Savemore store is a retail store that sells many different types of items and many different...

Savemore store is a retail store that sells many different types of items and many different brands. The store has plain clothes security workers who walk around the store and watch customers to monitor and limit theft of merchandise. Charley Customer enters Savemore and is seen walking down the clothing aisles looking at different clothing for sale at the store. Charley Customer has a shopping cart with him and makes his way to the registers to pay for the items...

Discuss why different application types require specialized quality requirements.

There are many types of cells in the human body with many different functions. Pick a...

There are many types of cells in the human body with many different functions. Pick a particular type of cell (exocrine secretory cells, hormone secreting cells, etc) and discuss its function within the body. Talk about common locations for the type of cell and discuss the clinical significance of the cell.

Question