Databases Questions and Answers August 09, 2021

Using Wide WorldImporters database create a query that returns the StockItemID from the StockItems table in the Warehouse schema, the OrderLineID, Quantity, and UnitPrice from the OrderLines table in the Sales schema, and the ColorName from the table Colors in the Warehouse schema. Take a screen shot of the SQL windows and results and paste it

For each of the following, write SQL statements to create views where needed and to grant the indicated privileges for the University database with this schema Student(stuld, lastName, firstName, major, credits) Class(classNumber, facld, schedule, room) Enroll(stuld, classNumber, grade) a. Give permission to read the tables Student and Class to

The following query is supposed to retrieve all aircraft and pilot information that leave from Perth Airport. It seems to be working but for some reason, one of the flights is not appearing. The missing flight is one where the plane has no copilot. Describe what is going wrong with this query. How would you fix it SELECT p.planeModel, f.flightTo,

Normalise the following receipt to the third normal form (3NF), clearly showing the stages of ONF, 1NF, 2NF and 3NF. Clearly state any assumptions you make about the data shown (e.g. derived fields), and name your final set of relations. Service Request Reference Number 542665 Service Status Resolved Staff Id G2143 Staff Name Harold Gunthorp

Need an er diagram for virtual grocery system with the following functions included 1. Login page( username, password, forget password button) 2. Add product page 3. Make purchases page (show successfully added to basket) 4. Generate invoices (users can click on generated receipts button and the system will show the receipt that they can print or

This data set represents the web server hit logs for a single website for a single day. You're going to do some analysis of the data, but first you need to normalize it properly -- which requires proper keying and indexing. PART II: Keys and Indexes 1. Three of the supporting tables, "log_areas", "log_pages", and "log_referers", use auto-increment

normalize these database. Note In eduction column, the info inside the cell you can ignore. Teacher ID TCFirstname TCLastname TCTitle 1 Yi 2 TING 3 Vannak 4 Gneannak 5 Thearom 6 Sotheara Liv Siteng Seng Da Ret Veng Dr Dr Mr Mr Dr Dr Subjecttaught IE, ED, SE Chemistry Education Bacholor 20052010, ITC International Industrial Business Engineering,

Lakeside Assembly Inc. sells products assembled from parts purchased from various vendors. For each vendor, vendor id, company name, and contact person are stored. Some vendors do not assign a contact person. For parts, part id, part description, and part cost are stored. For products, product id, product name, and selling price are stored. . Name

Using 3 variables, compute and display the number of empty seats in class. There are 13 students enrolled and the maximum number of students permitted is 24. Note: The max number of seats is a constant across all INF lab courses.

Initialize a variable to 'JANE' and a 2nd variable to 'SMITH'. Write the sentence My name is Jane Smith. Use functions to convert the uppercase words to initial capitals only.

A store decides to go High Tech. You are asked to design a database for the store After brainstorming with the store managers. you come up with the followings specification . The store has multiple departments, identified by their names, each department may have many employees but (at most) one of them is the department manager Employees are

Use SH database for this Write a select statement that returns Product name, Customer first name, customer last name, Channel description, and amount sold for all the sales. Make sure to returns sales even if there is no information on the customer, product, or channel Write a select statement that returns channel ids that can be found in both

You are in charge of creating a small database for a store that sells goods so that it can keep track of its customers and their orders. a) Write an SQL statement to create a customer table containing the following information Every customer has a unique ID, that should not be empty and set as the primary key The customers first and last name

Using the Customer Sales list shown above Identify and describe at least three of the following issues that deal specifically with the structure of the database table a) Any problems with unnecessarily repeated (i.e. redundant) data. b) Any problems with atomicity that is columns that store more than one piece of information. For example multiple

Write a SELECT statement that returns the title, artist and unitprice columns from the items table. Return only those items that have a unitprice of at least 16, but less than 17.50 (3 marks) 2. Write a SELECT statement to return all columns from the customers table where the customers state is Ohio (OH). Sort the results by last name in

