Defining the foreign key
A mysql prompt has been opened for you.
Using the college database,...
![subject](/tpl/images/cats/informatica.png)
Computers and Technology, 28.07.2020 20:01 christian2510
Defining the foreign key
A mysql prompt has been opened for you.
Using the college database, complete the following tasks (use either a single-line or a multi-line SQL statement):
Create a classrooms table with this definition (try using a multi-line SQL statement):
Field | Type | Null | Key | Default | Extra |
| id | int(3) unsigned | NO | PRI | NULL | auto_increment |
| room_num | int(4) unsigned | NO | UNI | NULL | |
| course_id | int(3) unsigned | YES | MUL | NULL | |
![ansver](/tpl/images/cats/User.png)
Answers: 3
![](/tpl/images/ask_question.png)
![](/tpl/images/ask_question_mob.png)
Another question on Computers and Technology
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 21.06.2019 18:00
Which if the following allows you to view and access important information about your documents all in one location
Answers: 3
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 22:30
Jason needs to learn a new web tool. he went through his books to understand more about it. now he wants hands-on experience with using that tool. what would him? jason can use websites where workspace is provided to test the results of your code.
Answers: 2
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 01:30
For a typical middle-income family, what is the estimated cost of raising a child to the age of 18? $145,500 $245,340 $304,340 $455,500
Answers: 2
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 09:00
What provides an array of buttons for quick access to commonly used commands and tools
Answers: 1
You know the right answer?
Questions
![question](/tpl/images/cats/istoriya.png)
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/en.png)
English, 03.11.2020 09:30
![question](/tpl/images/cats/health.png)
![question](/tpl/images/cats/istoriya.png)
History, 03.11.2020 09:30
![question](/tpl/images/cats/biologiya.png)
Biology, 03.11.2020 09:30
![question](/tpl/images/cats/biologiya.png)
![question](/tpl/images/cats/health.png)
Health, 03.11.2020 09:30
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/biologiya.png)
![question](/tpl/images/cats/istoriya.png)
History, 03.11.2020 09:30
![question](/tpl/images/cats/mat.png)
Mathematics, 03.11.2020 09:30
![question](/tpl/images/cats/fizika.png)
Physics, 03.11.2020 09:30
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 03.11.2020 09:30
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/es.png)
Spanish, 03.11.2020 09:30
![question](/tpl/images/cats/mkx.png)
Arts, 03.11.2020 09:30
![question](/tpl/images/cats/mat.png)
Mathematics, 03.11.2020 09:30