Lucian Cojocaru luciancj
🚽
luciancj
/ University Origin Creator.sql
Created
October 11, 2025 13:22
Complete, named-constraint DDL for a small SIS schema used in DB modeling labs. Targets Oracle 12c+ (uses identity columns). No data is inserted—this script only defines tables, keys, and checks as required by the assignment.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* ============================================================ | |
| Student Information System – Exercise 1.2 | |
| Complete SQL DDL with all constraints and concise comments | |
| (Oracle SQL Developer compatible) | |
| ============================================================ */ | |
| ---------- Table: student ---------- | |
| CREATE TABLE student ( | |
| id NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY, -- artificial numeric key (PK) | |
| code VARCHAR2(64) NOT NULL, -- alphanumeric business key (unique) |