M5.1: Project Assignment
Name:
Instructions:
Please follow this on how to use ChatGPT in the classroom to learn SQL coding responsibly.
For each problem:
- Write and execute an SQL query in Oracle Live SQL.
- Execute the following command: SELECT sysdate, ‘your name’ FROM dual; where your_name is substituted with your name.
- Take a screenshot that includes both SQL statements and all results.
- Copy and paste the screenshot into a Word file containing your solutions.
In addition, after completing this assignment, include a short overall reflection on your experience using ChatGPT (or another generative AI tool) to support your SQL learning. Answer the following questions:
- When was AI most useful or effective, and when did you find it less helpful or potentially misleading?
- How did you decide whether to trust, revise, or reject AI-generated SQL?
- What would you do differently the next time you use AI to support your SQL work?
Assignment Problems:
Continuing from the final version of your work in M2.2: Assignment Advanced Relational Database Design, this assignment requires you to write SQL queries to create all tables, including appropriate data types, relationships, and constraints (e.g., PRIMARY KEY, FOREIGN KEY, NOT NULL, CHECK, DEFAULT).
You are encouraged to use generative AI tools (such as ChatGPT) to support your work, for example, to draft initial CREATE TABLE statements, review constraint definitions, or identify potential issues. However, you are responsible for evaluating, revising, and finalizing all SQL to ensure it accurately reflects your design and follows best practices.
In addition, you may use ERD tools (such as Lucid) that offer ERD-to-SQL conversion features. Any automatically generated SQL must be carefully reviewed and refined; the final submission should reflect your informed design decisions, not unexamined tool output.
Make sure to name all PRIMARY KEY and FOREIGN KEY constraints using Oracle naming conventions. For each table, display its structure after creation. Finally, include your ERD/EERD from the previous assignment as part of your submission.
Requirements: NA
Get this or a similar paper done in as fast as 4 hours, 24/7.
NB: We do not sell prewritten papers. All essays are written from scratch according to specific needs and instructions
Leave a Reply
You must be logged in to post a comment.