Database

Need Help in Database Assignment?
We can help you if you are having difficulty with your Database Assignment. Just email your Database Assignment at admin@assignmentcache.com.
We provide help for students all over the world in Database Assignment.

Items 41 to 50 of 189 total

per page
Page:
  1. 3
  2. 4
  3. 5
  4. 6
  5. 7

Grid  List 

Set Descending Direction
  1. IT358 Unit 9 PL/SQL Stored Procedures

    IT358 Unit 9 PL/SQL Stored Procedures

    Regular Price: $20.00

    Special Price: $15.00

    IT358 Unit 9 PL/SQL Stored Procedures

    Outcomes addressed in this activity:
    Use PL/SQL Block Structures
    Identify different types of blocks used in PL/SQL
    Demonstrate the ability to output messages using PL/SQL

    Course Outcomes:
    IT358-5 Write stored procedures to meet business needs

    Project requirements:
    Part 1. Write a PL/SQL block that displays the last name and salary of the following people. Each of these can be done separately as PL/SQL, first to test and get the output lines then encapsulated in the procedure and then called, or all in one piece of code like #2 if student is comfortable with writing it all as one program. In this second option student would submit three print screens and in the first option six print screens:
    a. The highest paid employee
    b. The lowest paid employee
    c. The average salary of all employees

    Part 2. Embed a stored procedure and call it (must be done from SQL Command Line), providing print screens demonstrating that the PL/SQL blocks return the correct responses upon being executing the stored procedure.

    Place the answers to #1 and #2 in an MS Word Document. Also copy and paste your scripts and print screens into the same MS Word document and upload the file to Assignment 9 in the Dropbox.

    Learn More
  2. IT358 Unit 8 Users and Roles

    IT358 Unit 8 Users and Roles

    Regular Price: $20.00

    Special Price: $15.00

    IT358 Unit 8 Users and Roles

    Outcomes addressed in this activity:
    Create users
    Create roles
    Use the GRANT and REVOKE statements
    Create and access database links

    Project requirements:
    In this project, you will work with privileges, roles, and passwords:
    1. Answer Review questions 1–5 from Chapter 7.
    2. Complete Hands on Assignments #1-10 from Chapter 7

    Oracle 11G SQL Chapter 7 Hands-On assignment Solution
    1. Create a new user account. The name of the account should be a combination of your first initial and your last name.
    2. Attempt to log in to Oracle 10g using the newly created account.
    3. Assign privileges to the new account that allow the new user to connect to the database, create new tables, and alter an existing table.
    4. Using a properly privileged account, create a role named customerrep that allows new rows to be inserted into the ORDERS and ORDERITEMS tables and allows rows to be deleted from those tables.
    5. Assign the account created in Assignment 1 the customerrep role.
    6. Log in to Oracle 10g using the new account created in Assignment 1. Determine the privileges currently available to the account.
    7. Revoke the privilege to delete rows in the ORDERS and ORDERITEMS tables from the customerrep role.
    8. Revoke the customerrep role from the account created in Assignment 1.
    9. Delete the customerrep role from the Oracle 10g database.
    10. Delete the user account created in Assignment 1.

    Learn More
  3. IT358 Unit 7 Synonyms Index and Sequence

    IT358 Unit 7 Synonyms Index and Sequence

    Regular Price: $20.00

    Special Price: $15.00

    IT358 Unit 7 Synonyms Index and Sequence

    Outcomes addressed in this activity:
    Describe how the schema objects work
    Describe how sequences and indexes are created, modified, and removed within Oracle
    Describe when to use an Index
    Utilize Synonyms

    Project requirements:
    In this project, you will create a view, synonym, and index:
    1. Answer the Review Questions #1–5 from Chapter 6.
    2. Complete Hands-on Assignments #1-10.

    Oracle 11G SQL Chapter 6 Hands-On assignment Solution
    1. Create a sequence to use for populating the Customer# column of the CUSTOMERS table. When setting the start and the increment values, keep in mind that data already exists in this table. The options should be set to not cycle the values, not cache any values, and no minimum or maximum values should be declared.
    2. Add a new customer row using the sequence created in Question 1. The only data currently available for the customer is as follows: last name = Shoulders, first name = Frank, and zip = 23567.
    3. Create a sequence that will generate integers starting with the value 5. Each value should be three less than the previous value generated.The lowest possible value should be 0, and the sequence should not be allowed to cycle. Name the sequence MY_FIRST_SEQ.
    4. Issue a SELECT statement that will display NEXTVAL for MY_FIRST_SEQ three times. Because the value is not being placed in a table, use the DUAL table in the FROM clause of the SELECT statement. What causes the error on the last SELECT?
    5. Change the setting of MY_FIRST_SEQ so the minimum value that can be generated is –1000.
    6. Create a private synonym that will allow you to reference the MY_FIRST_SEQ object as NUMGEN.
    7. Use a SELECT statement to view the CURRVAL of NUMGEN. Delete the NUMGEN synonym and MY_FIRST_SEQ.
    8. Create a Bitmap index on the CUSTOMERS table to speed up queries that search for customers based on their state of residence. Verify that the index exists, and then delete the index.
    9. Create a B-tree index on the customer’s Last Name column. Verify that the index exists by querying the data dictionary. Remove the index from the database.
    10. Many queries search by the number of days to ship (number of days between the order and shipping dates). Create an appropriate index that might improve the performance of these queries.

    Learn More
  4. IT358 Unit 6 Views

    IT358 Unit 6 Views

    Regular Price: $20.00

    Special Price: $15.00

    IT358 Unit 6 Views

    Outcomes addressed in this activity:
    Create a view, using CREATE
    VIEW command or the CREATE OR REPLACE VIEW command
    Explain the effect of the WITH READ ONLY option
    Demonstrate the ability to update records in a simple view
    Demonstrate the ability to re-create a view
    Identify problems associated with adding records to a complex view
    Identify the key-preserved table underlying a complex view

    Project requirements:
    In this project, you will write joins and subqueries:
    1. Complete the Review Questions for numbers 1–5 from Chapter 13.
    2. Complete the Hands-on Assignments #1-10 from Chapter 13.

    Oracle 11G SQL Chapter 13 Hands-On assignment Solution
    1. Create a view that will list the name of the contact person at each publisher and the person’s phone number. Do not include the publisher’s ID in the view. Name the view CONTACT.
    2. Change the CONTACT view so that no users can accidentally perform DML operations on the view.
    3. Create a view called HOMEWORK13 that will include the columns named Col1 and Col2 from the FIRSTATTEMPT table. Make certain the view will be created even if the FIRSTATTEMPT table does not exist.
    4. Attempt to view the structure of the HOMEWORK13 view.
    5. Create a view that will list the ISBN and title for each book in inventory along with the name and telephone number of the individual to contact in the event the book needs to be reordered. Name the view REORDERINFO.
    6. Try to change the name of one of the individuals in the REORDERINFO view to your name. Was there an error message displayed when performing this step? If so, what was the cause of the error message?
    7. Select one of the books in the REORDERINFO view and try to change the ISBN of the book. Was there an error message displayed when performing this step? If so, what was the cause of the error message?
    8. Delete the record in the REORDERINFO view that contains your name (if that step was not performed successfully, then delete one of the contacts already listed in the table).Was there an error message displayed when performing this step? If so, what was the cause of the error message?
    9. Issue a rollback command to undo any changes made with any previous DML operations.
    10. Delete the REORDERINFO view.

    Learn More
  5. IT358 Unit 5 INNER JOIN OUTER JOIN subquery

    IT358 Unit 5 INNER JOIN OUTER JOIN subquery

    Regular Price: $20.00

    Special Price: $15.00

    IT358 Unit 5 INNER JOIN OUTER JOIN subquery

    Outcomes addressed in this activity:
    Create a query with an INNER JOIN
    Create a query with an OUTER JOIN
    Create a query that contains a subquery

    Project requirements:
    In this project, you will write joins and subqueries:
    1. Complete the Hands-on Assignments #1–5 for Chapter 9.
    2. Complete the Hands-on Assignments #1–5 for Chapter 12.

    Oracle 11G SQL Chapter 9 Hands-On assignment Solution
    Generate and test two SQL queries for each of the following tasks: (a) the SQL statement needed to perform the stated task using the traditional approach, and (b) the SQL statement needed to perform the stated task using the JOIN keyword.
    1. Create a list that displays the title of each book and the name and phone number of the person at the publisher’s office whom you would need to contact to reorder each book.
    2. Determine which orders have not yet shipped and the name of the customer who placed each order. Sort the results by the date on which the order was placed.
    3. List the customer number and names of all individuals who have purchased books in the fitness category.
    4. Determine which books Jake Lucas has purchased. Perform the search using the customer name, not the customer number.
    5. Determine the profit of each book sold to Jake Lucas. Sort the results by the date of the order. If more than one book was ordered, sort the results by the profit amount in descending order. Perform the search using the customer name, not the customer number.

    Oracle 11G SQL Chapter 12 Hands-On assignment Solution
    Use a subquery to accomplish each of the tasks. First, execute the query you will use as the subquery to verify the results.
    1. Determine which books have a retail price that is less than the average retail price of all books sold by JustLee Books.
    2. Determine which books cost less than the average cost of other books in the same category.
    3. Determine which orders were shipped to the same state as order 1014.
    4. Determine which orders had a higher total amount due than order 1008.
    5. Determine which author or authors wrote the book(s) most frequently purchased by customers of JustLee Books.

    Learn More
  6. Ski Club Skiing Database Using SQL Management Studio

    Ski Club Skiing Database Using SQL Management Studio

    Regular Price: $15.00

    Special Price: $12.00

    Ski Club Skiing Database Using SQL Management Studio

    Using SQL Management Studio, create the normalized tables, fields and relationships between the tables for the Skiing Database scenario below.

    You have been contracted by the president of the Ski Club to design a Skiing Database:
    The president has asked you to design a database to keep track of member and skiing resort information.
    For each member of the club, she wants you to track name, address, phone number, age and skiing ability.
    For the various ski mountains you need to track the name of the resort, its location, # of trails, # of lifts.
    The president also wants a monthly report of skier activity including the skiers name, phone number, skiing ability, Ski Resort visited, the date of the visit and general comments on the skiing there.

    Don't add any additional fields other than what is being requested. That does not mean you should not break down each field to it's smallest possible component.
    Create the database using SQL Management Studio.
    Detach the completed Database file and submit both the .mdf and .ldf files to the assignment in a zipped folder with your firstname followed by the initial of your lastname.

    Learn More
  7. CMIS 320 Lab 2 Homework 2 Data modeling and Sample database

    CMIS 320 Lab 2 Homework 2 Data modeling and Sample database

    Regular Price: $15.00

    Special Price: $12.00

    CMIS 320 Lab 2 Homework 2 Data modeling and Sample database


    Homework Submission Requirements:
    Homework should be submitted as an attached file in your assignment folder. text for coding and result of execution and MS Word format for documenting are preferred. Data modeling diagram could be copied and pasted into a Word doc.
    You must name your file to include your first initial of your first name and last name.
    Part I is 4 points and Part II is 1 points. Total is 5. Quiz is not required for grading.


    Part I Data Modeling
    For each of the following descriptions:
    a. A piano manufacturer wants to track all pianos it makes. Each piano has a unique serial number and a manufacturing completion date. Each instrument represents exactly one piano model, all of which have an identification number and model. The company produces thousands of pianos of a certain model, and the design is specified before any single piano exists.
    b. A vendor builds multiple types of tablet computers. Each has a type identification number and a name. The key specifications for each type include amount of storage and display type. The company uses multiple processor types, exactly one of which is used for a specific tablet type. The same processor can be used in multiple types of tablets. Each processor has a manufacturer and a manufacturer's unique code that identifies it.
    perform the following tasks:
    1. Identify the degree and cardinalities of the relationship.
    2. Express the relationships graphically with an E-R diagram.
    Document your work into a single, well-organized, well-written word document and submit no later than due date.


    Part II Lab 2
    In lab 2, you will learn how to run a SQL script to create a sample database in your schema in NOVA Oracle database. You also start to learn simple SQL commands, such as select and insert


    Click here to open Lab 2 instruction page


    This part of lab is to learn to run a SQL script on NOVA Oracle database server, and spool screen output to a text file. These techniques will be used when you work on your project 1 and 2. Download script file. This is sql script file containing completed sql commands to create tables and constraints and populate data to each table. The database you create is called JustLee Book Store. The code should be bug free.
    Download lab2.sql script
    Start spool command and run the script:
    Log on NOVA, make a dir named scripts using command mkdir scripts
    Then cd to newly created script directory
    Upload your script to scripts directory using FTP
    (I downloaded a free FTP client CORE FTP LE) and use it to upload and download file)
    Now you have a newly create dir and your script is uploaded. You are ready to run your script.
    Using SQL*Plus, log on NOVA Oracle database with your account
    At SQL prompt,Type the following command to turn on spool function: SQL>spool spool01.lst
    spool01.lst is the spool file name
    Then use this command to run the script: SQL>@lab2.sql
    The command will execute all the SQL commands inside the script and output will be spooled to spool01.lst
    In the script, there are drop table statement as well. When first run, these commands will fail because the tables are not created yet.
    You can run the script multiple times without any problems.
    When you finish the execution, issue command SQL>spool off
    This command will end spool function and save output to the file you defined
    When you have done all of these. Use FTP get spool01.lst to your local computer and submit it as part of homework 2
    You should know how to perform the following tasks using sqlplus on NOVA Oracle database after you complete this lab:
    Using FTP to upload or download a file (scripts...)
    Using sqlplus to log on to NOVA Oracle database
    Using sqlplus command, spool to output screen output to a text file and transfer the file back to your local PC.
    Understand the steps taken place when you perform FTP file transfer and Spooling your output.
    Test the database you create and learn SQL queries.
    You need to spool the execution results of the following commands.
    Do a database query: select table_name from user_tables; USER_TABLES is a database system view that allow users to see the tables they created in their own schema.
    You should be able to list the tables you just created
    use this query: select * from "table_name from the above query"; you can retrieve the data in these tables one a time
    use this query: select count(*) from "table_name from the above query"; you can retrieve the record counts in these tables one a time
    Use SQL*Plus command "desc books" to check columns and their datatypes. And insert one record into the table. Use SQL command "commit" to save the record into your database.
    When you have done all of these. Use FTP get spooled file to your local computer and submit it as part of homework 2

    Learn More
  8. Succeeding in Business with Microsoft Access 2013 Steps to Success Level 2 qryDuplicatePostalCodes

    Succeeding in Business with Microsoft Access 2013 Steps to Success Level 2

    Regular Price: $25.00

    Special Price: $20.00

    Succeeding in Business with Microsoft Access 2013 Steps to Success Level 2


    Hudson Bay Pharmacy is ready to crearte more complex queries to analyze employee data. Kim Siemers, human resources manager for Hudson Bay, asks for your help in creating queries that extract the employee information she needs from their database. As you create and save the new queries be certain to use the "qry" perfix as a part of the naming convention. Also consult your instructor for instruction about submitting results.


    1. Start access and open Hudson.accdb database from STS folder.


    2. Kim wants to identify employees who live in the same neighborhood in Edmonton so they can create car pools and share rides to work. In Edmonton, the postal codes roughly correspond to neighborhood. Prepare a list of employees who live in the same neighborhood so that Kim can create a list of employees who can share rides to work. Name the query qryDuplicatePostalCodes.


    3. A new policy at Hudson Bay Pharmacy is that all employees must acquire and maintain certifications in adult, infant, and child CPR and in using defibrillators. Kim asks you to identify employees who have not completed any certification training. Save the query as qryNoTraining.


    4. Kim also needs to list all employees and the classes they have taken. The results should include current employees who have not attended training as well as those who have. Save the query as qryEmployeeTraining.


    5. Kim also needs to identify employees whose CPR or defibrillators certification has expired, depending on the time period she specifies. Show all employees whose Adult CPR, Child/Infant CPR, or Defibrillators Use certification has expired in any specified time period. Save the query as qryUpToDate.


    6. Mai Yan, manager of Hudson Bay Pharmacy, wants to identify the five current nonsalaried employees who are earning the highest wages per hour. These are the five employees who have been working for the pharmacy the longest or who have regularly received raises for their work. List the top five wage earners of all the current nonsalaried employees. Save the query as qryTop5HourlyRates.


    7. To prepare for employee reviews, Kim needs to calculate the minimum, maximum, and average hourly rates for each job category. Provide this information for her, saving the query as qryMaxMinAvgHourlyRate.


    8. Mai is considering offering life insurance as an employee benefit, and needs to know the current age of all employees. Provide this information for her. Be certain to provide an appropriate name for the column with the result and to show the ages in descending order. Include the job title and format the results so that they include one decimal place. Also show the first name and last name together. Save the query as qryEmployeeAge.


    9. Kim asks you to provide one other statistical analysis. Show the average age of employees by job title. Save this query as qryAvgEmployeeAge.


    10. Close the Hudson.accdb database and Access.

    Learn More
  9. Muscat Theatre House ERD

    Muscat Theatre House ERD

    Regular Price: $12.00

    Special Price: $10.00

    Muscat Theatre House ERD


    Muscat Theatre House is a place where opera performances are being scheduled. A play is an opera performance acted by different actors/actresses having different roles. A play has id, title, description and category. In every play there will be one or more actors/actresses performing and an actor may perform in any number of plays or may not perform in a given play. Information about actor/actress includes id, name, contact number, nationality, birthdate, and address, which is composed of street number, city, state and country. The role and payment for each actor/actress is also being stored for every play they will perform since these vary from play to play. A schedule is being prepared for each play which details the date and time a play will be performed. A play will be scheduled at least once. Once the schedule is published, customers start reserving seats for a particular schedule or may reserve seat to more than one schedule. A schedule may or may not be reserved by any customer. Information about customer includes id, name and contact number. Whenever a customer reserves for a schedule of a play, it will be identified by a reservation number along with the seat number/s being reserved.

    Learn More
  10. Oracle 11g SQL Joan Casteel Chapter 12 Hands-On Assignments

    Oracle 11g SQL Joan Casteel Chapter 12 Hands-On Assignments

    Regular Price: $10.00

    Special Price: $8.00

    Oracle 11g SQL Joan Casteel Chapter 12 Hands-On Assignments


    To perform these activities, refer to the tables in the JustLee Books database. Use a subquery to accomplish each task. Make sure you execute the query you plan to use as the subquery to verify the results before writing the entire query.


    1. List the book title and retail price for all books with a retail price lower than the average retail price of all books sold by JustLee Books.
    2. Determine which books cost less than the average cost of other books in the same category.
    3. Determine which orders were shipped to the same state as order 1014.
    4. Determine which orders had a higher total amount due than order 1008.
    5. Determine which author or authors wrote the books most frequently purchased by customers of JustLee Books.
    6. List the title of all books in the same category as books previously purchased by customer 1007. Don't include books this customer has already purchased.
    7. List the shipping city and state for the order that had the longest shipping delay.
    8. Determine which customers placed orders for the least expensive book (in terms of regular retail price) carried by JustLee Books.
    9. Determine the number of different customers who have placed an order for books written or cowritten by James Austin.
    10. Determine which books were published by the publisher of The Wok Way to Cook.

    Learn More

Items 41 to 50 of 189 total

per page
Page:
  1. 3
  2. 4
  3. 5
  4. 6
  5. 7

Grid  List 

Set Descending Direction