Create a web page where students can submit their specialization choice. They need only the name, specialization and studentid. Start WAMP server, open PHPMyAdmin and create a database "dbfinal". Create a table "tbl_specialization " for storing the name, specialization and sid (studentid). The structure of the table is shown below: Name Туре name varchar(50) sid varchar(10) specialization varchar(50) Create a webpage as shown below that accepts the data from the user and then inserts it in the database table "tbl_specialization ". The page should give a feedback message indicating whether the data has been successfully inserted or not. Specilaization Choice Your Name: Student Id: 9999999 Choose specialization : Software Engineering Database Network Security Submit Now

Create a web page where students can submit their specialization choice. They need only the name, specialization and studentid. Start WAMP server, open PHPMyAdmin and create a database "dbfinal". Create a table "tbl_specialization " for storing the name, specialization and sid (studentid). The structure of the table is shown below: Name Туре name varchar(50) sid varchar(10) specialization varchar(50) Create a webpage as shown below that accepts the data from the user and then inserts it in the database table "tbl_specialization ". The page should give a feedback message indicating whether the data has been successfully inserted or not. Specilaization Choice Your Name: Student Id: 9999999 Choose specialization : Software Engineering Database Network Security Submit Now

Programming with Microsoft Visual Basic 2017

8th Edition

ISBN:9781337102124

Author:Diane Zak

Publisher:Diane Zak

Chapter11: Sql Server Databases

Section: Chapter Questions

Problem 6E

See similar textbooks

Similar questions