Create a Horse table with the following columns, data types, and constraints. NULL is allowed unless not NULL is explicitly stated. ID integer with range 0 to 65 thousand, auto increment, primary key RegisteredName variablelength string with max 15 chars, not NULL Breed variablelength string with max 20 chars, must be one of the following

Create the Employee/Department database (script provided below). Write and run a PL/SQL block which produces a report listing world regions, countries in those regions, the population and the currency info for each country. You will need two cursors: an outer loop cursor which fetches and displays rows from the REGIONS table, and an inner loop

14 Eastern Africa by Ann Aksut Federal Democratic Republic of Ethiopia Population 74777981 Currency ETB birr Republic of Djibouti Population 486530 Currency DJF Djiboutian franc Republic of Kenya Population 34707817 Currency KES Kenyan shilling Republic of Uganda Population 28195754 Currency UGX Ugandan shilling Somalia Population 8863338

Using a SET operator, Display all names that are used both as a last name and a first name. Example Taylor Grant, Winston Taylor We want to display the name Taylor because it is used in both columns.,Employees O PK employee id firstname lastname Manages email phonenumber hiredate jobid FK salary commissionpct managerid FK departmentid FK Heads

A new townhouse called "Tulip" is being built that is "Pets-lite". Owners may keep dogs if the canine in question is less than 20 lbs and has no complaints against it. Which dogs are eligible to move into "Tulip"? The data set is below. First Name,Last Name,Breed,Weight,Age,Building,Complaints,Favorite Toy

Execute the provided code. 2. Change the Select statement to use the column name instead of and execute this code. 3. Take a screen shot of the results.,1 BEGIN TRANSACTION 2 3 Create a table called NAMES CREATE TABLE NAMES (Id integer PRIMARY KEY, Name text) 4 5 6 Create few records in this table 7 INSERT INTO NAMES VALUES (1, Tom) INSERT

Organize each variable in the data set into one of the categories in a table as shown below. Add more rows if necessary. Qualitative Continuous Quantitative Discrete Quantitative Looking at the dataset, what two variables do you find critical to the analysis? Explain why. Determine if the data can be used to map where each meteorite

The HOAs of different buildings are considering different dog restrictions. Vine is considering only allowing dogs under30 lbs, but will be grandfathering in dogs over 6 years old. Rose is considering a limit of 20 lbs, but will allow dogs up to 60lbs if there have been no complaints about them. Which dogs will potentially need to move. Which

Return a list of trainees who were hired after 1999 and that earn more than $18,000 but no more than $25,000. Also show any employees who were hired before 1995 regardless of their salary. Show LName, HDate (sort ascending), Salary, and Title for these employees. [Create this query and save it as "Query 6"]

For the CustomerOrder table, identify and list out each of the functional dependencies that exist. 2. List out the primary key(s), foreign key(s) and candidate key(s) for the CustomerOrder table. For this question, you only need to consider the relationship(s) between the CustomerOrder table and the tables within the Orders Schema. Do not refer

Q2 Q3 Q4 Q5 Q6 (X 2Y) 2 10 )2 () (),X737 2 1 4 Y Toom 4 6 3 4

make needed enhancements to the ERD using the concepts of generalization and specializations. Your work must be completed in draw.io and use Chens notation covered in class. Once your diagram is complete, export it to .png or .jpeg format and insert it in your homework document. Hand drawn diagrams are not accepted. a. Improve the design of your

Using the form below and a sample un-normalized table containing all related attributes and sample data, develop a set of database tables that are normalized to 3NF. Then create a corresponding ER diagram (the ER diagram needs to show cardinality/optionality).

clientNo cName property No pAddress CR76 CR56 John PG4 Kay Aline Stewart PG16 PG4 PG36 PG16 6 Lawrence St, 1Jul03 Glasgow rentStart rentFinish rent ownerNo oName 2 Manor Rd, Glasgow 31Aug04 350 5 Novar Dr, 1Sep04 1Sep05 450 CO93 Glasgow 5 Novar Dr, Glasgow CO40 6 Lawrence St, 1Sep02 10June03 350 CO40 Glasgow 10Oct03 1Dec04 375 CO93 1Nov05 10Aug06

