Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and beauty - Write SQL statements that create the following three data tables.
Write SQL statements that create the following three data tables.
In SSMS, design by creating tables, including constraints; Then save, select a new table, right-click to write a table script, and SQL will do.

Item table structure: Item number: commonly used coded fixed-length character type, length 10, primary key. This project writes sQL statements that create the following three tables.

Create tables with SQL statements as needed: Course Selection Table: Table Name -SC Attribute: Sno character type, with up to 7 characters indicating student number.

Cno character type, with a maximum of 4 characters indicating the course number. Grade integer indicates grade. Constraint: main code -SnO, Cno;; Sno and Cno are external codes)