Question: Enter 10 personal information. Description: Use Java to compile a general employee information system. Suppose there are information such as name, gender, date of birth,


Enter 10 personal information.
Description: Use Java to compile a general employee information system. Suppose there are information such as name, gender, date of birth, age, occupation, marriage or not (the information is added through the background and cannot be statically displayed on the page) background managers can flexibly add question items and types. 1. SQL to establish a database (ORACLE can also) (20 points) Basic information of employees NO number A1 name A2 gender 1 male 2 female A3 Date of Birth Year Month Day A4 Occupation 1 Worker 2 Farmer 3 PLA A5 Marital status 1 Married 2 Unmarried B1 height CM B2 weight KG C1 those diseases (multiple choice) A diabetes B high blood pressure C heart disease N1 survey date year month day The database format requirements are as follows: Tip: The above is the structure required for designing a general entry interface. Note that there are 3 categories in the table: A, B, and C. Create the following fields in the data table structure (at least the following fields are required): First pesonal Informotiert Remades) content coding Value serial number Al yang san 1 A2 1925/211 A3 * * A li Sang Second pesonal Information A1 2 A2 2 2 2 1968/1/2 A3 Description: Use Java to compile a general employee information system. Suppose there are information such as name, gender, date of birth, age, occupation, marriage or not (the information is added through the background and cannot be statically displayed on the page) background managers can flexibly add question items and types. 1. SQL to establish a database (ORACLE can also) (20 points) Basic information of employees NO number A1 name A2 gender 1 male 2 female A3 Date of Birth Year Month Day A4 Occupation 1 Worker 2 Farmer 3 PLA A5 Marital status 1 Married 2 Unmarried B1 height CM B2 weight KG C1 those diseases (multiple choice) A diabetes B high blood pressure C heart disease N1 survey date year month day The database format requirements are as follows: Tip: The above is the structure required for designing a general entry interface. Note that there are 3 categories in the table: A, B, and C. Create the following fields in the data table structure (at least the following fields are required): First pesonal Informotiert Remades) content coding Value serial number Al yang san 1 A2 1925/211 A3 * * A li Sang Second pesonal Information A1 2 A2 2 2 2 1968/1/2 A3
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