List the drinkers who like every beer served at The Swan. The answer should have one attribute drinker. Note that, if The Swan does not serve any beer, then all drinkers should be in the answer. 2. Find the bars that serve every beer Joe likes at the lowest price. The answer should have a single attribute bar.,frequents drinker bar serves bar beer

The given SQL creates a Song table and inserts some songs. The first SELECT statement selects songs released after 1992. The second SELECT statement selects the release year for song with ID 800. Create a third query that combines the two existing queries. The first SELECT should be the outer query, and the second SELECT should be the subquery.

Retrieval of data in SQL can be sped up by the creation of indexes in a table. Explain what an index is and how it works in speeding up data retrieval. Describe one issue that can occur by using too many indexes in a table.

The Book table has the following columns: ID - INT X - INT Y - INT Complete the SELECT statement to compute the square root of (column X), rounded to 3 decimal places.

The Book table has the following columns IDINT XINT YINT Complete the SELECT statement to compute the square root of (column X), rounded to 3 decimal places. SELECT Type your code here FROM Book

Complete the SELECT statement to compute the absolute value of (column X minus column Y), for all rows.

The Book table has the following columns IDINT XINT YINT Complete the SELECT statement to compute the absolute value of (column X minus column Y), for all rows. SELECT Type your code here FROM Book

You are just hired as a database security analyst. CIO asks you to implement the following database policy. The table names created in the CardinalDB database must be prefixed with tb. This is NOT about stored procedures. You must create two conditions. Use the following database and tables for the testing of Task 3 below after you created the

Prepare new user and schema Create new USER and Grant the appropriate privileges to this new USER so that this USER is able to..... CREATE/ALTER/DROP any tables and sequences. INSERT/UPDATE/DELETE data in any table. Have unlimited quota on tablespaces Logon with your new USER account and run the supplied script to create two tables, an Oracle

Find a SQL query that computes a set difference and returns false positive(s) over a database with null values. Show the correctness of your answer using an example.

You are designing a system to crowdsource student evaluations of college courses. As part of this system, you want to store a table of reviews containing the following information (for each review) Review Date Date (3 bytes) Academic Year int32 Academic Quarter char10 Course IDchar5 Rating (0.0 to 5.0) float32 Grade in the course char2

Imagine you are designing a table to store recent transactions for an online shopping platform and there are 1 trillion transactions. You want to record the following information user id user name item id item name transaction id amount of money () for the transaction (e.g. 4.11, 670.50, etc) Assume there are 1 billion users, and 1 billion

Elon decided to give out premium subscriptions for free to some of the users. Consider the following database schema for a social media platform Users User Interest Name Userld FirstName VARCHAR(255) UserInterest VARCHAR(255) LastName VARCHAR(255) PhoneNumber VARCHAR(255) Type INT Name Type INT Userld Write an SQL query that returns the FirstName,

