Question 45 Which of the following is often used with a DBMS to manage the database...
Question 45
Which of the following is often used with a DBMS to manage the database environment?
|
Relationships |
||
|
NoSQL |
||
|
Record Management |
||
|
SQL |
Homework Answers
Answer : SQL
we use SQL to manage the database. by executing required queries like update insert and delete
Note : Please comment below if you have concerns. I am here to help you
If you like my answer please rate and help me it is very Imp for me
Add Answer to:
Question 45
Which of the following is often used with a DBMS to manage the
database...
Database Hello I need help with the following question: Question 9 Features of the DBMS which...
Database
Hello I need help with the following question:
Question 9 Features of the DBMS which are important to the process of database design and implementation include all of the following except how the DBMS supports referential integrity how the DBMS supports domain integrity O how costly the DBMS is to maintain the file structure of storage that the DBMS uses the database objects supported
Explore some of the new database technology including: NoSQL, Hadoop, and IMDB. Discuss each item. Include...
Explore some of the new database technology including: NoSQL, Hadoop, and IMDB. Discuss each item. Include the definition of each as well as how each can be used in the Management Information System environment. What is NoSQL? How does NoSQL store and retrieve data? What is a major advantage of NoSQL databases? Who uses no SQL databases? What is Hadoop? What does it mean that Hadoop is ‘open source?’ What is a major advantage of Hadoop databases? Who uses no...
Q.5] Answer the following questions based on the company database (based on the homework assignment 2) y dat...
Q.5] Answer the following questions based on the company database (based on the homework assignment 2) y database (based on the homework assignment 2) 3 IPage 1. For each department whose average employee salary is more than $30,000, write a SQL statement to retrieve the department name and the number of employees working for that department 2. Write a SQL statement to retrieve first name, last name, and address of each employee who lives in Houston, TX. 3. Write a...
QUESTION 1 What is the most common relationship within a relational database? Select the best answer...
QUESTION 1 What is the most common relationship within a relational database? Select the best answer from the following. One-To-One relationship. o One-To-Many relationship. Many-To-Many relationship. Zero-To-Zero relationship. QUESTION 2 What is an "entity'? Select the best answer from the following. An entity, for our purposes, is the same as a table in the database. An entity represents one of the columns in an individual table. There are no entities in a relational database. Entities are only part of NoSQL...
6. With respect to database systems, which of the following statement(s) is (are) true? a. The...
6. With respect to database systems, which of the following statement(s) is (are) true? a. The physical view of data is how people conceptually organize and understand the relationships among data items. b. The DML builds the data dictionary, creates the database, describes logical views for each user, and specifies security constraints. c. A record layout shows the items stored in a file, including the type of data stored and both the order and length of the data fields. d....
Observe the HAPPY INSURANCE DATABASE: This database will be used for the following questions citing tables...
Observe the HAPPY INSURANCE DATABASE:
This database will be used for the following questions citing
tables from the HAPPY INSURANCE database.
Write an SQL query for the HAPPY INSURANCE database that will
retrieve the name of each agent that has a rating lower than 100,
as well as, whose name starts with an “A”.
For this set of Review Questions, we will create and use a database for the Wedgewood...
For this set of Review Questions, we will create and use a database for the Wedgewood Pacific Corporation (WPC) that is similar to the Microsoft Access database we created and used in Chapters 1 and 2. Founded in 1957 in Seattle, Washington, WPC has grown into an internationally recognized organization. The company is located in two buildings. One building houses the Administration, Accounting, Finance, and Human Resources departments, and the second houses the Production, Marketing, and Information Systems departments. The...
The following tables form part of a database held in a relational DBMS: Hotel (hotelNo, hotelName,...
The following tables form part of a database held in a relational DBMS: Hotel (hotelNo, hotelName, city) Room (roomNo, hotelNo, type, price) Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo) Guest (guestNo, guestName, guestAddress) where Hotel contains hotel details and hotelNo is the primary key; Room contains room details for each hotel and (roomNo, hoteINo) forms the primary key; Booking contains details of bookings and (hoteINo, guestNo, dateFrom) forms the primary key; Guest contains guest details and guestNo is the primary key....
There are many data models for DBMS. 1- Which one is the most popular model used...
There are many data models for DBMS. 1- Which one is the most popular model used in DBMS ? Why is this model better than the other models ? Give an example of an old DBMS that did not use this current popular model. 2- Suppose that you have a college that maintains data on Students, Courses, and Instructors. Use the model in question 1 to describe the connection between the data. You should draw a simple diagram to show...
database qustion Q2) Answer the following: (16 points) Mention three drawbacks of using file systems to...
database qustion
Q2) Answer the following: (16 points) Mention three drawbacks of using file systems to store data and explain how DBMS overcome these drawbacks: 1 - 1- 2- 3- 2- Database system consists of: 2- 1- 3- 3- Database Engine consists of: 1- 3- 4- Mention three types of DB users: 1- 2- 3- 5- is a collection of operations that performs a single logical function in a database application. Transaction manager consists of two main programs: 1- 6-...
Database
Hello I need help with the following question:
Question 9 Features of the DBMS which are important to the process of database design and implementation include all of the following except how the DBMS supports referential integrity how the DBMS supports domain integrity O how costly the DBMS is to maintain the file structure of storage that the DBMS uses the database objects supported
Q.5] Answer the following questions based on the company database (based on the homework assignment 2) y database (based on the homework assignment 2) 3 IPage 1. For each department whose average employee salary is more than $30,000, write a SQL statement to retrieve the department name and the number of employees working for that department 2. Write a SQL statement to retrieve first name, last name, and address of each employee who lives in Houston, TX. 3. Write a...
QUESTION 1 What is the most common relationship within a relational database? Select the best answer from the following. One-To-One relationship. o One-To-Many relationship. Many-To-Many relationship. Zero-To-Zero relationship. QUESTION 2 What is an "entity'? Select the best answer from the following. An entity, for our purposes, is the same as a table in the database. An entity represents one of the columns in an individual table. There are no entities in a relational database. Entities are only part of NoSQL...
6. With respect to database systems, which of the following statement(s) is (are) true? a. The physical view of data is how people conceptually organize and understand the relationships among data items. b. The DML builds the data dictionary, creates the database, describes logical views for each user, and specifies security constraints. c. A record layout shows the items stored in a file, including the type of data stored and both the order and length of the data fields. d....
Observe the HAPPY INSURANCE DATABASE:
This database will be used for the following questions citing
tables from the HAPPY INSURANCE database.
Write an SQL query for the HAPPY INSURANCE database that will
retrieve the name of each agent that has a rating lower than 100,
as well as, whose name starts with an “A”.
database qustion
Q2) Answer the following: (16 points) Mention three drawbacks of using file systems to store data and explain how DBMS overcome these drawbacks: 1 - 1- 2- 3- 2- Database system consists of: 2- 1- 3- 3- Database Engine consists of: 1- 3- 4- Mention three types of DB users: 1- 2- 3- 5- is a collection of operations that performs a single logical function in a database application. Transaction manager consists of two main programs: 1- 6-...
Most questions answered within 3 hours.
-
5 situations are listed below and 8 reduction chemicals are
listed A-H below, match the letters...
asked 3 minutes ago -
1. If more spouses decide to quit their jobs to stay home with
their young children...
asked 7 minutes ago -
Please use algebraic manipulation to prove the following
statement:
x'y'z' + x'yz' + x'yz + xyz'...
asked 8 minutes ago -
3.Another patient has a family history in which:
1. the disease was equally distributed among the...
asked 11 minutes ago -
If you are the TM of a shipper of cooking oil the sales
department wants to...
asked 9 minutes ago -
NEED THIS URGENTLY PLEASEEE
Suppose a fair coin is tossed 5 times and the result are...
asked 18 minutes ago -
Find the magnetic field B produced by several circular loops of
which has a radius given...
asked 26 minutes ago -
A mole of monatomic ideal gas is expanded from 0.45 L to 0.75L
at an external...
asked 25 minutes ago -
Carbon dioxide (CO2) gas is steadily pressurized and cooled by
sending it sequentially through a compressor...
asked 29 minutes ago -
calculare the standard deviation of a portfolio that contains 40%
of one stock with a standard...
asked 27 minutes ago -
When exposed to sunlight, a hole in a sheet of copper expands in
diameter by 0.160...
asked 44 minutes ago -
Economists believe that there are many nonmonetary gains from
further trade opening. Which of the following...
asked 46 minutes ago