a11 and a12 and a13

A-11: Try the Testbed

(1) Try the Testbed interface on the sample tables with these queries (one at a time) to get used to it:

show tables;

describe sample1;

describe sample2;

select * from sample1;

select * from sample2;

select sample2.name, city, amount FROM sample2, sample1
where sample2.name = sample1.custname AND industrytype = “B”;

select salesperson from sample2, sample1
where sample2.name = sample1.custname and city = “Manchester”
order by salesperson asc;

Also, try the various buttons and controls on the Testbed webpage to see what they do.

(2) Then, CREATE AND POPULATE THE THREE TABLES AntiqueOwners, Orders, and Antiques as defined in the Hoffman SQL Tutorial. To do this, you will use (at least) the Create Table and Insert commands.

(3) Capture the result of a SELECT * for each of those tables and submit them.

(4) Then, run this join query, also from the Hoffman SQL Tutorial, and capture and submit its result:

select OwnerLastName, OwnerFirstName from AntiqueOwners, Antiques
where BuyerID = OwnerID and Item=”Chair”;

A-12: Run the Antique Buyers query from a PHP program –

Based on the sample PHP program given for running a database query,
write and run a PHP program to perform the Antique Buyers query from the last step of assignment A-11. Name the script “buyers.php” and put it in your samples directory.

Submit your PHP script buyers.php (your .php file but not the others files the instructor gave you that it uses) and a captured sample of its webpage output.

A-13: Tables Design for a Film Showings DB

Given the attached requirements for a Film Showings database, develop and document your detailed plan for what Tables and needed in the database and how those Tables are related to each other.

Use whatever notation or documentation method you have been taught for expressing such a design that will satisfy the requirements of the problem.

DO NOT BUILD and tables in your MySQL database for this assignment. This is an exercise in understanding and designing to meet user requirements and to come up with a workable plan for relational database tables. It is NOT an exercise in building those tables.

Attach you answer as a Word, PDF, Powerpoint, jpg, png, gif, or text document, or some combination (could be several files). Please put your name on the top of the first page of every file of your submission.

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code “Newclient” for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.


The post a11 and a12 and a13 appeared first on Custom Nursing Help.

"Do you need a similar assignment done for you from scratch? We have qualified writers to help you with a guaranteed plagiarism-free A+ quality paper. Discount Code: SUPER50!"

order custom paper

HOW IT WORKS

Submit Paper Details
Issue instructions for your paper in the order form. Include a discount code if you have one. Your account will be created automatically.

Make Your Payment

Your payment is processed by a secure system. We accept PayPal, MasterCard, Visa, Amex, and Discover.

The Writing Process
Communicate with your writer, clarify all the questions with our support team, upload all the necessary files for the writer to use.

Download Completed Paper

Check your paper if it meets your requirements, the editable version. If any changes are needed, send the order for revision.

Important Legal Notice

Using this service is LEGAL and IS NOT prohibited by any university/college policies. You are allowed to use our model academic papers in one of the following ways:

  • To gain additional knowledge about the topic;
  • To refer to the paper as a source of ideas and reasoning, given that appropriate references are provided;
  • To paraphrase the ideas contained in the paper (refer to your school’s policy on plagiarism and academic honesty);
  • To use it for direct citing, given that appropriate references are provided.
Need help with your assignment?

We help students with well-written, original essays before the deadlines.
With more than 50,000 orders completed successfully for students around the world, count on us for your academic needs.

We have a team of professional writers, with vast background knowledge, who follow your specific order details and requirements to complete any writing task you need.

The papers written by our professionals can be used as examples, reference sources, or starting points for more research.

 

Improve your grades
  • Free bibliography page
  • Free outline
  • 915+ certified ENL and ESL writers to choose from
  • Original, fully referenced and formatted writing
  • On-time delivery, or you get a refund
  • Writer is fully qualified in your area of study
  • Writer has your degree level or higher
  • Communicate with your essay writer, a true academic expert, directly
  • Unlimited revision requests within 14 days
  • Plagiarism report to make sure the work is 100% plagiarism free
  • 24/7 instant support by phone, live chat, email, and messaging

© 2021 Topgradeassignments.org provides writing and research services for limited use only. All the materials from our website should be used with proper references and in accordance with Terms & Conditions.