Please Use ORACLE SQL
In this application, you will be adding/registering an item, updating it, and doing select statements. You get to pick what you are registering. It can be students, employees, patients, books, cars, games, movies, music, sports teams, whatever. The form should have the following elements: At least two textboxes. Radio buttons (examples: sex (male, female), transfer student (yes, no), used book or car (yes, no), full time/part time employee) A drop down with at least 4 values, "other" being the last value: (examples: student major, car color, blood type (patient), book genre, employee role) A textblock (comments, optional) Create a table for your application. The naming convention for the table should start with your first and last initial followed by your employeeld_tablename. For example: If Bob Smith (employee number 71234) were to create a table for books, it would be bs71234_books. . In your table, add a numeric primary key (ex: studentld, bookid, etc). You can make it so this value is not input by the user and instead uses an SQL sequence and trigger. Your database should only consist of ONE TABLE! => Use the DbCon class to connect and disconnect to the databasel = min_players) - number(1) min players max players Comments comments - varchar2[1000) this is optional) Search by criteria: Search game by name, Search game by game_style I could have done search for games that can be played by X players) Create the Table Table for my game web app example: create table kc741264_games game_id number(12) primary key, game_name varchar2(80) not null, game_company varchar2(40) not null, game_type varchar2(11) not null, game_style varchar2(30) not null, min_players number(1), max_players number(1), comments varchar(1000) ); Creating the sequence Replace the highlighted text with your first initial, last initial, and primary key column name. CREATE SEQUENCE BS71234_GAME_ID_SEQ MINVALUE 1 START WITH 1 INCREMENT BY 1; Create trigger to auto-increment the ID Replaced the highlighted text to reference your table and sequence. CREATE OR REPLACE TRIGGER BS71234_BOARDGAMES_TR BEFORE INSERT ON BS71234_BOARDGAMES REFERENCING NEW as New OLD as Old FOR EACH ROW WHEN (New.game_id is null) BEGIN new.game_id = BS71234_GAME_ID_SEQ. nextval; END; / ALTER TRIGGER BS71234_BOARDGAMES_TR ENABLE; Adding records to your table Insert some records. Make sure to commit them when you are done! -- Insert records .. add your SQLs here. --Commit the inserts using commit. commit; Making a Gaming Web I mentioned that if you want to make a gaming miniweb, you need to make some changes. You have to make your miniweb different than mine. Here are the options. . . Video Game Web app (the user is the admin of an online gaming store): Text fields: game name, year published, cost to purchase The drop down is the console and can have values like "Playstation 3", "Playstation 4", "Xbox One", "Xbox 360", "Nintendo Wil", "Nintendo Switch", "Other". Radio button can be new or used game OR it can be "disk" or "digital download". Comments can be the game description (what type of game it is OR the condition of game such as "Mint condition"). Specific search criteria (pick 2): Search by console games created after a specific year, games Use the DbCon class to connect and disconnect to the databasel = min_players) - number(1) min players max players Comments comments - varchar2[1000) this is optional) Search by criteria: Search game by name, Search game by game_style I could have done search for games that can be played by X players) Create the Table Table for my game web app example: create table kc741264_games game_id number(12) primary key, game_name varchar2(80) not null, game_company varchar2(40) not null, game_type varchar2(11) not null, game_style varchar2(30) not null, min_players number(1), max_players number(1), comments varchar(1000) ); Creating the sequence Replace the highlighted text with your first initial, last initial, and primary key column name. CREATE SEQUENCE BS71234_GAME_ID_SEQ MINVALUE 1 START WITH 1 INCREMENT BY 1; Create trigger to auto-increment the ID Replaced the highlighted text to reference your table and sequence. CREATE OR REPLACE TRIGGER BS71234_BOARDGAMES_TR BEFORE INSERT ON BS71234_BOARDGAMES REFERENCING NEW as New OLD as Old FOR EACH ROW WHEN (New.game_id is null) BEGIN new.game_id = BS71234_GAME_ID_SEQ. nextval; END; / ALTER TRIGGER BS71234_BOARDGAMES_TR ENABLE; Adding records to your table Insert some records. Make sure to commit them when you are done! -- Insert records .. add your SQLs here. --Commit the inserts using commit. commit; Making a Gaming Web I mentioned that if you want to make a gaming miniweb, you need to make some changes. You have to make your miniweb different than mine. Here are the options. . . Video Game Web app (the user is the admin of an online gaming store): Text fields: game name, year published, cost to purchase The drop down is the console and can have values like "Playstation 3", "Playstation 4", "Xbox One", "Xbox 360", "Nintendo Wil", "Nintendo Switch", "Other". Radio button can be new or used game OR it can be "disk" or "digital download". Comments can be the game description (what type of game it is OR the condition of game such as "Mint condition"). Specific search criteria (pick 2): Search by console games created after a specific year, games
