Subject Code: CSC3400/CSC8500 Internal Code: 1AGJEG

IT Assignment Help

TASK: Answer the following questions in a word processing document, export the document as a PDF file, and submit via the course web site. For mathematical symbols, you can normally use the “Symbols” font that is available in your word processor. If you are unable to create a join (./) symbol, you may simulate it as |><|. The relational schema shown in Figure 1 models a very simple database for a Debating club. In a debating contest, one debater starts and is followed by his opponent who ends the contest. Debaters are both given points by an independent jury. The debater with the most points wins; draws are possible. It is assumed that not all the debaters in Debater relation participate in the contest. The following two Foreign Keys exist in the schema: FK Contest(starter) references Debater(name) FK Contest(ender) references Debater(name) For all the questions in this assignment, please include screen snapshots of the query results you obtain from XAMPP server. This is important for demonstrating your ability in running your queries on a real-life database platform. We accept query results from other relational database platforms as well. Note that a large portion of marks will be deducted if the snapshots are missing in your answers. The screen snapshots should capture the screen area covering both the SQL statement and the output result. The screen snapshots should be consistent with the output of the SQL answers provided. A test dataset is provided which can be downloaded under the instruction of the assignment on the Studydesk. Please kindly note that all the students should only use this test dataset for testing their SQL answers and preparing the screen snapshots. Other test dataset is NOT allowed and you may lose some significant marks if you do so. Other than XAMPP server, you can also use other relational database systems for completing this assignment. It is not allowed to have hardcoded SQL answers, meaning that your answers should be general enough to deal with other possible data in the test dataset used. It is not allowed either to use SQL with the flow of control feature to answer the questions in the assignment. (a) Give the names of the starting and the end debaters of the contests where the starting debater is a member of the Plato or Storm club and prevented his opponent from scoring any points. (It is required that the selection symbol appear only once in the relational algebra expression for this query) (b) List the names of debaters won at least one contest. (c) List the names of clubs as well as the number of members in each club. (d) Give the name, club, and age of all debaters who have lost one or more debates as a starter.
This IT Assessment has been solved by our IT experts at UniLearnO. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style. Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : Keith
  • Posted on : April 22nd, 2018
Hire A Tutor
loader

Whatsapp Tap to ChatGet instant assistance