H, I have got the assignment which asks
Write the SQL DDL required to implement one table, enforcing all constraints to include: primary key, entity integrity, foreign key, uniqueness, check, domain; Create an index on a foreign key attribute; Create a non-unique index on an appropriate attribute; Create at least one unique index on an appropriate attribute; Write the SQL required to implement a view; Identify at least 3 queries and 3 maintenance (insert, update, delete) operations and write the appropriate SQL for those.
I m using Microsoft Access and created some tables to input entities and attributes. How do I write SQL DDL from the table?
It would be great if I can find any resource which explain step-by-step for design database.