Logo
Home Study Material Contact Search
AI Chat FREE
  1. computer science
  2. programming
  3. create a table ‘studentinfo’ with fol

Create a table ‘StudentInfo’ with following fields: ID First Name Last Name SSN Date of Birth Create a table ‘ClassInfo’ table: ID Class...

Free

70.2K

Verified Solution

Question

Programming

  1. Create a table ‘StudentInfo’ with following fields:
    1. ID
    2. First Name
    3. Last Name
    4. SSN
    5. Date of Birth
  2. Create a table ‘ClassInfo’ table:
    1. ID
    2. Class Name
    3. Class Description
  3. Create a table ‘RegisteredClasses’ table:
    1. StudentID
    2. ClassID

The RegisteredClasses table should have a foreign keyrelationship to StudentInfo and ClassInfo tables for the respectiveIDs. Also the IDs in StudentInfo and ClassInfo need to be primarykeys.

When you submit the file your email should also contain thefollowing SQL Queries:

  1. Query to show all records from StudentInfo whose first name isJohn
  2. Query to show all records from StudentInfo whose last name isDoe
  3. Query to delete all records from from ClassInfo where classname starts with ‘ISAM'

Answer & Explanation Solved by verified expert
3.7 Ratings (500 Votes)

  • Create a Table StudentInfo

Create table StudentInfo(
StudentID varchar(10) NOT NULL,
FirstName varchar(20),
LastName varchar(20),
SSN int,
DateofBirth DATE,
PRIMARY KEY (StudentID)
);

  • Create a Table ‘ClassInfo’

  Create table ClassInfo(
ClassID varchar(10) NOT NULL,
ClassName varchar(4),
ClassDescription varchar(20),
PRIMARY KEY ( ClassID)
);

  • Create a table ‘RegisteredClasses’​​​​​​​

Create table RegisteredClasses(
FOREIGN KEY (StudentID) REFERENCES Persons(StudentID),
FOREIGN KEY (ClassID) REFERENCES Persons(ClassID)
);

  • Query to show all records from StudentInfo whose first name is John

Select * from StudentInfo
where FirstName=\"John\"

  • Query to show all records from StudentInfo whose last name is Doe

Select * from StudentInfo
where FirstName=\"Doe\"

  • Query to delete all records from from ClassInfo where class name starts with ‘ISAM'

Delete from ClassInfo
WHERE (ClassName REGEXP '^ISAM')
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

The following matrix is in reduced row echelon form. Decode from the matrix the solution of...

Basic Math
Q

)Tabulate how transmission electron microscopy (TEM) differs from traditional light microscopy regarding (a) sample preparation (4), (b)...

Biology
Q

3. Testing for equal proportions Imagine that you are contracted by a local news provider to study...

Basic Math
Q

The temperature of a metal ingot is 60 C above room temperature right now Twenty...

Physics
Q

A mass M is suspended by a spring having a spring constant K In equilibrium...

Physics
Q

Use the graph of y secx to find all values of x 0 sxs 2r...

Basic Math
Q

What comparative information would you want to be able to evaluate Kraft Heinzs operating cycle...

Accounting
Q

Company A had the following transactions during August: ...

Accounting
Q

I have asked for help regarding this problem over four times. Can someone please help...

Accounting
Q

Question 1 Desired ending inventory is 80% of beginning inventory. If cost of goods sold...

Accounting
Q

Current Attempt in Progress On January 1, 2020, Hauke Corporation issued $900,000,6%, 10-year bonds at...

Accounting
Q

Which of the following uncorrected hours would result in both acids and that income being...

Accounting