he MongoDB shell is an interactive ______interface to MongoDB. You can use the mongo shell to query and update data as well as perform administrative operations.   A. NodeJS   B. JavaScript   C. C   D. SQL

What's "metadata"? Metadata in a dataset: Metadata from a result set—useful?

In Visual Basics, Does a row in a Database table represent a record or a field ?

Describe the advantages of using data binding in user interface development.

QUESTION 21 Code a chain of MongoDB methods that    retrieves documents from MondoDB collection named WEB322 the only documents that are selected are the ones with value 211 in the semester field  the only fields of the selected documents that are retrieved are firstName and lastName make sure the _id field is NOT retrieved sort the selected documents by lastName in ascending sequence store the result to an array named result assume the connection between the program and database had already been established and the name of the database object is db

import sqlite3 from sqlite3 import Error # Creates connection to sqlite in-memory database def create_connection():     """     Create a connection to in-memory database     :return: Connection object     """     try:         conn = sqlite3.connect(":memory:")         return conn     except Error as e:         print(e)     # YOUR CODE HERE     # Use sqlite3.connect(":memory:") to create connection object     return conn # query to create the table table_sql = """ CREATE TABLE Horses (     id integer PRIMARY KEY NOT NULL,     name text,     breed text,     height real,     birthday text ); """ # query to insert data into the table ins_sql = """INSERT INTO Horses VALUES(1,'Babe','Quarter Horse',15.3,'2015-02-10'); """ # query to fetch all data from the table fetch_sql = """SELECT * FROM Horses;""" # creating db connection conn = create_connection() # fetching a cursor from the connection c = conn.cursor() # executing statement to create table c.execute(table_sql) # executing statement to…

Code a chain of MongoDB methods that   retrieves documents from MondoDB collection named WEB322the only documents that are selected are the ones with value 211 in the semester field the only fields of the selected documents that are retrieved are firstName and lastNamemake sure the _id field is NOT retrievedsort the selected documents by lastName in ascending sequencestore the result to an array named resultassume the connection between the program and database had already been established and the name of the database object is db

Answer the following prompts 1The InstantRide Management team founded a new team for car maintenance. The new team is responsible for the small maintenance operations for the cars in the InstantRide system. The main idea is to take actions faster and minimize the time spent for the maintenance. Therefore, the Car Maintenance team wants to store MAINTENANCE_TYPE_ID (char(5)) and a MAINTENANCE_TYPE_DESCRIPTION (varchar(30)) in the database. Using MAINTENANCE_TYPE_ID as the PRIMARY KEY, create a new table, MAINTENANCE_TYPES, and send the table description with the column names and types to the Car Maintenance team. 2The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENANCE_TYPE_ID…

Population Database   Compile and run CreateCityDB.java which will create a Java DB database named CityDB. The CityDB database will have a table named City, with the following columns: CityName & Population. Their Data Types: CHAR(50) Primary Key & DOUBLE. The CityName column stores the name of a city, and the Population column stores the population of that city. After you run the CreateCityDB.java program, the City table will contain 20 rows with various cities and their populations. Next, create an application that connects to the CityDB database and allows the user to select any of the following operations: Sort the list of cities by population, in ascending order. Sort the list of cities by population, in descending order. Sort the list of cities by name. Get the total population of all the cities. Get the average population of all the cities. Get the highest population. Get the lowest population.   CreateCityDB.java import java.sql.*; /**  This program creates the CityDB…

Scenario and Database Model: InstantRide InstantRide is the new ride sharing application in the city and it has just started its operations. With the help of the InstantRide mobile application, the users request a ride with their location. Drivers and cars are assigned to the request; and then the driver picks up the user to ride their requested location. Information for the users, drivers and cars are stored in the database as well as the travel transactions. In the USERS table, information for the users are stored with their first name, last name and email:   In the DRIVERS table, all the drivers in the InstantRide are stored with their name, driving license number and check and rating information:   In the CARS table, all the cars in the InstantRide system are kept with the license plate, model and year:   Finally, the transactions of the rides are stored in the TRAVELS table. For each travel, start and end time with location are stored. In addition, the involved driver, car and…