Population Database Compile and run CreateCityDB.java which will create a Java DB database named CityDB. The CityDB database will have a table named City, with the following columns: CityName & Population. Their Data Types: CHAR(50) Primary Key & DOUBLE. The CityName column stores the name of a city, and the Population column stores the population of that city. After you run the CreateCityDB.java program, the City table will contain 20 rows with various cities and their populations. Next, create an application that connects to the CityDB database and allows the user to select any of the following operations: Sort the list of cities by population, in ascending order. Sort the list of cities by population, in descending order. Sort the list of cities by name. Get the total population of all the cities. Get the average population of all the cities. Get the highest population. Get the lowest population. CreateCityDB.java import java.sql.*; /** This program creates the CityDB…
In this database we have users that can be two types students or instructors. They have groups and memberships. Any user can post and the post type can be video, photo or text. Here is the table structure: CREATE TABLE USER_ ( USER_ID INT NOT NULL AUTO_INCREMENT, CREATE_DATE DATE NOT NULL, PROF_DESC VARCHAR (100), PROF_PIC VARCHAR(40), LOCATION VARCHAR (40) NOT NULL, PRIMARY KEY (USER_ID) ); CREATE TABLE USER_INFO( USER_ID INT NOT NULL, SU_EMAIL CHAR(18), USER_FNAME VARCHAR(15), USER_LNAME VARCHAR (15), USER_DOB DATE, USER_GENDER CHAR(1), PRIMARY KEY (USER_ID), FOREIGN KEY (USER_ID) REFERENCES USER_(USER_ID) ON UPDATE CASCADE ); CREATE TABLE STUDENT ( SU_ID INT NOT NULL, USER_ID INT NOT NULL, YEAR_ VARCHAR (10), MAJOR VARCHAR (20), LOCATION VARCHAR (40) NOT NULL, PRIMARY KEY (SU_ID), FOREIGN KEY (USER_ID) REFERENCES USER_(USER_ID) ON UPDATE CASCADE ); CREATE TABLE INSTRUCTOR ( SU_ID INT NOT NULL, USER_ID INT NOT NULL, DEPARTMENT VARCHAR (40), INSTR_TYPE VARCHAR (40),…
Access Assignment Problem: JMS TechWizards is a local company that provides technical services to several small businesses in the area. The company currently keeps its technicians and clients’ records on papers. The manager requests you to create a database to store the technician and clients’ information. The following table contains the clients’ information. Client Number Client Name Street City State Postal Code Telephone Number Billed Paid Technician Number AM53 Ashton-Mills 216 Rivard Anderson TX 78077 512-555-4070 $315.50 $255.00 22 AR76 The Artshop 722 Fisher Liberty Corner TX 78080 254-555-0200 $535.00 $565.00 23 BE29 Bert's Supply 5752 Maumee Liberty Corner TX 78080 254-555-2024 $229.50 $0.00 23 DE76 D & E Grocery 464 Linnell Anderson TX 78077 512-555-6050 $485.70…
The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule for Feb 1, 2020 with the lesson date/time, student's first and last names, and the horse's registered name. Order the results in ascending order by lesson date/time, then by the horse's registered name. Make sure unassigned lesson times (student ID is NULL) appear in the results.
assume that a database has a table named Stock, with thefollowing columns:Column Name TypeTrading_Symbol nchar(10)Company_Name nchar(25)Num_Shares intPurchase_Price moneySelling_Price money Write a Select statement that returns the Trading_Symbol column only from the rows where Selling_Price is greater than Purchase_Price and Num_Shares is greater than 100.
Task 6: The StayWell Property Management team considers creating a discount scheme for the property owners with more than one property in the system. You will need to provide all the owner IDs (OWNER_NUM) and the count of properties of the owners with more than one active property in the database. The output columns should be OWNER_NUM and COUNT(*) respectively.
# Question 1#Using the World database, in the city table, insert a new city for the Tasmania district. The city name is ‘Devonport’, #country code is ‘AUS’, district is ‘Tasmania’ and population is 25,387. Remember, the ID is set to auto-increment #and you will not assign a value. You will insert 2 snips for this question: #a. Insert a snip of the construct used. This MUST be a snip of the code used to insert this city into the city table. #b. Run a query to display the entire new row of Devonport inserted in the City table. Insert your snip here:
You have a list of all your contacts details that you would like to store in a database. Your goal is that when a record is inserted in contacts table, you also want this record to be stored (inserted) in a backup table. Assume you have the two tables created: CONTACTS and CONTACTS_BACKUP. These two (2) tables have the same records. The CONTACTS table have the following columns: CONTACT_ID (Primary_Key), FIRSTNAME, LASTNAME and MOBILE_NO. CONTACTS_ID FIRSTNAME LASTNAME MOBILE_NO 1 100 Princess Kim 813023895 2 101 Henry Packer 811257891 3 102 Petrus Johannes 855698712 4 103 Lukas Shilongo 832584691 The CONTACTS_BACKUP table have the same columns and records as the CONTACTS table. CONTACTS_ID FIRSTNAME LASTNAME MOBILE_NO 100 Princess Kim 813023895 2 101 Henry Packer 811257891 3 102 Petrus Johannes 855698712 4 103 Lukas Shilongo 832584691 You now need to keep both tables in sync so that when a record is inserted into the CONTACTS table it should automatically be inserted into…
Write Mysql code for: The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule for Feb 1, 2020 with the lesson date/time, student's first and last names, and the horse's registered name. Order the results in ascending order by lesson date/time, then by the horse's registered name. Make sure unassigned lesson times (student ID is NULL) appear in the results. Hint: Perform a join on the LessonSchedule, Student, and Horse tables, matching the student IDs and horse IDs.
Below is part of a student database for your reference. The primary keys are highlighted in bold. Student (studNo, studlvame, address, mobileNo) Registration (studNo, courseNo, regDate, semester, session) Course (courseNo, courseName, creditHour, level) Project (projNo, projName, courseNo) Assignment (projNo, studNo, startDate, dueDate, hoursSpent) Fill the empty lines (Line 10, 12, 22, 23, 27) with the appropriate PL/SQL code so as to complete the following anonymous block. The anonymous block displays the list of courses taken by a certain student. Allow the user to enter the STUDENT NAME: 1. ACCEPT studname PROMPT 'Enter the student name:' 2. 3. DECLARE 4. v_cid course.courseno%TYPE; 5. V_sname student.studname%TYPE:= '&studname; 6. V_cname course.coursename%TYPE; 7. 8. CURSOR course_list IS 9. SELECT c.courseno, c.coursename 10. 11. WHERE s.studno = r.studno 12. 13. AND studname = V_sname; 14. 15. BEGIN 16. 17. OPEN course_list; 18. 19. DBMS_OUTPUT.PUT_LINE(List of courses for…
Problem: JMS TechWizards is a local company that provides technical services to several small businesses in the area. The company currently keeps its technicians and clients’ records on papers. The manager requests you to create a database to store the technician and clients’ information. The following table contains the clients’ information. Client Number Client Name Street City State Postal Code Telephone Number Billed Paid Technician Number AM53 Ashton-Mills 216 Rivard Anderson TX 78077 512-555-4070 $315.50 $255.00 22 AR76 The Artshop 722 Fisher Liberty Corner TX 78080 254-555-0200 $535.00 $565.00 23 BE29 Bert's Supply 5752 Maumee Liberty Corner TX 78080 254-555-2024 $229.50 $0.00 23 DE76 D & E Grocery 464 Linnell Anderson TX 78077 512-555-6050 $485.70 $400.00 29 GR56 Grant Cleaners 737 Allard Kingston TX 78084 512-555-1231 $215.00 $225.00 22…
Sales Database: Customers(custId, lastName, firstName, address, phone, creditLimit) Orders(ordNumber, itemNumber, qtyOrdered.) Items(itemNumber, itemName, price) For the Sales Database referenced above, write the SQL command to create the LineItem table, assuming the Orders table and items table already exist.