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 17 of 17 total

per page
Page:
  1. 1
  2. 2

Grid  List 

Set Ascending Direction
  1. 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
  2. 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
  3. 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
  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 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
  6. 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
  7. 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 17 of 17 total

per page
Page:
  1. 1
  2. 2

Grid  List 

Set Ascending Direction