Question: 1 E REATE TABLE Student. StudentId INT NOT NULL AUTO INCREMENT, Firstname VARCHAR (45) NULL DEFAULT'', 4 Lastname VARCHAR(45) NULL DEFAULT ', Address, VARCHAR(45) NULL

1 E REATE TABLE "Student. StudentId INT NOT NULL AUTO INCREMENT, Firstname VARCHAR (45) NULL DEFAULT'', 4 Lastname VARCHAR(45) NULL DEFAULT '", Address,

1 E REATE TABLE "Student. StudentId INT NOT NULL AUTO INCREMENT, Firstname VARCHAR (45) NULL DEFAULT'', 4 Lastname VARCHAR(45) NULL DEFAULT '", Address, VARCHAR(45) NULL DEFAULT City VARCHAR (45) NULL DEFAULT, State VARCHAR (2) NULL DEFAULT'", 9 10 Postcode. VARCHAR(45) NULL DEFAULT .. Email' VARCHAR (128) NULL DEFAULT", PhoneNo VARCHAR (15) NULL DEFAULT ", PRIMARY KEY ( StudentId), UNIQUE INDEX KEY1 FirstnameASC, Lastname)); 12 13 14 15 16 17 18 19 20 21 CREATE TABLE , Course-Student-Linker" LinkerId INT NOT NULL AUTO_INCREMENT, StudentId INT NOT NULL DEFAULT e, CourseId INT NOT NULL DEFAULT , PRIMARY KEY (LinkerId)); CREATE TABLE StudentGrades 23 24 25 26 27 RowId INT NOT NULL AUTO INCREMENT, LinkerId INT NOT NULL, StudentId INT NOT NULL, GradeRecieved CHAR(2) NOT NULL DEFAULT , SemesterTaken VARCHAR(45) NOT NULL DEFAULT'', PRIMARY KEY RowId)) 1 E REATE TABLE "Student. StudentId INT NOT NULL AUTO INCREMENT, Firstname VARCHAR (45) NULL DEFAULT'', 4 Lastname VARCHAR(45) NULL DEFAULT '", Address, VARCHAR(45) NULL DEFAULT City VARCHAR (45) NULL DEFAULT, State VARCHAR (2) NULL DEFAULT'", 9 10 Postcode. VARCHAR(45) NULL DEFAULT .. Email' VARCHAR (128) NULL DEFAULT", PhoneNo VARCHAR (15) NULL DEFAULT ", PRIMARY KEY ( StudentId), UNIQUE INDEX KEY1 FirstnameASC, Lastname)); 12 13 14 15 16 17 18 19 20 21 CREATE TABLE , Course-Student-Linker" LinkerId INT NOT NULL AUTO_INCREMENT, StudentId INT NOT NULL DEFAULT e, CourseId INT NOT NULL DEFAULT , PRIMARY KEY (LinkerId)); CREATE TABLE StudentGrades 23 24 25 26 27 RowId INT NOT NULL AUTO INCREMENT, LinkerId INT NOT NULL, StudentId INT NOT NULL, GradeRecieved CHAR(2) NOT NULL DEFAULT , SemesterTaken VARCHAR(45) NOT NULL DEFAULT'', PRIMARY KEY RowId))

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!

THIS IS TO BE THE CODE FOR THE BELOW SCRIPT AND QUESTIONS. MYSQL ONLY NOTHING DIFFERENT. I am a beginner and just learning. Thank you 1. Type and execute the commands to describe the students,...

I need help writing the code in Codio with the instructions attached. I also attached a screenshot of the error code that I was given. Terminal X mysql> USE QuantigrationRMA; Reading table...

1.What is relationships do Steven Kings dependents have with them? 2.How many dependents are in Canada? 3. How many dependents are in Seattle? 4.How many employees do not have children? 5. Which...

Provide the $QL for the following data requests. Your SQL should be written as a single script that can be pasted into MySQL and run without edits. Make sure you use the proper notation for your...

SQL Help This question uses the code in Schedule.sql. The query below is intended to calculate how much each enrolled student will owe for each Winter 2003 course he's taking, assuming that each...

Limit to 1000 rows 1 E CREATE Table Course ( 2 CourseRowId int (11) NOT NULL AUTO INCREMENT, CourseId varchar (15) NOT NULL DEFAULT, InstructorId int (11) NOT NULL DEFAULT '0, CreditHrs' int(11) NOT...

Narrative/Case Study For this lab, you will be creating SQL statements to build a series of relational tables, using SQL CREATE statements in a script file format for the Student Database. You will...

Part-1 Create new database, table and populate table from CSV file. For this lab you will work from the MySQL command line to create and new database, add a table with fields, populate the table and...

Need help with these questions. MySQL Q12: List the names of all member(s) from California and the names of the salespeople that they work with. Q13: List the names of all artists who have recorded...

Design the following queries. (MySql) For each title id, report the number of sound files (Mp3 file and the realaud file, use UNION ALL ) The following is the date:...

During 2012, Pierport Inc. has monthly cash expenses of $400,000. On December 31, 2012, the cash balance is $3,600,000. a. Compute the ratio of cash to monthly cash expenses. b. Based on (a), what...

A journal bearing with a diameter of 200 mm and length 150 mm carries a load of 20 kN, when the journal speed is 150 r.p.m. The diametral clearance ratio is 0.0015. If possible, the bearing is to...

Process costing would not be used by which of the following companies? A . Coca - Cola, soft drink manufacturer B . American Custom Yachts, Inc, manufacturer of custom yachts C . Jelly Belly,...

what are the factors that shape your organization external competitiveness to recruit and retain employees

A proposal was put forward in 2012 by the Coalition government that would allow employers in small and medium- sized businesses to offer shares in the company in exchange for giving up their rights...

In the Meteor case study, how reasonable do you think were the terms of the redundancy package? Look up the tribunal cases referring to relocation and equal opportunities. Do you think that the high...

Consider spotlight on the law 4.2 and decide: What was the basis upon which Wilson had been dismissed out of the four admissible reasons? Do you think he was successful in his claim? What is the...