Reference no: EM131548527
Please submit SQL statements as text file. You do not need to show screen shot. Make sure you have tested your SQL statements in Oracle.
Problem 1. Please create the following tables with appropriate primary keys & foreign keys.
The database stores information about First Lego League (A robotic competition organized by Lego).
The list of tables:
- Team table with 5 columns: tid (team ID), tname (team name), coach (coach name), cphone (coach phone), state (team state).
- Team_member table with 4 columns: mid (team member id), tid (team id), mname (member name), mage (member age).
- Competition table with 5 columns: cid (competition id), cname (name of the competition), state (state), location (location of competition), cdate (date of competition)
- Team_competition table with 3 columns: tid (team id), cid (competition id), ranking (ranking of the team in the competition, the top few teams will enter competition in the next level).
Problem 2. Insert at least three rows of data to each table. Make sure you keep the primary key and foreign key constraints.
Problem 3. Please write ONE SQL statement for each of the following tasks using tables created in Problem 1. You can ONLY use conditions listed in the task description. For example, you CANNOT manually look up the tid of electrons in task 3.
Task 1: Return the total number of teams
Task 2: Return the name of the team coached by Susan.
Task 3: Return the names of members in the team electrons.
Task 4: Return the names competition the team 'electrons' has participated and the team's ranking in each such competition
Task 5: Return the number of teams participated in each competition along with the name and date of the competition.
Task 6: Return the name of the team that has at least 4 members.
|
Application to calculate ticket prices
: TicketsRUs needs an application to calculate ticket prices. There are three ticket prices:
|
|
What type of mental health agency would you start
: P.S my mental health agency serves people with autoimmune diseases, my focusis Multiple Sclerosis, my services would offer resources to help combat.
|
|
Legal aspects of information technology
: This week, you examined the legal aspects of information technology in regards to intellectual property, copyrights, and illegal software.
|
|
Develop communication strategies
: Identify the target group for your research and provide an overview of their location in the workplace.
|
|
Information about first lego league
: Please submit SQL statements as text file. You do not need to show screen shot. Make sure you have tested your SQL statements in Oracle.
|
|
Analyze how a cultural product constructs gender
: To demonstrate knowledge of the ways in which gender is socially constructed and maintained through culture, and to illustrate mastery of the core concepts.
|
|
How much did the company spend on new property plant
: how much did the company spend on new property plant, and equipment during 2014?
|
|
Describe the design principle used to create the art
: Describe the design principle used to create the art. What is the focal point? How is unity or harmony achieved (color, proximity, rhythm, repetition)? Explain
|
|
Given particular set of project cash flows
: Given a particular set of project cash flows, which one of the following statements must be correct?
|