Create the database and data table, and complete the following related topic
A few basic entity table can store student, class, courses, teachers, don't believe related
Write the data table (including the relational tables not listed, other tables) create statement (table attributes can be reference to the following questions in detail completion)
Assume that all of the following issues related to data tables are
1. When to find students information at the same time, can list the teacher in charge information
2. To find the student's name for XXX
3. To find students scores greater than 80
4. Look for the teacher of people younger than 30 years
5. Look for the teacher's name, age, e - mai which is suitable for xx years old age is not the teacher
6. Look for students to score 80 points or 90
7. 88 points and sex to male students find students
8. Find out students' scores between 90-100 of all the students
9. To find out the name of lee teacher
10. Find out the teacher use email for lang
11. Find out the teacher's number is 159 at the beginning of
12. The teacher age from high to low
13. Check out each student teacher in charge teacher, list only the student's name, age, the teacher's name, phone
14. The query out the student's name, gender, e_mail, teacher's name, age, e_mail
15. The students age groups show
16. To find out the age of the students is 19 years old, and 19 people to find a man called Wang Xue
The student age is 17. Query out
18. The eldest of the teacher listed 3 people
19. All the mathematics student information
20. The query miss li taught course number, course name
21. The query older than 20 year-old female classmate student number and name
22. The query student id for all 'H0301 students' elective course grade
23. The query average score 80 points or more students, student number and average score
24. The query elective courses at least six others,
25. The query our fleet course Max out the student's student id number
26. The query student id for 'J0101' students elective course number and name
27. 'all' Li Xiaobo elective course name
28. All results in more than 70 points of the student's name and department
29. The English better than math student
More than 30. Take at least two courses and the student's name and gender
31. Took Mr Li said the number of students in courses
32. "data structure" course get high score of students' names, gender and department
33. To display all courses of study situation
34. Take out without taking "data structure" course of student's name and age
35. No students of miss li said course
36. No students of course Mr Li and Mr Wang says
37. The retrieval courses at least "data structure" and "C" student
38. The retrieval courses for our fleet student student id number, name and department
Retrieval courses C01 or our fleet student student id number, name and department
CodePudding user response:
Apparently, this is according to the nearly 40 topics to create table structure.1. When to find students information at the same time, can list the teacher in charge information
Have students table, this table contains the class information
Have a class table, the table contains information about the teacher in charge
Has the teacher table
Has the subject table, the table contains information about the teacher, the class information
2. To find the student's name for XXX
Have students table, this table contains the student's name
3. To find students scores greater than 80
Students have a score table, the table contains information (e.g., student ID), course information, such as the subject ID), performance information (score), the test batch
Anyhow after completion of all table structure according to this way, the table is created, after the query is very simple
CodePudding user response:
Which is not you? Which one which don't ask, don't be so suddenly thrown upCodePudding user response:
a jilt you up and I also can't ah