| Version 1 (modified by , 6 weeks ago) ( diff ) |
|---|
Relational Design for Handcraft ChapterX
Notation
- Primary keys are bolded and underlined.
- Foreign keys are marked with
*at the end of their name and the referenced entity is written in parentheses. - Complex attributes are bolded, and their containing attributes are following the, made italic.
- Multivalued attributes have their own table
Tables
DDL script for creation and deletion of tables
DML script for inserting data in the tables
Relational diagram made in DBeaver
AI Usage for Relational Design
Attachments (5)
-
relational_schema.png
(109.3 KB
) - added by 5 weeks ago.
Added relational schema
-
schema_creation.sql
(8.5 KB
) - added by 4 weeks ago.
Added schema creation script.
- relational_schema.2.png (119.5 KB ) - added by 4 weeks ago.
-
data_load.sql
(24.2 KB
) - added by 4 weeks ago.
Added data load script.
- relational_schema.3.png (122.7 KB ) - added by 3 weeks ago.
Download all attachments as: .zip
Note:
See TracWiki
for help on using the wiki.
