Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
Write an SQL statement that uses the vPersonNames view. Write an SQL statement that uses spEmployeeByID using 12 as the ID (again, no need for the output).
Show the DDL to create the objects, be sure to have referential integrity and surrogate keys. Show the DML to load the data. Show the queries of some results.
What fields, primary key and datatypes including field lengths would you need? What reason did you select the field name and datatype for the primary key?
Which tables will be updated by this transaction? Using SQL, write each database request that is needed to complete the transactions.
How many pairs of red sandals are for sale? What is the average price of shoes for each brand? List all details of shoes that cost more than $200.
List the homeowner's name (first and last) for the policy from 2022 that has the smallest premium. List the total number of policies per year.
What are brand names of ALL teal cars? Names of dealers who sell some purple car OR are in Dallas? Names of dealers who sell some green car AND are in Atlanta?
Write a query to show all the names of regions, names of countries and number of locations in them (including regions/countries with 0 locations).
Design and develop a database of your choice that includes Four to five regular strong entities. Draw an EER diagram, as per the above specifications.
Define the four techniques. Describe their roles in maintaining a right database. Write the SQL code to implement them.
Design and refine a database to record and manage information relating to a company's premises, as well as human resources and ongoing projects.
Propose measures (including specific Azure security tools/features) to protect data against security threats and handle data ethically.
List all products (productcode, product description) supplied by Gomez Bros. Find the total value of the product inventory.
Write SELECT statement that lists all of the orders that included the Fender Precision. SELECT the order_id, product_id, product_name, and order_date.
Explain how you would apply vertical partitioning to this table and write a SQL query to reconstruct the complete table after partitioning.
Create a blank SQL database in Azure. Write SQL queries to create the database tables and relationships.
Identify the main entities involved. Identify the main relationship involved. Identify the relationship and explain how you obtained it.
Create an SQL query that returns the average price and variance per product. The products and prices are of your own creation.
Write SQL and choose result that corresponds to your SQL. The ranking is based on number of movies actor has participated in that answer criteria above.
Write a select statement that sums up the salary column from the staff table and finds the average COMM and average BONUS. Include the ID and DEPT column.
Explain the problems with the existing design, in terms of the potential modification anomalies that it might exhibit.
How many students who earned grade A in 2007? Find all student's names who are in classes of instructor 'DAgostino'.
Write SQL query to display the Project Name and average number of hours clocked by employees that work for project offered by department number 12, 21, or 24.
Explain the purpose of htmlentities function in PHP. How do we use implode and explode functions for strings?
Create a Project called SimpleVariables. What variable types did you use here? Why did you use those types?