Create a view (virtual table) called good_collaboration that lists pairs of actors who have had a good collaboration as defined here. Each row in the view describes one pair of actors who appeared in at least 3 movies together AND the average score of these movies is >= 40. The view should have the format: good_collaboration ( cast_member_id1,

Please give reallife examples for the following situations An entity set A and an entity set B, with a manytoone relationship An entity set A and an entity set B, with a onetoone relationship An entity set A with a manytomany relationship running from A to itself. 1. 2. 3.

design an entity relationship (ER) model for a library management system. Your ER model should include the following 1.A list of entities and their attributes. (Section 1 of your document) 2.A list of relationships between entities, including the cardinality of each relationship. (Section 2 of your document) 3.A graphical representation of the ER

Write the following questions as queries in SQL. Use only the operators discussed in class (in particular, no outer joins or windows). Again, type your answers. Before starting, make sure you understand the schema of the database. If you are in doubt about it, please ask the instructor. Assume a database with schema

Tourism Track Recommender System Refer to Figure 1 for a high-level overview of the system to be developed. The company for whom you are developing this system wants people to visit local walks that are considered to have touristic appeal. For instance in Melbourne there are several tourism guide books and websites that detail walks that

Social Media (Postgres) Text Blah blah (X1,Y) blah blah Image EXIF data (X2,Y2) Neo4j PostGIS Tracklog Tracklog2 Tracklog3 Mongodb Trip Reviewer Rating Review Recommender System 1. Search for any coordinates from Social Media text and images (simulated by Postgres database) 2. Search for any friendshipsocial media links to other people 3. Insert

Break down this database table to the three separate themes (Players,Team,Stats) into a table for each theme.

Past Years Superbowl Winning Quarterbacks FirstName LastName Age Team Matthew Tom Patrick Tom Nick Tom Stafford 34 Rams Brady 43 Mahomes 24 Brady 42 Foles Brady Buccaneers Chiefs Patriots 28 Eagles 39 Patriots Location Record Passes Los Angeles Tampa Bay Kansas City New England Philadelphia 133. 142 New England 125 115 Passes Attempted Completed

Create an ER Diagram for the movie rental stores. The data of this store contains this information employee number, supervisor, employee first name, employee address, employee phone, hire date, salary, movie number, movie title, description, rating, genre, rental rate, movie url, store number, store manager, store address, store phone, store city,

Hailee Morrison (Customer 211) has adopted a pet llama, gotten married, moved to Alaska (state code is AK), and changed their last name to Stonewall. Edit this customers record to reflect these changes. Include in your submission (1) the query that you would use to make this change to the database and (2) the output of a query that verifies the

Create two tables with the following fields and limit it to 5 rows per table. Please specify data types Table 1 Table 2 Make, Model, Manufacture Date, Cost, Modelid Manufacturer, Modelid, Parts, Warranty Expiry Date, City Populate the table with any dummy data but use appropriate data types for each column Question 5.1 Create a query that returns

List the students (first name, Last Name and GPA) who were admitted in the year 2015. List the Juniors (first name, Last Name and GPA) who were admitted before the year 2015 3. List the Average GPA by Major (Major code is sufficient). 2. 4. List the Average GPA by College. 5. List the College with the least average GPA. 6. List the students with

Draw the schema using SQL Developer after you have created it so you can visualize what you have created. From the drawing indicate the type of schema that you have drawn. All tables except TRANSACTIONS are to have primary keys. That will be 5 primary key definitions and 5 foreign key definitions. All constraints are to be properly named with user

Enroll(stuld, classNumber, grade),if we wish to monitor changes to grade in the Enroll table, we could first set up a table to hold the audit records. What would be the schema for this new table b) Creat a trigger that will audit UPDATES in the column GRADES of the table ENROLL.

Write basic queries against imported tables to organize and analyze targeted data. A. For each query, include a screenshot of the query and its output. You should also include a 1 to 3sentence description of the output. B. Write an SQL query that returns the count of orders for customers located only in the city of Framingham, Massachusetts. i.

The CS department liked your skills in SQL, so they decided to grant you full permission over the database. Students Name Netld Type VARCHAR(8) FirstName VARCHAR(255) LastName VARCHAR(255) Department VARCHAR(255) Enrollments Name Type Netld VARCHAR(8) CRN INT Credits INT Score REAL Courses Name CRN Title Type INT VARCHAR(255) Department

What functions can you use to process data in your database Name at least three functions and at least one of each type, e.g. one string function, one date function, one number function. How are they used in queries Why are these queries important to your business You can choose a random database of your choice, but please make up an answer for

Using the data model giving here, write an SQL statement to create the tables corresponding to the data model. A country can have many official languages in a language can be the official language in many countries each language belongs to a group. country cname official language language group groupname

A Boston-based firm called "Course Hero" is seeking candidates for a number of positions that have become available as a result of their recent business expansion. To enable Human Resources to maintain track of the hiring and interview process, Course Hero must create a database system. Develop an ER model based on the information outlined below.

Display city, province name and postal code for all departments located in countries that start with letter (meaning Italy, Israel and India). If the province is blank, show message Unknownand the heading should be Province. Sort the output by city ascending

