Question: 1) Create a SQL query to create the following table of personal information called StudentInfo. Use you knowledge to determine what columns, datatype, size and

1) Create a SQL query to create the following table of personal information called StudentInfo. Use you knowledge to determine what columns, datatype, size and constraints (i.e. primary key) is needed.

2) Create a SQL query to create the following table of sport player genres called SportGenre (the rating is a number between 1 and 10 you can assign to each genre). Use you knowledge to determine what columns, datatype, size and constraints (i.e. primary key) is needed.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Given the following TAPE table, write the SQL queries to answer each of the following questions. For create statement, assume appropriate datatype and size for the columns. Tape (Tape_Code,...

SESSION: SUMMER 2017 LAB 1B SQL * Plus - CREATING TABLES and CONSTRAINTS FOLLOW INSTRUCTIONS: DO NOT SKIP A SINGLE STEP SECTION I: NOTE: Do not specify any constraints with the create statement...

SESSION: SUMMER 2017 LAB 1B SQL * Plus - CREATING TABLES and CONSTRAINTS Successful people did not attain their success without first overcoming challenges.------- Catherine Pulsifer FOLLOW...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

PART 1: ALREADY COMPLETED. NEED PART 2 Tasks Query Description SQL Statement Create a new database in MySQL called horsestable. List the databases in MySql. Result set should look like: Create...

Please I need help with the Part 3 and 4 Questions of this exercise. Thank you. Exercise: Hotel Schema Overview Hotel Software Guild is a resort hotel on the West Arm of Lake Minnetonka. It is a...

#create and use the TreasureHunter database CREATE DATABASE IF NOT EXISTS `treasurehunters`; USE `treasurehunters`; #create and populate the badge table, which has descriptions of all the types of...

\f6e Foundations in Strategic Management Jeffrey S. Harrison Robins School of Business University of Richmond Caron H. St. John College of Business Administration University of Alabama in Huntsville...

What is the WACC for Cheesecake Factory as of 12/29/09 (using the Capital Asset Pricing Model to determine the cost of equity)?At that time, Cheesecake Factory's stock had a Beta of 1.25 and used a...

Show the structure and stereochemistry of the alcohol that would result if 1, 2-epoxycyclohexane (Problem 18.39) were reduced with lithium aluminum deuteride, LiAID4.

Is flood insurance required in Florida? What does flood insurance cover? Does it pay replacement cost of contents or actual cash value? What is the difference? What is the difference between the nfip...

The theory that an individual's behavior is purposeful - or that sell - interest is the single variable that can explain society. Microveciology Manism Rational Cholce Theory Femillsm

Why do we need security model?

Know the communications mix elements available via service delivery channels.

Know the theoretical foundation from environ-mental psychology that helps us understand how customers and employees respond to service environments.

Describe what is meant by the term managed float. Did the managed-float system precede or follow the adjustablepeg system? Explain.