Extra exercises for Murach¡¯s Beginning Java with Eclipse Chapter 20 Extra Exercise:
Create the Survey Database and Tables
In this exercise you¡¯ll create a SQLite database to store the data collected by the StudentSurveyApp illustrated below:
1. Use DB Browser for SQLite to create a database named Survey.sqlite.
2. Within the Survey database, create a Student table. The Student table will use a six- digit numeric student ID as its primary key and will store the first name, last name, country, and year that were entered on the survey. All fields should not allow null values.
3. Create a second table named Skills. Each row of the Skills table will store a student ID and one of the skills that was selected by the student. There may be several skills for the same student so both the student ID and the skill will serve as the primary key for this table. All fields should not allow null values.
Extra exercises for Murach¡¯s Beginning Java with Eclipse
4.
5.
Use SQL to enter the following data into the Student table:
Use SQL to enter the following data into the Skills table:
ID
First Name
Last Name
Country
Year
123456
Rick
Stevens
United Kingdom
Sophomore
654321
Nubia
Arafa
Egypt
Senior
ID
Skill
123456
SQL
123456
Python
654321
SQL
654321
Java
654321
Android
6.
Save the SQL in a file named Survey.sql