Hi, I m new to the database design and needs to create the database based on following question;
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 not sure how to write the SQL DDL from the tables with attributes.