Consider the following database outline: ZIPCODE (Zip, City, State) STUDENT (StudentID, FirstName, LastName, Address, Zip, Phone, Email, ExpectedGradDate) Zip foreign key to ZIPCODE EMPLOYER (EmployerID, Name, Address, Zip, MainPhone) Zip foreign key to ZIPCODE RECRUITER (RecruiterID, FirstName, LastName, Address, Zip, Phone, Email, EmployerID) EmployerID foreign key to EMPLOYER Zip foreign key to ZIPCODE INTERVIEW (InterviewID, ScheduledStart, ActualStart, Scheduled End, ActualEnd, RoomNumber, Comments, StudentID, RecruiterID) StudentID foreign key to STUDENT RecruiterID foreign key to RECRUITER It is recommended that you watch the videos on MySQL workbench and work on this part of the assignment simultaneously. When creating a database in MySQL it is important to follow the following sequence of steps in order to prevent issues: Create the database (schema) -> Create all tables and their columns -> Create the foreign keys -> Add data to the tables.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
What to submit:
The .sql obtained after exporting the database;
The pdf with the relationships diagram.
Questions
Consider the following database outline:
ZIPCODE (Zip, City, State)
STUDENT (StudentID, FirstName, LastName, Address, Zip, Phone, Email, Expected GradDate)
Zip foreign key to ZIPCODE
EMPLOYER (EmployerID, Name, Address, Zip, MainPhone)
Zip foreign key to ZIPCODE
RECRUITER (RecruiterID, FirstName, LastName, Address, Zip, Phone, Email, EmployerID)
EmployerID foreign key to EMPLOYER
Zip foreign key to ZIPCODE
INTERVIEW (InterviewID, ScheduledStart, ActualStart, Scheduled End, Actual End,
RoomNumber, Comments, StudentID, RecruiterID)
StudentID foreign key to STUDENT
RecruiterID foreign key to RECRUITER
It is recommended that you watch the videos on MySQL workbench and work on this part of
the assignment simultaneously.
When creating a database in MySQL it is important to follow the following sequence of steps in
order to prevent issues: Create the database (schema) -> Create all tables and their columns ->
Create the foreign keys -> Add data to the tables.
Transcribed Image Text:What to submit: The .sql obtained after exporting the database; The pdf with the relationships diagram. Questions Consider the following database outline: ZIPCODE (Zip, City, State) STUDENT (StudentID, FirstName, LastName, Address, Zip, Phone, Email, Expected GradDate) Zip foreign key to ZIPCODE EMPLOYER (EmployerID, Name, Address, Zip, MainPhone) Zip foreign key to ZIPCODE RECRUITER (RecruiterID, FirstName, LastName, Address, Zip, Phone, Email, EmployerID) EmployerID foreign key to EMPLOYER Zip foreign key to ZIPCODE INTERVIEW (InterviewID, ScheduledStart, ActualStart, Scheduled End, Actual End, RoomNumber, Comments, StudentID, RecruiterID) StudentID foreign key to STUDENT RecruiterID foreign key to RECRUITER It is recommended that you watch the videos on MySQL workbench and work on this part of the assignment simultaneously. When creating a database in MySQL it is important to follow the following sequence of steps in order to prevent issues: Create the database (schema) -> Create all tables and their columns -> Create the foreign keys -> Add data to the tables.
When creating a database in MySQL it is important to follow the following sequence of steps in
order to prevent issues: Create the database (schema) -> Create all tables and their columns ->
Create the foreign keys -> Add data to the tables.
1. Start by creating a schema in MySQL workbench to hold the database above.
2. Create each table and respective columns. Make sure you assign a suitable data type for
each column. Do not forget to assign the primary key for each table, and recall that the data
type of a foreign key must be the same as the data type of the primary key it corresponds to.
Before proceeding to the next step, make sure the tables you created are correct. It may be
helpful to close all tables you created, and open them again, to make sure everything is as you
expect.
3. Create the foreign keys.
Before proceeding to the next step, make sure the modifications you made in the tables are
correct. It may be helpful to close the tables you created, and open them again, to make sure
everything is as you expect.
4. Enter some data: at least three records in each table.
5. Export the database you created (follow the instructions I provided on this). A .sql file will be
created. After you export the database, import it back to MySQL Workbench to make sure it
works (again follow the instructions). Do not edit the .sql file. You will submit this file.
6. In MySQL Workbench, create the ER diagram of the database and export it to a PDF. You will
submit this PDF.
Transcribed Image Text:When creating a database in MySQL it is important to follow the following sequence of steps in order to prevent issues: Create the database (schema) -> Create all tables and their columns -> Create the foreign keys -> Add data to the tables. 1. Start by creating a schema in MySQL workbench to hold the database above. 2. Create each table and respective columns. Make sure you assign a suitable data type for each column. Do not forget to assign the primary key for each table, and recall that the data type of a foreign key must be the same as the data type of the primary key it corresponds to. Before proceeding to the next step, make sure the tables you created are correct. It may be helpful to close all tables you created, and open them again, to make sure everything is as you expect. 3. Create the foreign keys. Before proceeding to the next step, make sure the modifications you made in the tables are correct. It may be helpful to close the tables you created, and open them again, to make sure everything is as you expect. 4. Enter some data: at least three records in each table. 5. Export the database you created (follow the instructions I provided on this). A .sql file will be created. After you export the database, import it back to MySQL Workbench to make sure it works (again follow the instructions). Do not edit the .sql file. You will submit this file. 6. In MySQL Workbench, create the ER diagram of the database and export it to a PDF. You will submit this PDF.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY