Description: Useri in the database to create a class selection on relational model, and insert the appropriate data to achieve the relevant inquiries. Description of students, course conditions as ER diagram, please use the relational data model into a relational schema is described in the definition of these relationships in the database model into the corresponding data, try to insert a duplicate tuple, the result? Established pattern of relations in the above (some data has been inserted) to establish the primary key constraint, referential constraints, and user-defined constraints (requiring students aged not less than 14 years, not more than 35 years of age), if the constraint can not be established, please analyze the reasons , modified to establish the constraints if the constraint is established, try to insert a duplicate tuple, the result?
To Search:
File list (Check if you may need any files):
SQL ceshi.docx
Download