Sales Manager Zlotney needs a query to show (a) custno, (b) cname (c) the address1 and (d) the total dollar sales (price qty) and the (e) total number of orders The output needs to go from lowest number of orders to highest number of orders Output will look similar to this row 1040 Vacation Central 2 193 Appledown Rd 7948 NOTE copy all the rows

What is an example of a poorly written query that contains too many join statements. What happens to query performance if we have 4 or 5 join statements in a single query? How can this be avoided?

Using Input.GetString, ask the user to enter the name of the hero to find.Call StartsWith passing the string that the user enters and a ref parameter for the list. Make sure to create an empty list. print out the number of heroes found AND loop over the list and call PrintHero for each hero found.

In Main (here), add code to case 4 of the switch. Using Inp t etStri (see e.amle above) ask the er to enter the are of the hero to fin.. all StartsWith passing the string that the user enters and a ref parameter for the list. Make sure to create an empt, ist. print out the nmber of heroes fo and A Loo, over the list and call. rintero for each

. create an ETL process that will load the Weather tracker data mart using only data flow tasks. A measurement representing the temperature difference must be added to the fact table (outside of SSIS, nothing to do with ETL) The file to load is provided (larger version than the one used previously) Option 2 Load a data mart built from Northwind

Add the following data to the FEE table.

Billy Elliot was charged last year on Jan 20th. He is a student at Queens University and paid the student lower rate of 30 per day. Because he is a loyal guest he didnt need to pay a deposit on Jan 20th. (this means you need to store a record showing the guest was charged a deposit of 0.00) Justin Hackman paid last year a discount rate of 35 per

An online record store needs a database to track sales of vinyl and compact disk music products. The stores website tracks customers by name, address, phone number, email address, and Twitter () name. The store maintains a list of records and CDs (products) that are in stock by their bandartist name, album title, year released, and price. Online

Consider the schemas and instances below. prod should be prodid . . dep should be depid. . The primary key of product is prodid. The primary key of depot is depid. The (composite) primary key of stock is prodid, depid. prodid in stock is a foreign key referring the primary key prodid in product. . depid in stock is a foreign key referring the

State the minimum normal form that a relation must satisfy, including a definition for this normal form, describe the characteristics of a table that violates the first normal form (1NF), and explain how such a table is converted to 1NF. Describe a way in which a 1NF table can be converted to a second normal form (2NF) table(s). Explain what is

Why do we say that there are several SQLs Provide a concrete example comparing MySQL and PostgreSQL. You can look at the most common types in MySQL and PostgreSQL. General answer Comparison SQL in MySQL Exercise 2 SQL in PostgreSQL What isare the differences between the VARCHAR and CHAR types

Using SQL, solve the following queries based on the projects, employees. Workon, and rate tables discussed in the class (shown below). Note that the tables contain sample records only and do not represent all the possible records that could be stored in these tables. PROJECTNUMBER 1 2 185 projects PROJECTNAME PROJECTCITY Eagle NY Super Jet LA 20

Make a SELECT statement that returns the GuestID from the GUEST table 1. Add the tables SERVICE and FEE. JOIN them in your query. 1. Use WHERE and the IN operator to filter the service names room rate, damage, and room service 1. Add the GROUP BY so that aggregate functions are calculated for each GuestID 1. Add the returning column

Write a stored function that takes an employee id as input and returns how long (in years) an employee has been a part of the company. For convenience, we have provided an attribute in the employee table called 'joiningDate'. Use the function to write an sql query that lists down all the employees and their associated duration of employment.

A hospital is conducting a double blind test of a new depression drug. It will involve about 20 doctors and about 400 patients. Half of the patients will get the new drug and half will get traditional Prozac. Neither the doctors nor the patients will know who is getting which drug. Only two test supervisors will know who is getting what. The test

Jeddah Car Services Company provides transportation services with drivers for passengers within cities. The company needs to build a database to keep track their activities data. There are two types of employees in the Jeddah Car Services company including a driver and an operator. Each employee is assigned a unique id, and other details of the

Draw a star schema, in the form of an ER diagram, using the data contained in Figure 1. Include fact table, dimension tables, characteristics, key figures Hint: The dimension tables should be - Customer, Store, Department, SKU, Time, TransactionInfo, Unit Show the relationships Show the keys Suppress the datatypes.

