(1) to retrieve the name for the record of li gang,
(code will run successfully paste here)
(2) to retrieve older than 20 boys name and student id,
(code will run successfully paste here)
(3) retrieval "li gang" "li li" basic information (student id, name, age)
(code will run successfully paste here)
(4) retrieve each number of elective courses
(code will run successfully paste here)
(5) to retrieve the least number of elective course number,
(code will run successfully paste here)
(6) retrieval to retrieve the average score of "database principle" course,
(code will run successfully paste here)
(7) to retrieve the average score less than 75 student's student id,
(code will run successfully paste here)
(8) shows a include student id, name, course name, grade report card information,
(code will run successfully paste here)
(9) retrieval "programming" course grade student's name in more than 90 points,
(code will run successfully paste here)
"Higher mathematics" (10) retrieval result fail the student's name,
Second, database operations (50)
(1) use the Transact - SQL database creation "book publishing management, data file called" book publishing management _data while forming. MDF, initial size to 10 m, with a fixed 2 m automatic growth, there is no limit on the maximum, and will be deployed in D disk files; Log file named "_log book publishing management. LDF", initial size is 5 m, 2 m, fixed growth file a maximum of 20 m, the log file deployed in D disk, (10)
(code will run successfully paste here)
(2) in the "book publishing management database to create the following table, table structure is described below, define the main outer code, (10)
The Author information table Author
The field name field shows that the field type length constraint
Author_id author number 10 Pk Char
Varchar 10 Author_name name
The age age int
The address family address varchar 50
Book information table book
The field name field shows that the field type length constraint
Book_no book number 20 Pk Char
Book_name title Varchar 50
Press press Varchar 100
Pub_date publication date datetime
Author_id author number 10 fk1 - Fk Char
(code will run successfully paste here)
(3) query author "a flat" writing book name, (10)
(code will run successfully paste here)
(4) query age is lower than the average age of all the authors of the author's name, title and press, (10)
(code will run successfully paste here)
(5) shows that as the first author most books written by author's last name, (10)
(code will run successfully paste here)
CodePudding user response:
Help children to do homework
How children graduated now!
I know say these boring to be sprayed, but still can't help
