, a student can take part in multiple disciplines race are divided into different levels, can be more than a team to take part in a game, each
Teacher, there can be multiple team competition performance is divided into the first prize, second prize, third prize, each race has the game time,
Name and the organizer, try to design a students' competition management system, able to complete the management of student competition, can achieve
Statistical university institute of each race over a period of time to attend and awards, race over a period of time can also statistics each grade
Participate in and awards of
The experimental requirements:
(1) through the network to find relevant literature and reference to materials demand analysis, draw the system e-r diagram, given real
Body or contact properties, indicate the type of contact, and write the relational schema;
(2) according to the theory of relationship norms for database logical design, the design of the database table.
Database table design format with reference to the following:
Table 1 student table (student)
The field name in Chinese means type constraints note
Sid student id char (6) the primary key
Sname name varcha (20) not null
Sbirth date of birth date null
Smajor professional char (6) null foreign keys, from professional table (major)
(3) in the Sql Server 2008 database management system to create a database and database tables;
(4) the article number of the input data in a database table test;
(5) the number of SQL statements, their structure of database calls, implementation subject to statistical query requirements, SQL statements for at least 10, demands the function of the custom SQL statements, and give the SQL statements, including:
1) create table
2) the create index
3) the create view
4) select (at least 3 to traverse to the child use, include the from clause, the where, group by clause,
Having words, the order by clause)
5) insert
6) the delete
7) the update
8) grant
9) for the select query, need the query results are screenshots
10) for complex logical processing and custom integrity, you can use the stored procedure or trigger,
I drew a e-r diagram for the first time to do the design do not know how to start the great god, please give directions
