Databases Questions and Answers August 10, 2021

Create a PLSQL block that uses data in the company database to do the following tasks 1) Retrieve information about an employee and print it as follow Current Salary Employees SSN Name Department Number Department Name Managers Name Current Salary The program should assign a value or prompt for employees SSN (such as 123456789, 333445555, or

COACHBOOKING(COACH TRIP, COACHDATE, COACHCITY, COACHMILES, COACHMAXPAX, DRIVER, ASSTDRIVER, MECHANIC, BAGGAGEHANDLER, CUSTNUM, CUSTNAME, LICENCE PLATENO, BUSMODELCODE, BUSMODELSEATS, BUSMODELCHGMILE) Based on the information provided above, perform the necessary Normalization, up to 3NF, and express your answers in textual relational schema format

Bountiful Contract Jobs (BCG) is a recently incorporated job placement agency that specializes in hiring staff for different projects. BCG operates in a niche market of hiring IT staff, to be placed in non full time, contractual IT projects from different companies. BCG has contacted you to create a conceptual model to represent the database

ROOMNO FLOOR NO BLGDNAME POSTAL CODE DESCRIPTION SEATING CAPACITY a) ROOM b) (PK) (PK) (PK, FK1) (PK, FK2) consider the ENTITIES below. BUILDING BLGD NAME POSTAL CODE STREET MANAGER NAME MANAGER TEL (PK) (PK) In terms of relationship strength between ROOM and BUILDING, is the relationship weak (nonidentifying), or strong (identifying) Explain your

Create query that returns the total number of sales of products in the chocolate category made by each salesperson. Include in your results only the salespeople that have sold at least 9 items

Write queries to answer What is the average capacity of the stadium where players who make over 10 million play What stadiums are not associated with any teams in the Teams relation Players Name Sidney Rice Peyton Manning Champ Baily Russel Okung Wesley Woodward Jared Allan Salary Stadiums Name Sports Authority LP Field CenturyLink Field TCF

