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 Descending 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. MIS582 iLab Week 7 the 4th of 4 Webserver Database server Construction Using MySQL and INDEX PHP

    MIS582 iLab 4 Week 7 Webserver/Databaseserver Construction Using MySQL and PHP

    Regular Price: $15.00

    Special Price: $12.00

    MIS582 iLab 4 Week 7 Webserver/Databaseserver Construction Using MySQL and PHP


    iLab Overview
    Scenario/Summary
    In this assignment learn to create and manipulate a MySQL database using the PHP. To complete this assignment, you will need to be able to run MySQL via Omnymbus. You should review Chapter 11's coverage on PHP, the tutorial titled "PHP and MySQL" listed in the Webliography and MySQL's own dialect of the SQL language via the file M10C_KROE8352_13_SE_WC10C.pdf in the Doc-Sharing folder titled My SQL Documents.
    Please ensure that you can connect to MySQL/Omnymbus via the account your Professor has emailed to you. Please consult with the document titled MySQLOmnymbusSupport.docx located in the Doc-Sharing folder titled Omnymbus Tutorial Files for instructions on how to get help for any issues that you are having with the MySQL/Omnymbus Environment.


    Deliverables
    Submit your assignment to the Dropbox, located at the top of this page. For instructions on how to use the Dropbox, read these step-by-step instructions. (See the Syllabus section "Due Dates for Assignments & Exams" for due dates.)
    Name your MySQL database Lab4_xxxx where xxxx is your userid. Create and save your MySQL database file. You will be required to submit a web-link to your index.php file, along with 6 php script files and a sql file that will be executed from the Omnymbus public Web page from your Omnymbus account. Please note that your php and sql files will be based upon the templates provided the zip file titled MIS582_Wk7_templates.zip located in the folder titled iLab Documents in Doc Sharing.
    You will need to modify the following php scripts and sql file from the MIS582_Wk7_templates.zip file.
    • index.php
    • insert.php
    • insert_data.php
    • update.php
    • update_data.php
    • delete.php
    • MyAddressBook_CreateTable.sql


    Required Software
    Omnymbus – MySQL
    Access the software at https://devry.edupe.net:8300.


    Lab Steps
    STEP 1: Review the Data Dictionary
    Review the provided data dictionary below to understand the entity, attributes, and primary key of the supplied MySQL database.
    Table Name ATTRIBUTE NAME CONTENTS TYPE FORMAT RANGE REQUIRED PK or FK
    MyAddressbook id Contact ID Number Auto-Increment
    Int(3) 999 000-999 Y PK
    f_name Contact First Name VCHAR(25) Xxxxxx Y
    L_name Contact Last Name VCHAR(25) Xxxxxx Y
    ADDRESS Contact Address VCHAR(25) Xxxxxx Y
    City Contact City VCHAR(25) Xxxxxx 0-9 Y
    State Contact State CHAR(2) Xxxxxx Y
    zip Contact Zip Code NUMBER(5) 99999 Y
    phone Contact Phone NUMBER(10) 9999999999 Y

    STEP 2: Create Table, Insert Statement
    • Run MySQL via Omnymbus.
    • Modify the table creation script that will be used to create the database with the outlined attributes from the Data Dictionary.
    • Provide one Insert Statement that will add your contact information to the newly created table.
    • Save the file with a name containing Lab7_, your first initial, and your last name (e.g., Lab7_JSmith.sql).
    • Execute your script and ensure that the database is created.


    STEP 3: Build Index PHP Page
    Building Your index.php Web Page
    In this step, you will complete your php script page to connect to the Lab7 database and display the MyAddressbook table on the Web page.
    • Complete the MySQL connection for the index.php page. Be sure to fill in appropriate host (127.0.0.1), username, password, and database information in the mysqli field.
    • Modify the provided php code to display each attribute of your MyAddressbook table. Note that initially, only 1 entry should be present in your table.
    • Save your index.php file in your public_html folder in Omnymbus file manager.
    • Please note that you will find your public_html folder down the path zdisk/USERID/public html
    • Direct your Web browser to your site url (ex. http://devry.edupe.net/~XXXX/index.php).
    • Note that you’ll replace XXXX with your Omnymbus login ID.
    • Ensure that your file executes and the database table displays on the screen.
    • If you have a correct connect command but you get the error message "MySQL ERROR 1045 (28000): Access denied for user" you will have to create a new password with the box "Change password in other modules?" checked.
    • There is a supplied image in the Doc Sharing that provides an example of how your index.php page should look. Note: Feel free to add any additional formatting or images to your index.php page.

    STEP 4: Build, Update PHP Pages
    Building Your update.php and update_data.php Pages
    In this step, you will complete two php HTML pages. Your update.php page will provide a form for users to submit data to the database that will be updated. The update_data.php page will provide the actual queries in php to update the data in your database. When this process is complete, your page will redirect the user back to the index.php page.
    • Review the update_data.php page template.
    • You will need to modify the php code to add additional input forms for the user to enter all appropriate attributes that will need to be updated.
    • In the update_data.php file, ensure that your <form action> tag is set equal to update.php
    • Character data should have a character data type.
    • When the action is complete, your page should redirect back to index.php.


    STEP 5: Build Delete PHP Page
    Building Your delete.php Page
    In this step, you will complete the delete.php page. Your delete.php page will process the query that will remove the necessary data for the database. When this process is complete, your page will redirect the user back to the index.php page.
    • Review the delete.php page template.
    • You will need to modify the php code to delete the provided entry based on the address id.
    • When the action is complete, your page should redirect back to index.php.


    STEP 6: Test Links to Update, Delete, and Insert Pages. Submit Deliverables.
    Finishing Your Web-Enabled Database
    Before submitting, ensure that you have added at least 5 entries to your Addressbook database.
    Ensure that all links for update, delete, and insert work properly.
    When you are done, submit your web-link to your index.php (e.g. http://devry.edupe.net/~####/index.php), If your web pages do not work according to the rubric below you can submit a zip file titled Lab4_FirstInitialLastName.zip which should contain your six php code pages and your database script for possible partial credit,
    Rubric
    Points will be awarded according to the following rubrics.
    • 10 points: Script and Table created for the MyAddressbook entity as described in the Data Dictionary.
    • 10 points: index.php created that correctly displays the contents of the database.
    • 10 points: insert.php and insert_data.php pages created that correctly add data to the database.
    • 10 points: update.php and update_data.php pages created that correctly update the data in the database.
    • 10 Points: delete.php page created that correctly removes an entry from the database.
    For a more advanced optional lab experience you can add error checking and comments and better appearance to the code. Use Chapter 11 as a guide.

    Learn More

Items 11 to 17 of 17 total

per page
Page:
  1. 1
  2. 2

Grid  List 

Set Descending Direction