Home > database >  Database is a small white for help
Database is a small white for help

Time:10-10

Create a name for the information database, the database contains several tables: the teacher, course, TCC, sc, which are listed in the table information please see the Excel document, note there are corresponding constraints under the corresponding column, please help him to create this four tables to information database
2. Due to the need of educational administration, now you need to join jw_ before each table name, such as the first table the teacher to change jw_teacher and so on, please help him to modify the name of the table to the correct format (2 points);
3. Please help him to go to the four corresponding data table to add, add data see
Teacher's name (tea_name) course name (course_name) class name (class_name) term (term) the commencement of the venue (room_place)
Li hong mechanical drawing 03 mould 05 - '06 last semester 10 # 708
Zhang Li metal technology of the mould 05-06 last semester 10 # 707
Lm hong operating system 03 network 05-06 last semester 10 # 608
Lm hong VB 03 programming 05-06 last semester 10 # 605
Liu fang on the operating system the programming 05-06 term 5 # 405
05-06 Zhao Qing database principle 03 programming last semester 10 # 508
Zhang Ming mold electricity the electric 05-06 last semester 5 # 108
Li yong electrician principle 03 electric 05-06 # 5 last semester 208


Primary key primary key primary key not null

4. Please help him to complete the following query tasks, shows the results of the corresponding
(1) query the title is a lecturer and electrical system in teachers information
(2) query teachers name for a course name, course of the semester and venue
(3) query period of more than 80, and the inspection way as the test, or a period of more than 100, and the inspection way of course for the exam

CodePudding user response:

  • Related