Figure 1 Below is the list of tables in this database, and the number of records in each table TABLE NAME CUSTOMER Nitin Kal Nancy Jones 2021 Star Schema DEPARTMENT SKU SKUSTORE STORE TRANSACT CUSTOMER TABLE Column name CUSTID CITY STATE ZIP CODE ZIP SECSEG DISTANCETONEAR ESTSTORE Column name NUMBER OF RECORDS 75,544,740 DEPT DEPTDESC 580 DEPTDEC

Draw a star schema, in the form of an ER diagram, using the data contained in Figure 1.

1. Include fact table, dimension tables, characteristics, key figures Hint The dimension tables should be Customer, Store, Department, SKU, Time, TransactionInfo, Unit 1. Show the relationships 2. Show the keys 3. Suppress the datatypes.

Explain the benefits of a database compared to a workbook or spreadsheet. (Minimum of 100 words) 2. Describe why businesses uses databases. (Minimum of 100 words) 3 Identify the main parts of a database. 4. Build a database to inventory home items for insurance purposes.

Convert Part 1 Relational Schema into a MySQL table. You can assume every attributefield is an INT UNSIGNED NOT Null. Using relational structure notation, please transpose the ER diagram below Create the Relational Schema. 2 P 1 3 4 A 9 Part1 Write the Relational Schema A(2.3.4.5.6.8) 5 8 6 Convert Part 1 Relational Schema into a MySQL table. You

Draw a data model for the following situations. In each case think about the names you give each entity. 1) A Spelling Bee can have many competitors, and a competitor can compete in more than one Spelling Bee 2) A teacher can attend more than one workshop, and the same workshop can have more than one Teacher.

In the following COURSE table, the attribute PREQUISITES is a multi valued attribute. A course may have zero or more prerequisites and the same course may be the prerequisite of zero or more other courses. Draw a Crows Foot ERD to show your solution for a design that properly addresses this multivalued attribute issue. COURSE PK COURSEID

Display product ID, product name, and category ID for products of the category(s) that the lowest price product belongs to. 1. Write a SQL query to display the last name and hire date of all employees who were hired before the employee with ID 107 got hired. Sort the result by the hire date.

You must create database design in MySQL Workbench and create a short PDF report presenting your design. Your design must be a single-entity design for the provided specification. This is a CLOSED BOOK assignment, and you are not allowed to use any external information to solve it. Be sure that you use the description that was assigned to you.

Write a SELECT statement that returns these columns from the Brands table The Date Added column A column that uses the CAST function to return the DateAdded column with its date only (year, month, and day) A column that uses the CAST function to return the Date Added column with its full time only (hour, minutes, seconds, and milliseconds) A

This is a purchase order processing database of Boston Shoes company. The company produces shoes and sells them to various retail stores. The following is a description of the order processing database and other relevant information. 1. The customers of Boston Shoes are retail stores, such as Walmart, Target, Kohls, etc. Each customer has one

What are the tools available to do the web application testing? Listed down and select any web application tool and try to find out what the features are and how to use in testing? username" & "password" fields then what are the things required to perform the SQL injection How to prevent SQL injection attacks? Difference between encryption,

User ID Password Login

Sometimes a data retrieval task can be accomplished using different querying techniques. For instance, creating a query that uses data from two different tables can be achieved through using a sub query, or a join operation, or creating a view and using the view as a table in another query. Think of a task, describe what the task is and how it can

below is a list of SQL Commands Queries. You could choose any of these or any other that is not listed here. If you choose for instance SELECT what data would you be interesting selecting and extracting SELECT extracts data from a database. UPDATE updates data in a database. DELETE deletes data from a database. INSERT INTO inserts new data into

Refer to the customer and staff tables of the Sakila database. These tables have many columns in common and represent similar entities. Convert the customer and staff entities into subtypes of a new supertype person: https://static-resources.zybooks.com/zyLab/SQL/supertype+entity.5.png The diagram uses Sakila naming conventions. Follow the

