MySQL

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

Items 11 to 20 of 20 total

per page
Page:
  1. 1
  2. 2

Grid  List 

Set Ascending Direction
  1.  ITS407 Module 8 Entities and Attributes

    ITS407 Module 8 Project Ace Software MySQL Database For Mom and Pop Johnson video store

    Regular Price: $25.00

    Special Price: $20.00

    ITS407 Module 8 Project Ace Software MySQL Database For Mom and Pop Johnson video store


    You are a database consultant with Ace Software, Inc., and have been assigned to develop a database for the Mom and Pop Johnson video store in town. Mom and Pop have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database.


    You sit down with Mom and Pop to discuss their business, and watch their operation for about a week. You discover quickly that a video and a DVD are both copies of a movie kept in a separate plastic case that is rented out. They have several copies of each movie they rent, therefore there are several videos and DVDs for each movie title. You learn that in their inventory they have several thousand videos and DVDs, which they get wholesale from about a half dozen distributors. The video and DVD prices to them are based on the quantity of their shipment and the past business they have done with each company.


    The price of a DVD for a movie might be different than the price of a video for the same movie, even from the same distributor. Each distributor provides different types of movies (e.g., suspense, horror, mystery, comedy, etc.). A single distributor may provide several different types of movies in both video and DVD format. It is possible to obtain the same movie from multiple distributors and at different wholesale prices.


    Each video and DVD has a unique identification number that Mom and Pop assign in their inventory, in addition to the distributor's serial number for the item. Each movie also has a unique identification number Mom and Pop assign in addition to the title and any movie IDs the distributors use in their electronic catalogs. Distributors provide electronic catalogs to Mom and Pop, and the information from these catalogs must be included in the database.


    Mom and Pop need to record when a video or DVD is rented, when a video or DVD is returned, and all customer charges such as late and damaged fees, failure to rewind fees, and taxes. They need a report of which videos are returned late because there are standard and late charges. On occasion there are discount prices for certain movies or types of movies. Customers want to rent movies based on actors or actresses, running length, type of movie, rating, year released, the director, and the Academy Awards won (by the movie, the actors, the actresses and/or the directors). Customers also want to know how many videos they have rented in the last month, year, and so forth. Mom and Pop need to keep only basic information on customers in their database, such as name, address, telephone numbers, etc.


    There must be no limit to the number of video and/or DVD copies of a movie that Mom and Pop can have in their inventory. Video/DVD ID numbers, movie ID numbers, and distributor ID numbers for videos, DVDs, and movies are all different. Also, each movie must be able to have an unlimited number of actors, actresses, directors, and Academy Awards (i.e., Oscars). Other types of awards (e.g., Golden Globe, People's Choice, etc.) are not of interest for this application. The rental of equipment, sale of videos, DVDs, popcorn, etc., is not to be kept in the database.


    1) Identify and describe the entities and their attributes.
    2) Develop relationship sentence pairs.
    3) Draw an ERD with Visio.
    4) Develop metadata from the ERD and document in an Excel spreadsheet.
    5) Using your selected RDBMS (SQL Server, Oracle, or MySQL), develop and execute an SQL script file of DDL SQL to create the database tables in the metadata document.
    6) Using your selected RDBMS, develop and execute an SQL script file of DML SQL INSERT statements to populate the tables using SQL INSERT statements for at least 5 rows of data per table.
    7) Using your selected RDBMS develop and execute an SQL script file to:
     a) Show the contents of all tables
     b) Retrieve all of the customers' names, account numbers, and addresses (street and zip code only), sorted by account number
     c) Retrieve all of the DVDs rented in the last 30 days and sort in chronological rental date order
     d) Update a customer name to change their maiden names to married names. You can choose which row to update. Make sure that you use the primary key column in your WHERE clause to affect only a specific row.
     e) Delete a specific customer from the database. You can choose which row to delete. Make sure that you use the primary key column in your WHERE clause to affect only a specific row.


    The metadata should be submitted in an Excel spreadsheet. All other outputs for the database design, SQL code, and SQL results should be submitted in a single Word file in order, by step, and clearly labeled.

    Learn More
  2. CS371 Database Design Week 5 Chapter 6 Exercise 1

    CS371 Database Design Week 5 Assignment Chapter 6 Questions

    Regular Price: $20.00

    Special Price: $15.00

    CS371 Database Design Week 5 Assignment Chapter 6 Questions

    Chapter 6 Exercises 1 page 154: Use MySQL Workbench to construct the relational diagram for this database.
    Chapter 6 Exercises 2 page 154: Use MySQL Workbench to construct the relational diagram for this database.
    Chapter 6 Exercise 5 page 155: Submit responses in Word Doc format.

    You may submit a single word doc with SQL queries and your models pasted in – OR – submit separate files including PDFs of your models and a word doc with your queries.

    Chapter 6 Exercise 1 page 154: Use MySQL Workbench to construct the relational diagram for this database:

    1.  Leslie’s Auto Sales has a relational database with which it maintains data on its salespersons, its customers, and the automobiles it  sells. Each of these three entity types has a unique attribute identifier.
    The attributes that it stores are as follows:
    • Salesperson Number (unique), Salesperson Name, Salesperson Telephone, Years with Company
    • Customer Number (unique), Customer Name, Customer Address, Value of Last Purchase From Us
    • Vehicle Identification Number (unique), Manufacturer, Model, Year, Sticker Price Leslie’s also wants to keep track of which salesperson sold
    which car to which customer, including the date of the sale and the negotiated price. Construct a relational database for Leslie’s Auto Sales.

    Answer:


    Chapter 6 Exercise 2 page 154: Use MySQL Workbench to construct the relational diagram for this database.

    2.  The State of New York certifies firefighters throughout the state and must keep track of all of them, as well as of the state’s fire departments. Each fire department has a unique department number, a name that also identifies its locale (city, county, etc.), the year it was established, and its main telephone number. Each certified firefighter has a unique firefighter number, a name, year of certification, home
    telephone number, and a rank (firefighter, fire lieutenant, fire captain, etc.) The state wants to record the fire department for which each firefighter currently works and each firefighter’s supervisor. Supervisors are always higher-ranking certified firefighters.
    Construct a relational database for New York’s fire departments and firefighters.

    Answer:


    Chapter 6 Exercise 5 page 155: Submit responses in Word Doc format.

    5. In the General Hardware Corp. database of Figure 6.1, what would happen if:
    a. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is restrict and an attempt is made to delete the record for customer 2198 in the CUSTOMER relation?
    b. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is cascade and an attempt is made to delete the record for customer 2198 in the CUSTOMER relation?
    c. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is set to null and an attempt is made to delete the record for customer 2198 in the CUSTOMER relation?
    d. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is restrict and an attempt is made to delete the record for employee 33779 of customer 2198 in the CUSTOMER EMPLOYEE relation?
    e. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is cascade and an attempt is made to delete the record for employee 33779 of customer 2198 in the CUSTOMER EMPLOYEE relation?
    f. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is set-to-null and an attempt is made to delete the record for employee 33779 of customer 2198 in the CUSTOMER EMPLOYEE relation?

    Answer:

    Learn More
  3. CS371 Database Design Week 4 Chapter 5 Relational Model

    GU CS371 Database Design Week 4 Assignment Chapter 5 Relational Database Model

    Regular Price: $20.00

    Special Price: $15.00

    GU CS371 Database Design Week 4 Assignment Chapter 5 Relational Database Model


    The assignment comes from Chapter 5 Minicase 1 but includes an additional step:
    Using MySQL Workbench, create the relational data model for the database for happy cruise lines, which includes 6 tables. (Note: Be sure primary and foreign keys are correct). Export the PDF version of your model for submission.
    Then complete steps a – g. Note: On step g, provide correct SQL syntax for finding the result to each item i – viii. i.e. Do not use the informal relational approach – looking for valid, correct SQL as described in Chapter 4.
    You may submit a single word doc with SQL queries and your model pasted in – OR – submit 2 separate files including a PDF of your model and a word doc with your queries.


    Fundamentals of Database Management Systems 2nd Edition Chapter 5 Minicase 1
    1. Consider the following relational database for Happy Cruise Lines. It keeps track of ships, cruises, ports, and passengers. A “cruise” is a particular sailing of a ship on a particular date. For example, the seven-day journey of the ship Pride of Tampa that leaves on June 13, 2009, is a cruise. Note the following facts about this environment.
    Both ship number and ship name are unique in the SHIP Relation.
    A ship goes on many cruises over time. A cruise is associated with a single ship.
    A port is identified by the combination of port name and country.
    As indicated by the VISIT Relation, a cruise includes visits to several ports, and a port is typically included in several cruises.
    Both Passenger Number and Social Security Number are unique in the PASSENGER Relation. A particular person has a single Passenger Number that is used for all of the cruises that she takes.
    The VOYAGE Relation indicates that a person can take many cruises and a cruise, of course, has many passengers.


    SHIP Relation
    Ship Number
    Ship Name
    Ship Builder
    Launch Date
    GrossWeight


    CRUISE Relation
    Cruise Number
    Start Date
    End Date
    Cruise Director
    Ship Number


    PORT Relation
    Port Name
    Country
    Number of Docks
    Port Manager


    VISIT Relation
    Cruise Number
    Port Name
    Country
    Arrival Date
    Departure Date


    PASSENGER Relation
    Passenger Number
    Passenger Name
    Social Security Number
    Home Address
    Telephone Number


    VOYAGE Relation
    Passenger Number
    Cruise Number
    Stateroom Number
    Fare


    Additional step:
    Using MySQL Workbench, create the relational data model for the database for happy cruise lines, which includes 6 tables. (Note: Be sure primary and foreign keys are correct). Export the PDF version of your model for submission.


    Then complete steps a – g.
    Note: On step g, provide correct SQL syntax for finding the result to each item i – viii. i.e. Do not use the informal relational approach – looking for valid, correct SQL as described in Chapter 4.
    a. Identify the candidate keys of each relation.
    b. Identify the primary key and any alternate keys of each relation.
    c. How many foreign keys does each relation have?
    d. Identify the foreign keys of each relation.
    e. Indicate any instances in which a foreign key serves as part of the primary key of the relation in which it is a foreign key. Why does each of those relations require a multi-attribute primary key?
    f. Identify the relations that support many-to-many relationships, the primary keys of those relations, and any intersection data.
    g. Using the informal relational command language described in this chapter, write commands to:
    Note: On step g, provide correct SQL syntax for finding the result to each item i – viii. i.e. Do not use the informal relational approach – looking for valid, correct SQL as described in Chapter 4.
    i. Retrieve the record for passenger number 473942.
    ii. Retrieve the record for the port of Nassau in the Bahamas.
    iii. List all of the Ships built by General Shipbuilding, Inc.
    iv. List the port name and number of docks of every port in Mexico.
    v. List the name and number of every ship.
    vi. Who was the cruise director on cruise number 38232.
    vii. What was the gross weight of the ship used for cruise number 39482?
    viii. List the home address of every passenger on cruise number 17543.

    Learn More
  4. CS371 Database Design Week 6 Exercise 2 Central Hospital

    GU CS371 Database Design Week 6 Assignment Chapter 7

    Regular Price: $20.00

    Special Price: $15.00

    GU CS371 Database Design Week 6 Assignment Chapter 7


    Fundamentals of Database Management Systems 2nd Edition
    Chapter 7 Questions
    Exercise 2 – Using MySQL Workbench, recreate the data model given to you but in a “well-structured” format. Note: This essentially means adding foreign keys. Be sure to choose key names that make sense.
    Minicase 1 - Using MySQL Workbench, recreate the data model given to you but in a “well-structured” format. Note: This essentially means adding foreign keys. Be sure to choose key names that make sense.


    Exercise:
    2. Convert the Central Hospital entity-relationship diagram on the next page into a well-structured
    relational database. (Instructions: Exercise 2 – Using MySQL Workbench, recreate the data model given to you but in a “well-structured” format. Note: This essentially means adding foreign keys. Be sure to choose key names that make sense.)


    Minicase:
    1. Happy Cruise Lines. Convert the Happy Cruise Lines entity-relationship diagram on the next page into a well structured relational database.
    (Instructions: Minicase 1 - Using MySQL Workbench, recreate the data model given to you but in a “well-structured” format. Note: This essentially means adding foreign keys. Be sure to choose key names that make sense.)

    Learn More
  5. CS371 Database Design Week 7 Chapter 8 Final Project Question 4

    GU CS371 Database Design Week 7 Assignment Chapter 8 Final Project

    Regular Price: $20.00

    Special Price: $15.00

    GU CS371 Database Design Week 7 Assignment Chapter 8 Final Project


    Fundamentals of Database Management Systems 2nd Edition
    Questions and Task:
    Question 1
    In your own words discuss the benefits of normalization.


    Question 2
    Do you think we should normalize our designs to higher levels than 3NF? Why or why not?


    Question 3
    There are 14 physical database design techniques discussed in chapter 8. The goal of a quality physical design is to improve performance while disrupting the logical design as little as possible. Pick a technique, which you believe to be the most beneficial in accomplishing the above goal, and explain your reasoning.


    Question 4
    Discuss the concept of an index and explain how they improve performance. Assignment "Final Project Overview" You just took a job with a University and have been asked to track some information about the courses they offer. The previous employee was using a spreadsheet to track this information. The University is expanding from three classes to three hundred classes. Enrollment is expected to increase from around 20 students to 5,000. Your supervisors are not very tech savvy and they simply ask you to continue maintaining the spreadsheet. Review the spreadsheet labeled final_project.xlsx.


    Explain the issues that exist with maintaining the data in its current form.
    Explain the process of migrating the data in its current form to a well formed data model by highlighting the following in detail:
    Identify required attributes that need to be tracked
    Identify functional dependencies Show the redesign in 1NF, 2NF, and 3NF (similar to figures 7.29, 7.31, 7.33)
    Explain the benefits of the data in its new form.
    Create the E-R diagram of your relational tables using MySQL Workbench.
    Provide the SQL statement required to create at least one of your tables.
    Provide the SQL statement required to delete at least one of your tables.
    Provide the SQL statement required to create a view which includes Course #, Course Name, Time, and Days only.
    Identify at least one index, which you believe would improve performance.
    Explain your choice.
    Propose some additional data items, which you believe may be beneficial to the University if tracked in your database (i.e. Descriptions, more info about the instructors and students, departments, etc).
    Describe the steps required to implement these additions.
    If you add a course description attribute to your course table, there may be some performance impacts imposed by the addition of this text field.
    Discuss a physical design technique to improve the performance of the new course description field.

    Learn More
  6. CS362 Structured Query Language for Data Management Week 2 IP

    CS362 Structured Query Language for Data Management Week 2 IP

    Regular Price: $20.00

    Special Price: $15.00

    CS362 Structured Query Language for Data Management Week 2 IP

    After creating the database schema, use Insert, Update, and Delete commands to populate the tables with the following information.

    1. Insert the following classes' records:
    Code     Name     Description
    ACCT306     Accounting 1     This course introduces accounting concepts and explores the accounting environment. It covers the basic structure of accounting, how to maintain accounts, use account balances to prepare financial statements, and complete the accounting cycle. It also introduces the concept of internal control and how to account for assets.
    CS362     Structured Query Language for Data Management     This course gives complete coverage of SQL, with an emphasis on storage, retrieval, and manipulation of data.
    ENG115     English Composition     In this course, students focus on developing writing skills through practice and revision. Students will examine expository, critical, and persuasive essay techniques.
    FIN322     Investments     This course focuses on investments and investment strategies. Various investment vehicles such as stocks, bonds, and commodities are examined. Students will explore the principles of security analysis and valuation.

    2. Insert the following advisors' records:
    Name     Email
    Fred Stone     fred@college.edu
    Bob Gordon     bob@college.edu
    Jack Simpson     jack@college.edu

    3. Insert the following students' records:
    Name     Birthdate     Gender     StartDate     GPA     IsActive     AdvisorID
    Craig Franklin     1970-03-15     Male     2010-05-30     3.10     Yes     3
    Harriet Smith     1982-04-15     Female     2010-05-30     3.22     Yes     1
    George David     1984-11-05     Male     2010-10-01     0.00     Yes     3
    Ben Jefferson     1976-09-25     Male     2009-02-21     1.80     No, the student has gone on temporary leave to pursue other opportunities but plans on returning in 1 year.     3

    4. Delete the course named Investments from the system.

    5. Change Harriet Smith’s birthdate to April 25, 1982 and her GPA to 3.25.

    Copy and paste the work into your Key Assignment document and include screen shots of each step, describe what you did for each step and paste in the actual SQL text used to perform each step. Provide an introduction explaining the important of these commands in relation to your overall Key Assignment.

    Learn More
  7. CS362 Structured Query Language for Data Management Week 4 IP Extended Design SQL Server

    CS362 Structured Query Language for Data Management Week 4 IP Extend the Design

    Regular Price: $20.00

    Special Price: $15.00

    CS362 Structured Query Language for Data Management Week 4 IP Extend the Design

    Using your Week 1 IP as a starting point, extend the design to accommodate degree programs. The new design should incorporate the following functionalities:

    1. A degree has a name and description.
    2. What degree is the student working towards? A student can only work on one degree at a time.
    3. What classes are necessary to obtain a specific degree?
    4. Provide the DDL script to add the tables for the new design changes. Include an updated diagram that shows all the tables in the system.
    5. Write the DML script to insert 3 test records in each of the tables in the system. This data will be necessary to write the queries in the next assignment.

    Copy and paste the work into your Key Assignment document and include screen shots of each step, describe what you did for each step and paste in the actual SQL text used to perform each step. Upload your document to the Submitted Tasks section.

    Learn More
  8. CS362 Structured Query Language for Data Management Week 5 IP Functions MySQL

    CS362 Structured Query Language for Data Management Week 5 IP Functions Stored Procedure and Indexes

    Regular Price: $20.00

    Special Price: $15.00

    CS362 Structured Query Language for Data Management Week 5 IP Functions Stored Procedure and Indexes

    This assignment requires you to take your extended design from Week 4 IP and add proper indexes, a function, and a stored procedure. Your changes will provide functionality used by the teachers for screens such as a grade book. Be sure any code is properly formatted and has appropriate comments.

    Part 1: Function
    Write a user-defined function (UDF) that calculates a student's GPA for a given time frame. Inputs are StudentId int, ClassStartDateStart datetime, and ClassStartDateEnd datetime. The output should be the student's GPA for all classes that were taken between ClassStartDateStart and ClassStartDateEnd. Also, supply the script to call this new function, passing it parameter values of your choice.

    Part 2: Stored Procedure
    Write the DDL script to make a stored procedure that returns data needed to display a grade book screen for a professor. The only input for the stored procedure is a ClassId. Outputs need to include student names and grades for all assignments as well as a calculated overall grade for the class for each student. Provide an example calling this new stored procedure, passing it parameter values of your choice. Include a screenshot of the output.

    Part 3: Indexes
    Provide a list of suggested indexes and the DDL script to create them. Include an explanation of the purpose of indexes and how you made your decision for the fields to include in your list of suggested indexes.


    Copy and paste the work into your Key Assignment document and include screen shots of each step, describe what you did for each step and paste in the actual SQL text used to perform each step. Upload your document to the Submitted Tasks.

    Learn More
  9. Murachs MySQL My Guitar Shop Database Chapter 13 Question 3

    Murachs MySQL My Guitar Shop Database Chapter 13

    Regular Price: $20.00

    Special Price: $15.00

    Murach's MySQL My Guitar Shop Database Chapter 13


    QUESTION  1
    Write a script that creates and calls a stored procedure named test. This stored procedure should declare a variable and set it to the count of all products in the Products table. If the count is greater than or equal to 7, the stored procedure should display a message that says, “The number of products is greater than or equal to 7”. Otherwise, it should say, “The number of products is less than 7”.


    QUESTION  2
    Write a script that creates and calls a stored procedure named test. This stored procedure should use two variables to store (1) the count of all of the products in the Products table and (2) the average list price for those products. If the product count is greater than or equal to 7, the stored procedure should display a result set that displays the values of both variables. Otherwise, the procedure should display a result set that displays a message that says, “The number of products is less than 7”.


    QUESTION  3
    Write a script that creates and calls a stored procedure named test. This procedure should calculate the common factors between 10 and 20. To find a common factor, you can use the modulo operator (%) to check whether a number can be evenly divided into both numbers. Then, this procedure should display a string that displays the common factors like this:
    Common factors of 10 and 20: 1 2 5


    QUESTION  4
    Write a script that creates and calls a stored procedure named test. This stored procedure should create a cursor for a result set that consists of the product_name and list_price columns for each product with a list price that’s greater than $700. The rows in this result set should be sorted in descending sequence by list price. Then, the procedure should display a string variable that includes the product_name and list price for each product so it looks something like this:
    "Gibson SG","2517.00"|"Gibson Les Paul","1199.00"|
    Here, each value is enclosed in double quotes ("), each column is separated by a comma (,) and each row is separated by a pipe character (|).


    QUESTION  5
     Write a script that creates and calls a stored procedure named test. This procedure should attempt to insert a new category named “Guitars” into the Categories table. If the insert is successful, the procedure should display this message:
    1 row was inserted.
    If the update is unsuccessful, the procedure should display this message:
    Row was not inserted - duplicate entry.

    Learn More
  10. Part 4 Adult Baseball league Data Model MySQL Workbench

    Types of Relationships and Sample Databases

    Regular Price: $20.00

    Special Price: $15.00

    Types of Relationships and Sample Databases

    Part 2
    Come up with an original example of a one to many unary relationship. Create an example model of this relationship using the MySQL Workbench data modeler.

    Part 3
    Come up with an original example of a ternary relationship. Create an example model of this relationship using the MySQL Workbench data modeler.

    Part 4
    Using MySQL Workbench – create a data model for on Adult Baseball league which supports all of the following data requirements:
    Teams
        A team has a unique number associated with it
        Team Name
        Team City
        Each team has more than one player associated with it

    Players
        Each Player has a unique number
        A player may play or have played for more than one team
        The number of years and batting average is tracked for each team the player played for.

    Coaches
        In this league, all coaches are also players.
        A Team can have more than one coach.

    Bats
        A team can have multiple bats
        Each bat is identified by a unique serial number.

    For each of the three models above, you should export your model as a single page PDF and submit the resulting files.

    Learn More

Items 11 to 20 of 20 total

per page
Page:
  1. 1
  2. 2

Grid  List 

Set Ascending Direction