im using MY SQL Workbench how can i set it up and also please help me write this thank Prepare for SQL Coding

mysql$>$ create database xyz;

Query OK$,1$ row affected $(0\mathrm{.}00$ sec$)$

mysql$>$ use xyz;

Database changed

mysql$>$ CREATE TABLE Course $($

$->$ CrsCode varchar$(7),$

$->$ DeptId varchar$(3),$

$->$ CrsName varchar$(30),$

$->$ Descr varchar$(100),$

$->$ PRIMARY KEY $($CrsCode$),$

$->$ UNIQUE $($DeptId$,$ CrsName$)$

$->)$;

Query OK$,0$ rows affected $(0\mathrm{.}01$ sec$)$

mysql$>$ desc Course;

$+---------+--------------+------+-----+---------+-------+$

$|$ Field $|$ Type $|$ Null $|$ Key $|$ Default $|$ Extra $|$

$+---------+--------------+------+-----+---------+-------+$

$|$ CrsCode $|$ varchar$(7)|$ NO $|$ PRI $|$ NULL $||$

$|$ DeptId $|$ varchar$(3)|$ YES $|$ MUL $|$ NULL $||$

$|$ CrsName $|$ varchar$(30)|$ YES $||$ NULL $||$

$|$ Descr $|$ varchar$(100)|$ YES $||$ NULL $||$

$+---------+--------------+------+-----+---------+-------+$

$4$ rows in set $(0\mathrm{.}00$ sec$)$

mysql$>$ INSERT INTO Course VALUES$(\text{'}$CSCI$001\text{'},\text{'}$CS$\text{'},$ 'BIG DATA I$\text{'},$ 'Introduction to Big Data'$)$;

Query OK$,1$ row affected $(0\mathrm{.}01$ sec$)$

mysql$>$ INSERT INTO Course VALUES$(\text{'}$CSCI$002\text{'},\text{'}$CS$\text{'},$ 'Programming Languages', 'Formal definition of programming languages'$)$;

Query OK$,1$ row affected $(0\mathrm{.}00$ sec$)$

mysql$>$ SELECT $*$ FROM Course;

$+---------+--------+-----------------------+--------------------------------------------+$

$|$ CrsCode $|$ DeptId $|$ CrsName $|$ Descr $|$

$+---------+--------+-----------------------+--------------------------------------------+$

$|$ CSCI$002|$ CS $|$ Programming Languages $|$ Formal definition of programming languages $|$

$|$ CSCI$001|$ CS $|$ BIG DATA I $|$ Introduction to Big Data $|$

$+---------+--------+-----------------------+--------------------------------------------+$

$2$ rows in set $(0\mathrm{.}00$ sec$)$

mysql$>$ CREATE TABLE Professor $($

$->$ Id integer PRIMARY KEY,

$->$ Name varchar$(25),$

$->$ DeptId varchar$(3)$

$->)$;

Query OK$,0$ rows affected $(0\mathrm{.}00$ sec$)$

mysql$>$ DESC Professor;

$+--------+-------------+------+-----+---------+-------+$

$|$ Field $|$ Type $|$ Null $|$ Key $|$ Default $|$ Extra $|$

$+--------+-------------+------+-----+---------+-------+$

$|$ Id $|$ int$(11)|$ NO $|$ PRI $|$ NULL $||$

$|$ Name $|$ varchar$(25)|$ YES $||$ NULL $||$

$|$ DeptId $|$ varchar$(3)|$ YES $||$ NULL $||$

$+--------+-------------+------+-----+---------+-------+$

$3$ rows in set $(0\mathrm{.}01$ sec$)$

mysql$>$ INSERT INTO Professor VALUES $(1,$ 'Weitian Tong', $\text{'}$CS$\text{'})$;

Query OK$,1$ row affected $(0\mathrm{.}00$ sec$)$

mysql$>$ CREATE TABLE Teaching $($

$->$ ProfId integer,

$->$ CrsCode varchar$(7),$

$->$ Semester varchar$(6),$

$->$ PRIMARY KEY $($CrsCode$,$ Semester$),$

$->$ FOREIGN KEY $($CrsCode$)$ REFERENCES Course $($CrsCode$),$

$->$ FOREIGN KEY $($ProfId$)$ REFERENCES Professor $($Id$)$

$->)$;

Query OK$,0$ rows affected $(0\mathrm{.}00$ sec$)$

mysql$>$ desc Teaching;

$+----------+------------+------+-----+---------+-------+$

$|$ Field $|$ Type $|$ Null $|$ Key $|$ Default $|$ Extra $|$

$+----------+------------+------+-----+---------+-------+$

$|$ ProfId $|$ int$(11)|$ YES $|$ MUL $|$ NULL $||$

$|$ CrsCode $|$ varchar$(7)|$ NO $|$ PRI $|$ NULL $||$

$|$ Semester $|$ varchar$(6)|$ NO $|$ PRI $|$ NULL $||$

$+----------+------------+------+-----+---------+-------+$

$3$ rows in set $(0\mathrm{.}00$ sec$)$

mysql$>$ INSERT INTO Teaching VALUES$(1,$ 'CSCI$001\text{'},\text{'}$S$2023\text{'})$;

Query OK$,1$ row affected $(0\mathrm{.}00$ sec$)$

mysql$>$ SELECT $*$ FROM Teaching;

$+--------+---------+----------+$

$|$ ProfId $|$ CrsCode $|$ Semeste

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

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 Programming Questions!

Q:

mysql questions. All questions are linked. Even if the pictures are blurry please help write the commands for the questions at least QUNSTION: Pandai Sdn Bhd is a company that runs a tuition center...

Q:

ok so im trying to create a database for a website that handles university classes but am having trouble in my sql ER DIAGRAM SHOWN BELOW can someone please help my write the mySQL query to create...

Q:

PLEASE HELP TO ANSWER THIS PROJECT Database and Tools - Database: Oracle Database 19. Same DB that we use in class. The DB and user information already provided to each student. All work should be...

Q:

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Q:

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Q:

I am working on my final project in an SQL class using MYSQL. I am working my way through it but it is going slow so I think that I may need a little bit of help to finish in time. If I could get a...

Q:

Please help to modify the whole Lab 03 code follow the Introduction, thank you so much! Lab 3 code: bank-Detail.csv ID12101,48,FEMALE,INNER_CITY,22467,YES,0,YES,YES,NO,YES,YES...

Q:

CIS 205 Final Project Summer 2018 The final assignment consists of separating a database project into the phases that were outline during the semester. The project should be completed with the...

Q:

Please help me explain #1 - 4 of the word document part. Thank you Goal of this assignment: Practice simple SQL statements by creating, loading, exporting and importing the EMPLOYEE table in the...

Q:

Part I: Database Design Established in 1914, ABC-books is well-known in Acera, Kumasi and Tamale. The shop has operated manually since its inception, however, since 2000 ABC -books has witnessed a...

Q:

What is a treaty? Where does the treaty power of the United States come from? What is the difference between a self-executing treaty and a non-self executing treaty? How does the treaty approval...

Q:

Calculate and plot the radial and circumferential stress distribution in the left ventricle at the end of systole (P- 80 mmHg, assume the ventricle is spherical). The inner radius of the heart is 3.2...

Q:

Income Statement, Cost of Services Provided, Service Attributes Berry Company is an architectural firm located in Detroit, Michigan. The company works with small and medium-size construction...

Q:

6. Mababa ang pangkalahatang demand ng sambahayan.

Previous Question Next Question