Your e-commerce business is growing fast. You currently have the Standard Edition of Oracle 12cR2 on your servers, which are having difficulty keeping up with your current load. What is a recommendation letter describing a solution to this problem. description License cost per equivalent CPU number of licensed servers total number of CPUs Total

Write query for the following situation? Management is considering closing on Sundays and would like to have a feeling for the kinds of customers that come to the dealership on Sunday. Creating totals query that shows the count of encounters on Sundays of July, 2015--grouped by the credit description held by the customer of the encounter. The

List the zip codes in the following counties and their of households in 2018 Clark County (NV), Los Angeles County (CA), and Maricopa County (AZ). You do NOT need to list the county name in the results, but you should sort the results from most to fewest households. (Also, as context for this query, you have family that live in these counties.

A continent is made up of countries but some countries span more than one continent. A country is made up of states or provinces but provinces cannot span more than one country. Map the ER diagram below to a set of tables. Be sure to use the proper text format for tables TABLENAME(primaryKeyAttributes, attribute1,attribute2,...

Executing Insert, Update and Delete is an instance operation. You might delete a table that you did not intend to. What are some practices that you can deploy to prevent accidental changes to the tables?

Fred Campbell asked for a transfer from the Shipping department to the MKT department. His request was approved. Update the database to reflect this change.In the answers document, the whole manager_id clause should be deleted.

WRITE PLSQL CODE Problem 1) Code a loop that displays the values from 1 to 3. Code it 4 times (1) FOR (2) WHILE BE VERY CAREFUL TO NEVER EVER CODE AN INFINITE LOOP! BE VERY CAREFUL TO NEVER EVER CODE AN INFINITE LOOP! (3) basic with EXIT WHEN (4) basic with IF used to exit

SET AUTOCOMMIT ON under the comment header and execute it Consider the following table specifications Part A (DDL) 1. Create table the following tables and their given constraints L5 MOVIES (movieidint, titlevarchar (35), yearint, director int, score decimal (3,2)) PK Not Unique FK Default Validation Null Value Column Column Name mid title Data

Im going to a wedding between a Slovene and a Moldovan and have been asked to choose between fish and wild boar as my reception entre options. The Slovene family is a little richer and will be providing the white wine and likely targeting the 2025 range, while the Moldovans will be trying to keep it under 15 for the reds. Both want their countries

Mary and Mike Miller own a chain of Mini dealerships throughout Colorado. They have used systemsin the business for several years to handle payroll, typical accounting functions, and customer order entry. Because of the dealership's expansion both in the number of used car locations and the number of cars handled, they need a relational database

Create a stored procedure called WhoAmINow that does the following 1. Prints out Todays Date (10 Points) 2. Prints out the Session User (10 Points) 3. Prints out the OS User (10 Points) 4. Prints out a the variable My Name that is passed to it from the procedure call

Identify issues regarding managing data at the Social Media Industry and its impact to the business. Provide a planning document for viable database solution to resolve issues at given business. Assignment Project document for social media industry regarding managing data Following is the template for Project Scope document Executive Summary

What are to pro and cons of The query engine and the storage engine? how do the query engine and the storage engine relate to data availability, databases, and file redundancy?

When it comes to demoralizing a table, what program is used The table is tblstate contains (stateid,statename) tblcounty contains (contyid,countyname) tblcity contains (cityidcityname) query the most efficient. make the

List the number of requested clinical tests and the average unit cost of these tests, per diagnosis. Order the list in descending order of diagnosis and then the number of requested clinical tests.

Clinical Tests TestID 1 Name RequestedClinical Tests ConsultationID TestID Description UnitCost 8 Physician FirstName LastName ID Specialty Phone Salary Date Result 1 Medication ConsultationID Medication ID Dosage DosageUnit Quantity UnitCost 1 Medicine MedicationID Name Indications Contraindications Consultation ConsultationID PhysicianID

Describe the architecture with the master and slave database environment cluster. What was it like before MongoDB and what was it like after o What type of NoSQL database was implemented and how much data was it intended to encompass Question 2 What was the length of time it took to run the ALTER table query that the speaker referenced when