Consider the following schema CREATE TABLE Player ( name varchar(50) PRIMARY KEY, birthdate date ) CREATE TABLE Tournament ( name varchar(50) PRIMARY KEY, prize int ) CREATE TABLE Match ( winner varchar(50) REFERENCES player (name), loser varchar(50) REFERENCES player (name), tournament varchar(50) REFERENCES tournament (name), played on date NOT

Create the necessary tables in the SQL statements as part of your word document. In an apartment complex, a resident can have many pets, but a given pet can have only one resident as its owner. Draw an ER model to represent this relationship. A resident is identified by an apartment number, name, lease begin and lease end dates. A pet has its

Display the TERMDESC, COURSENAME, BLDGCODE and ROOM for every course evertaught by faculty member John Blanchard. Question 2 Display the SLAST, SFIRST, COURSENAME, TERMDESC and GRADE values for everystudent taught by faculty member John Blanchard. Question 3 Display SLAST, SFIRST, COURSEID, COURSENO, COURSENAME for all course takenby Daniel Black.

Using table definition below write SQL statement(s) to record in the database selling product number Dw11 to customer number 148. (4) Table customer CNUM Table ORDERS ORDER NUM Table orderline Table part PART NUM AT94 21608 21610 21613 BV06 DL71 DR93 DW11 FD21 148 282 356 Fergusons 842 All Season KV29 CNAME Als Appliance and Sport Brookings Direct

We have a set of 3600 data points representing transactions on a sporting goods ecommerce site. The support of (tennis balls) is 600 transactions, or 0.1667 The support of (tennis racquet) is 300 transactions, or 0.0833 The support of (tennis balls, tennis racquet) is 200 transactions, or 0.0556 Consider the association rule with tennis balls as

Passenger table (passengerid, address etc.) Flight table (flight id, departure, destination, depDate) Booking table (cID, fid, date, cost) a. Find Passengers who live in Chicago b. Total number of bookings by month of the flights departing at Chicago c. Which flight earns the most d. What is the difference between number of flights booked to

The course is defined as a section. For instance, a course NUR567, can have multiple sections, and each section can have many students, but a student can be enrolled in one only one section. A section is identified by courseid, sectioned, semester, year, and begin and end dates. Assume that students are defined by student ID. student name, major,

A music album has a lead artist. A lead artist can have multiple albums. An album must have a lead artist, but a lead artist can exist (as in preproduction) without any albums. The attributes of a lead artist are name, address, city, and agent telephone. An album has a product code, production date, and price. One Liner A lead artist has albums ER

FLYPLANE is a company that leases out private planes to various company executives. And it has a set of pilots on its list. Each pilot can fly at most three planes, and a plane can have an unlimited number of pilots eligible to fly. A plane has a model number, the number of hours flown, the date it was installed in service, and the next service

Create a PLSQL block that selects the maximum department ID in the departments table and stores it in the vmaxdeptno variable. Display the maximum department ID. a. Declare a variable, vmaxdeptno, of type NUMBER in the declarative section. b. Start the executable section with the BEGIN keyword and include a SELECT statement to retrieve the maximum

A written scenario of at least a page and a half describing a hamburguer restaurant that you we plan to model and, why that is an important area to work in. Your database should be designed to answer the questions or aid in decisions. So, within your scenario, list at least 8 questions your database is designed to answer. A data/information

Create a database named cis224midterm with an addresses table with the following AddressNo (autoincrement, primary key) First (25 characters, not null) Last (30 characters, not null) Street (100 characters, not null) . City (25 characters, not null) State (2 characters, not null) Zip (10 characters, not null) The ecpiuser should have access to the

Create the following tables using SQL Developer, based on the given data types and constraints. Please note that you must study the structure of the tablescolumns thoroughly and create the tables using SQL queries. Name ADMIN Admin D LastName FirstName AManager D AGREEMENT AgreementNbr GrossAmount AtSource TaxWithheld EventID Contractio ARTIST

complete the SQL statement below. A table called tickets tracks the number of tickets sold each day at a movie theater. (Each row represents a different day.) The statement should create a new column called ticketsyesterday that includes the ticketssold from the previous day. Within this statement, in addition to this new column, include the

SQL Code to create the Hotel Reservation, entity (tables) with all the constraints SQL Code to insert, delete and modify the tables Insert, delete and modify for each table. Take into account the constraints Sample SQL codes (minimum 2) to retrieve data from tables

Research the metrics that will be useful for the organization or industry that you want to work for in the future (i.e. supply chain, medical, production, retail, etc.). Make an essay that fits these into the FUVW C PRR structure or modify that structure to, or build a new structure that organizes the metrics. Make an about why the metrics measure

SSB would like for you to perform a detailed analysis of data contained in SAP using Access. Accordingly, the SAP database administrator has created the attached data mart for you to use. The data mart is in a small subset of the overall data contained in SAP and has been sent to you as an Access database. The database contains sales orders for

An electricity supply company needs a database to record details of solar panels installed in its customers homes so it can estimate how much solar energy will be generated based on the forecast level of solar radiation for each houses location. A solar panel has an area, measured in square meters, and an efficiency expressed as a percentage

The relational schema shown below is part of a hospital database. The primary keys are underlined. Formulate SQL statements to solve parts i iv. Patient (patientNo, patName, patAddr, DOB) Ward (wardNo, wardName, wardType, noOfBeds) Contains (patientNo, wardNo, admissionDate) Drug (drugNo, drugName, costPerUnit) Prescribed (patientNo, drugNo,

The table shown below displays the details of the roles played by actorsactresses in films. dirNo Happy Days D101 D101 D101 D076 D076 Sue Ramsay A1222 film No fTitle F1100 F1109 Snake Bite actorNo aName director Jim Alan Jim Alan A1020 Sheila Toner A1222 Peter Watt A1020 Sue Ramsay A1567 Jim Alan Sheila Toner Steven McDonald Peter Watt role Jean

For database insertRecords.sql, do the following database queries. For each query, take a screenshot for the query result and the screenshot is to include the SQL script window as well. Before finalising your answers, refresh your database by reloading createTables.sql file provided and, if necessary, so that the results are uniform across the

Write an SQL statement to add a new car to the cars table. You have the following information for the customer. Ford, Bronco Sport, Red 23,000KM, 2022, 36,000 Slightly used vehicle

The table below shows the current data for customer Jack Ryan. Write an SQL statement to change the email address to jackryan.com and her cell number to 5555671234 Customer Data for Zoe Chloe id 1254 fname Jack Iname Ryan streetnum 231 street city prov pcode tel cell email Main St. Furgusburgh NF Q7E 2R4 7852313426 7853761289 jackryan12gmail.com D

Write a SELECT statement that will retrieve the sale date, sale price, salesperson first and last name, customer first and last name. format the names last. F.

Create a semantic object model for a pizza order. The order will have a phone number which will uniquely identify it. It will also have an address to where the pizza is to be delivered (a group attribute). Finally, it will have one or more pizzas, another semantic object. Each pizza will have an order number that uniquely identifies it (distinct

The Return on all Ords Data: Date 30-Day Bill Rate Rm RAMP RHVN RSUN Jan-13 Feb-13 0.0433 -2.8439 3.0075 27.0408 6.3208 Mar-13 0.0375 0.1029 -4.9270 9.6385 7.1231 Apr-13 0.0300 3.7953 6.0890 9.8901 9.8139 May-13 0.0233 -4.9121 -4.0741 -14.9717 -3.9291 Jun-13 0.0250 -2.8383 -17.9537 1.5937 -4.4106 Jul-13 0.0192 5.4486 6.3529 4.3138 7.5503 Aug-13

Make a semantic object model for a pizza order. The order will have a phone number which will uniquely identify it. It will also have an address to where the pizza is to be delivered (a group attribute). Finally, it will have one or more pizzas, another semantic object. Each pizza will have an order number that uniquely identifies it (distinct

Draw ONLY an UML model for the data requirements described in the scenario below: (Please clearly state any assumptions you made in your design.) Attracted by the success of Spotify, a group of students want to build their own music-streaming website called Musicmatic. Being economists, they are unaware of the specificities of databases and have

Make a MySQL command that will display the population of Algeria. 2 Make a MySQL command that will display the per capita gdp (gdppopulation) for each name where the area is over 5,000,000. The column name of the gdppopulation should be Per Capita GDP. 3 Make a MySQL command that will display the name and continent where the area is less than 2000

The query is supposed to output the total number of products that cost more than 9.99. ( use... >, where, from, price) 2-Write a query to display the first_name and last_name of all records in the contact table 3-Write a query to display the full_name of records in the contact table with full_name of Smith anywhere in the field. 4-Write a query

CREAT A DATABASE THAT HAS AT LEAST 10 TABLES. BUT DON'T USE SHOES, USE SOMETHING LIKE CARS ETC. THE BELOW REQUIREMENT IS JUST AN EXAMPLE, PLEASE DON'T CREATE A TABLE FOR SHOES. CREATE SOMETHING LIKE DEALERSHIP. SAME FORMAT BUT DIFFERENT TABLE NAMES 1. Managers can buy shoes from manufacturers; thus you need tables to store when, where, what and

Select the sampdb database and use the tickets table for the following queries. Write queries that answer each question below. Submit BOTH your SQL statements AND a screen shot of the results. Please make sure that your SQL statements are very clearly legible and screen shots are not too small. Question1 What are the 10 tickets with the highest

Write a select statement that returns 3 columns VendorName BalanceDue (calculated column that displays balance owed on an invoice) TermsDescription Filter the results to only return rows where the balance owed in less than 10000 and TermsID is equal to 3. Sort the results by Vendor Name and BalanceDue from largest to smallest.

Draw ER Diagram The manager of a restaurant wants to keep track of stock level of items so that an order is placed with the supplier in case there is shortage of items. The suppliers detail consists of name, address, contact number, the items that they supply and the price. Note that the same item can be supplied by different suppliers, and an

The following show the tables and sample data of Bundoora Clinic. The PATIENT, DOCTOR, and NATUROPATH tables store the list of patients, doctors, and naturopaths respectively. PATIENT DOCTOR table stores the information of the relationship between patients and doctors. VISIT table stores information of patients visit to the clinic including the

The following show the tables and sample data of La Trobe Airline. The PLANE and PILOT tables store the list of planes owned by the airline and the pilots working there respectively. PASSENGER table stores the information of the passenger flying with the airline. FLIGHT table stores information of the flights. This table includes information about

Describe a concrete example of the cleansing of data from existing databases for a data warehouse. Show possible reasons for which extracted data should be cleansed and how should this be done.

For each of these scenarios, draw an ER model, clearly denoting maximum and minimum cardinality constraints. Write the one liner and four sentences for each diagram (statements that specify the minimum and maximum cardinality), and the number of tables needed. Post the Primary and foreign keys and any available attributes. Your diagram must be

.Write the codes and execute an anonymous block that declares and populates an INDEX BY table ofcountries in South America (regionid 5). The table should use countryid as a primary key,and should store the country names as the element values. The data should be stored in thetable in ascending sequence of countryid. The block should not display

Refer to the table and field names below for this database. SALE Column Name Condensed Type Nullable Sale D SaleBuyer D SaleDate BUYER int int datetime No No No Column Name Condensed Type Nullable BuyerlD int BuyerLastNa... char(20) BuyerFirstNa... char(20) BuyerAddress char(30) BuyerCity char(20) char(2) BuyerState BuyerZIP char(10) BuyerPhone

Make a APEX SQL query in the SQL Commands window that JOINS the CUSTOMER table to the ORDERS table. The result set will be made up of these columns CUSTOMERID, FULLNAME, ORDERID, ORDERDATETIME and ORDERSTATUS. Only display the rows where ORDERSTATUS is COMPLETE. Use the tochar function to show the ORDERDATETIME in the MMDDYYYY format.,EB CUSTOMERS

Is the braking speed different when individuals drive while intoxicated or while talking on a cell phone This study takes place on a car driving simulator. We opted to ask the 5 participants to come to the laboratory twice. During a session, car driving was performed at the same time as the driver was talking on the handsfree cell phone. At the

Department 10 typically has 50 employees. a PLSQL program to count the number of current employees in the department and how many employees need to be hired to bring the count to 50. Your solution MUST (1) Declare a variable to hold the count of current employees (vnumempl), a variable to hold the number to be hired (vnumhire), and a constant to

Use diagram below to answer questions Is there a main effect of the confederate's gender? Question 2 Is there a main effect of the participant's gender? Question 3 Is there an interaction: Does the effect of the participant's gender depend on the confederate's gender?

Participant Mean Participant Mean Confederate Male Female Male 40 70 55 Heres the same table with different data. (Assume any differences are significant.) Male Female 50 60 55 What effects do you see 45 65 Confederate Mean Male Female Mean 60 50 55 Female 50 60 55 55 55

The Driver Relationship team wants to create some workshops and increase communication with the active drivers in InstantRide. Therefore, they requested a new database table to store the driver details of the drivers that have had at least one ride in the system. Create a new table, ACTIVEDRIVERS, from the DRIVERS and TRAVELS tables which contains

Sometimes besides primary key and foreign key constraints, you need to create other types of constraints in your database. What unique constraint and check constraint should you create in your database Why are they important What index should you create in your database Why is it important

Let the following relations represent a fact table, Orders, and associated dimension tables Customers, Salespeople, and Products. Draw a star schema for this data? Pivot the cube to show orders placed by customers and salesperson, with product as the third dimension. The visible face should be for product 1?

custId 101 101 101 102 102 102 103 103 prodId 1 2 3 1 2 3 1 2 Orders sales PersonId Quantity 10 11 10 11 10 10 11 10 20 8 15 10 12 15 9 40,custId 101 101 101 102 102 102 103 103 prodId 1 2 3 1 2 3 1 2 Orders sales PersonId Quantity 10 11 10 11 10 10 11 10 20 8 15 10 12 15 9 40,custId 101 101 101 102 102 102 103 103 prodId 1 2 3 1 2 3 1 2 Orders

What is the support for the association rule bread milk? What is the confidence for this rule? What is the support for the sequential pattern {bread} {butter}? What is the confidence for this pattern? Add some items or transactions that will yield a new association rule with both support and confidence of at least 50%.

1 2 3 4 Trans No CustId Date Jun 06 Jun 06 1010 Jun 06 1020 Jun 06 1025 Jun 06 1030 Jun 07 1000 Jun 07 1005 Jun 07 1030 LO 5 6 7 8 Time 10 11 12 13 14 10 11 13 1000 Market Basket bread, milk, juice coffee, milk bread, butter, milk) bread, eggs milk, juice butter, meat paper towels, juice butter, paper towels

Create a stored procedure. The requirements are: The user would like to see the most valuable supplier by finding which supplier provides the highest number of individual products to the company. The results should show the company, the last name and the state of the supplier in addition to the number of individual products supplied by the

Employees EmpID LastName FirstName Job Title Phone Products 8 ProductID ProductCode ProductName Description CategoryID StandardCost ListPrice ReorderLevel TargetLevel Discontinued Supplier D Suppliers Supplier D Company LastName FirstName BusinessPhone City State 8 Purchase OrderDetails Order Detaill D Purchase Order D ProductID Quantity UnitCost

Make a Class Diagram Your friend has a series of rental properties and has asked you to put your ITSD skills to use to build her a booking system. After interviewing her, you generate the following summary of requirements: Each property will have a landing page that displays the name of the property, its address, the number of beds and

Availability company Name Java.String getClientCampaigns () Object Property companyName Java.String getClientCampaigns () Object Booking companyName String getClientCampaigns () Object

Display the rental id, inventory id, and rental dates for all rentals that were rented on the day 20050705. Sort the results by rental id. a) Show the SQL query. b) Run the query in MySQL, How many rows are returned c) List just the first 2 rows from the results of the query. (You can cut and paste the query results Otherwise, you can also type

Show the product names, quantity, price, and total (quantity*price) for all OrderDetails records where the customer has customer id 2 or 4. Sort by customer name. (need Customers, Orders, OrderDetails, and Products by using Northwind ER Diagram. https://en.wikiversity.org/wiki/Database_Examples/Northwind#/media/File:Northwind_E-R_Diagram.png

The Marketing department wants to know out of all our customers listed in the customer table, exactly, how many customers have not placed an order? Use a sub-query for this question.

DISCPERC ORDERS ORDERNO REPNO CUSTNO ORDERDT STATUS CHANNEL PRODUCTS PRODNO PRODLINE PRODTYPE PRODNAME PRODCOST PRODSELL STATUS PICTURE SALES2016 SALES 2015 SALES 2014 SALES 2013 SID SUPPLIERS Loading...

Develop ERD for We have a number of teams in the NFL, and each team has a name, main stadium, and city to which it is assigned. There are numerous players on each team, but they can only play for one team. Each player has a number that serves as a unique identifier in addition to his name, DoB, start year, and shirt number.

Develop an Entity Relationship Diagram for There are many employees at a company. We have an employee id, which is a special identification number, together with each employees name, address, and birthdate. The business is working on several projects. We have a project id, a special identification number, a project name, and a start date for every

Luxuryforyou has car experts called Sales Agent1 that interact with individuals (called Sellers) who would like to sell their cars to Luxuryforyou. A seller can sell many cars while Sales Agent1 can be involved with multiple sellers. The make, model, miles, color, and any additional feature of a particular car that a seller is trying to sell needs

Write a SELECT statement that returns one column from the Customers table named fullname that joins the lastname and firstname columns. Format this column with the last name, a comma, a space, and the first name like this Doe, John Sort the result set by the lastname column in ascending sequence. Return only the customers whose last name begins

Implement the following ER model and sample data using Oracle SQL Developer and your CDM Oracle database account. You will submit a SQL script file and its entire outputs. CustomerID Customer Name 1 places OrderID M Order Date ProductName,Customer The table name should be CUSTOMERS (plural). Each CustomerID should be a 3digit number. Names should

Consider the following relation schemas. The primary keys are underlined. All attributes are of type string if not indicated otherwise. Use multistep and multiline queries to ease the formulation of queries. Use the rename operator p to give intermediate query results a name (some textbooks use the equivalent notation). Aggregate functions as you

Use ftable function to prepare the pivot table of training set with Online as a column variable, CC as a row variable, and Loan as a secondary row variable with a command like ftable(Credit Card, Personal.Loan, Online) The table you will return will be like ftable(Credit Card, Personal.Loan, Online) Online 01 Credit Card Personal.Loan 0 0 793

Using DB, please convert below RA into SQL statements. Copy and paste sql statement and the result tables. (a) o maxRent 400 (Client) (b) branchNo, postCode (Branch) (c) o Client.clientNo Viewing.clientNo ( clientNo,lastName (Client) T clientNo,propertyNo (Viewing)) (d) city (Branch) t city (PropertyForRent) (e) city (Branch) U city

This table includes generic information about every course. It does not include information about offerings, only courses. 2. Time Dimension This table uses semesters to mark the pass of time. Because semesters may have names that are not sequential (the database may not know that Spring 2020 comes before Fall 2020), a surrogate TimelD attribute

4. Use a SAS data step, and the Libref name from 3. to read in the dataset cars.sas7bdat from your SASDATA folder creat a Proc Means of the dataset, with a VAR statement including only the numeric variables that are NOT indicator variables . What are the mean values for all the numeric variables . cars.sas7bdat PROC SQL CREATE TABLE WORK.query AS

Table name TRAINING INSERT TIMES TAMP ID 1 2 m 4 5 6 20230204 103312 20230205 153002 20230206 202652 20230208 122342 20230209 62032 20230210 111703 WORKOUT DATE WORKOU WORKO TTYPE UT DUR ATION 1122023 Running 10534 132023 Please review the proposed data structure and answer the questions listed below. 222023 1013202 3 g Swimmin 02210 0.5 Hiking

Consider the below schema of a table that describes a pet store purchase id custi custn pet nam d ame e storena me custid custname petname petprice pet price The table is in first normal form. This domain has the following functional dependencies purchaseid, petname qty purchaseid storename, purchasedate, custid, custname purchase date C. a.

Imagine that you have been assigned to a team that will be developing an inventory tracking system. As part of the project startup, your manager has asked each team leader to bring a basic work plan to the next meeting. At that meeting. these work plans will be analyzed to determine the overall project timeframe, costs, personnel requirements and

Each district will include parents, teachers, and administrators to develop and adopt a policy to promote parental involvement in the public school system to include a. A plan for parental participation in schools to improve parent and teacher cooperation in such areas as homework, school attendance, and discipline. b. A procedure for a parent to

Consider, a relation Employees, which contains information about workers and their salaries. Employees ID D13 D14 D25 D23 D04 D03 D02 D01 Yearsin Service 2 3 Name W. Ganim A. Fry O. Lal 3 V. Kotlar 5 A. Randall 5 R. Fry 5 M. Singh 8 M. Singh 8 Role Programmer 25,000 Programmer 27,000 Programmer 27,000 Salary Programmer 34,000 Programmer 34,000

Ms. A is an employee of a Canadian public company, Square Co. (SQUARE/Employer). She lives in Mississauga, ON and her salary for 2022 year is $115,000. She is not a salesperson and does not receive any commission income. While Ms. A receives various benefits from SQUARE as an employee, she is also required to pay some of her employment-related

Provided is a table of temperature devices called devices. Write a query that will return the average thermostat temperature from each room with more than 2 thermostats attached. The results should be listed in descending order based on the room name and should round to the nearest whole number without any decimals. Example TableName DEVICES

Evaluate the star schema design View the star schema in the database diagram dimStore StoreNumber StoreLocation StoreState Store ManagerFirstName Store ManagerLastName StoreManager StoreType dimSales Department SalesDepartment Sales ManagerFirstName Sales Manager Last Name Sales Manager Department Location dimSKU SKU Description SKUDescription

Symbols for Relational Algebra Expressions and Other Symbols Symbols for relation schemas R, S, T Symbols for relations R, S, T Symbols for Relational Algebra operators U, , t, o, p, x, n. A, , , M, M, M, X, X, Symbols for logical connectives A, V, Symbols for comparison predicates , ,

Consider a command copy with the following flags n number of copies g groupName (account that will be charged for the copies) S (whether or not the copies will be stapled) (double sided) d Create an option string for the above options and declare a struct to hold the flags.

The company wants to see the total sale amount per sales person (salesman) for all orders. Assume that some online orders do not have any sales person involved. Display the salesman full name and the total sale amount for that employee. Include also the Total Sale amount for all Orders without involvement of a salesman. Exclude sales persons whose

0 Tables (Filtered) CONTACTS CONTACTID FIRSTNAME LASTNAME EMAIL PHONE CUSTOMERID COUNTRIES COUNTRYID COUNTRYNAME REGIONID COUNTRY COUNTRYID COUNTRYNAME REGIONID CUSTOMERS CUSTOMERID NAME ADDRESS WEBSITE CREDITLIMIT DEPARTMENT DEPARTMENTID DEPARTMENTNAME MANAGERID LOCATIONID EMPLOYEE EMPLOYEEID FIRSTNAME LASTNAME EMAIL PHONENUMBER HIREDATE JOBID

Consider a chain of particles that can interact via nonlinear nearest neighbors model (x. 2x x ) (x.. x, ) ( , , , ) X X n n n1 n1 Bmodel X (X1 2x X, ) (x. x, ) ( x x, ) x B n1 n1 n1 Xn(t) is the displacement of the nth particle from its equilibrium position. Fixed end point problem LINEAR NORMAL MODES x (t)x (t) ( N kn case

Consider the following relations R and S R S a 2 6 1 0 b 4 8 1 2 b a 4 2 8 6 1 1 C 1 2 3 7 For each of the following questions, use the Insert Table menu option to insert an appropriately sized table for the answer, and then fill in the table with the correct values. 1. What is the Cartesian product of R and S 2. What is the natural join of R and

Your team is part of the IT department at Gatorware Software and you have recently normalized two tables (no nulls or redundant data). Each table has been assigned a proper primary key as follows Customer Table Primary Key CustID CustID Customer First 111 Peter RepID 222 Ed 333 Vance 444 Tim 555 Alan 666 Krish 777 Jae 888 Kindra Last Turylo Goad

Transaction processing is an important concept in database programming. Describe what a transaction is and two issues that might occur if a transaction is not used in manipulating data with multiple queries.

Form database using the attached "Jaunty Coffee Co. ERD" by doing the following: 1. Develop SQL code to create each table as specified in the attached "Jaunty Coffee Co. ERD" by doing the following: a. Provide the SQL code you wrote to create all the tables. b. Demonstrate that you tested your code by providing a screenshot showing your SQL

C170 Performance Assessment Jaunty Coffee Co. ERD EMPLOYEE PK employeeid firstname lastname hiredate jobtitle FK shopid INTEGER VARCHAR(30) VARCHAR(30) DATE VARCHAR(30) INTEGER M1 COFFEE SHOP PK shopid shopname city state INTEGER VARCHAR(50) VARCHAR(50) CHAR(2) 1M COFFEE PK coffeeid FK shopid FK supplierid coffeename priceperpound SUPPLIER PK

One reason for graph theorys power as a modeling tool is the fluidity with which one can formalize properties of large systems using the language of graphs, and then systematically explore their consequences. We will work through an example of this process using the concept of a pivotal node. First, recall that the shortest path between two nodes

Perform the following tasks: Start with your entity-relationship (EER) model and now map your model to a logical database design. Ensure that your logical database is normalized per the forms 1NF, 2NF, 3NF, and BCNF.

Name Code Address Bank N (Loanid) (Loantype) Amount ER Diagram of a Bank Has Offer N Loan Custid M (Branch id) Availed by Branch N Customer N Maintain Name M Address) Account Name Phone Hold by Address Account No AccType (Balance

make a form based on the Products data with a Category combo box (created without the wizard, call it FORMO1 2. make a MainFormSubForm using Customers only from CA with Orders only over 50, call it FORMO2. 3. make a Form with 10 different toolbox objects, call it FORM03. 4. make a form that uses data from 5 different tables, and is able to update

For each question write the question, SQL script and the output. Include all three in a notepad or word document. Do not include screen shots. Know how to cut and paste from the SQLplus screen. customers custID custLName custFName DateofBirth custCity C1 Attenweiler Shannon 10-Jul-1987 Florence C2 Marksbury Faisal 25-Dec-1965 Blue Ash C3 O'Connell

whether the following statements are true or false. Explain why. Assume that a relation schema R(A..... An) is given and that XC (A,..... An) holds. For t Erg. let tX be the projection of t to the attributes in X. X is called a key if the following condition is fulfilled For all relation instances r of R holds V t, t ErR tX tX) t t2 In

Consider the following relations R and Q R X Y 1 A 2 B C 3 3 S X1 Y X2 1 A 1 2 B 1 C 3 D 2 1 and Q X 2 3 4 Y D Determine a Relational Algebra expression (by writing a multistep query) that creates the following new relation S (L represents the null value) C B

Create a series of transactions that will show lost update, uncommitted data, inconsistent retrieval, Conflict Equivalence and the 2 types of schemes. Clearly discuss the type of transaction that you will useapply. You can create different transactions(description) for each type of control and scheme (example lost update you will use bank

1. Run a SELECT statement that returns two columns based on the Vendors table. The first column, Contact, is the vendor contact name in this format: first name followed by last initial (for example, "John S.") The second column, Phone, is the VendorPhone column without the area code. Only return rows for those vendors in the 559 area code. Sort

Construct a database for a parking service system. The university has many parking-lots which can accommodate many vehicles. Each parking-lot has id, name, and location. A parking-lot consists of many parking spaces (or spots) and each parking space (or spots) has a unique number. Every customer has zno and name. A customer can purchase more than

Why am I getting this error and how can I fix it?

3 rows in set (0.03 sec) mysql SELECT COUNT() AS RETURNEDAMOUNT, Orders.SKU AS PRODUCTSKU, Orders.Description AS PRODUCT DESCRIPTION FROM Orders INNER JOIN RMA ON Orders.OrderID RMA.OrderID INNER JOIN Customers ON Orders. CustomerID Customers.CustomerID WHERE UPPER (State) IN (WASHINGTON, OREGON, IDAHO, MONTANA) WHERE UPPER (Status)

Based on the below table, c.r.e.ate a stored procedure ' get_prodLocationId ' that will accept the Name of the location as a parameter and display LocationID . Then, execute the procedure using a proper parameter.

Object Explorer Connect Y e Production.Location Columns To LocationID (PK, smallint, not null) Name (Name(nvarchar(50)), not null) CostRate (smallmoney, not null) Availability (decimal (8,2), not null) Modified Date (datetime, not null). Keys Constraints. Triggers Indexes Statistics X SQLQuery1.sql D...4H7KGPsamib (57)) X select from

What is the purpose of relational algebra?

Draw an ERD for MyCollege. You can do it using paper and pencil, or using a tool to draw ERDs. If you use a tool, please mention the name and url. Note DO NOT USE A TOOL THAT TRANSFORMS DIRECTLY YOUR ERD INTO RELATIONS. If you do you will not understand how to draw an ERD. The ERD will capture the following information MyCollege has several

Based on the Below tables, write sql statement using JOIN to display department name, manager_id , street Address and post_code. Include only location_id that are assigned to a department .

locationid streetaddress 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 2200 2300 1297 Via Cola di Rie 93091 Calle della Testa 2017 Shinjukuku 9450 Kamiyacho 2014 Jabberwocky Rd 2011 Interiors Blvd 2007 Zagora St 2004 Charade Rd 147 Spadina Ave 6092 Boxwood St 40512 Laogianggen 1298 Victoria Street 199 Clementi North postalcode 00989 10934

Report the value of each canceled order for each customer. Sort by customer name and order number. based on the ClassicModels

Payments check Number paymentDate amount customerNumber Customers customerNumber customerName contactLastName contactFirstName phone addressLine1 addressLine2 city state postalCode country sales RepEmployeeNumber creditLimit customerLocation Orders orderNumber orderDate requiredDate shipped Date status comments customerNumber HI Offices

Using the Pitching table, write a query that select the playerid, teamid, Wins (W), Loss (L) and Earned Run Average (ERA) for every player (Slide 15). This query should return 49,430 rows. playerid teamid w bechtge01 PH1 1 brainas01 WS3 12 fergubo01 NY2 0 I playerid teamid w aardsda01 SFN 1 aardsda01 SEA 3 aardsda01 SEA 0 2 15 0 2. Modify the

Write SQL statements for the following queries. 1) Retrieve all names of products that were purchased by Kailani Benham on 2903 23 at the store located at 22100 FI7, Boca Raton, Fl 33428. 2) Retrieve the ids and the first and last names of employees who have no supervisor and are older than 80. 3) Retrieve the ids and the first and last names of

Use MATLAB to compute and plot the signal yn xn hn, where xn . hn 1, 0