Changes between Version 18 and Version 19 of P2

Timestamp:

06/06/26 14:23:23 (11 days ago)

Author:

216009

Comment:

--

P2

@@ -36 +36 @@
 [[Image(relational_schema1.jpg)]]
 
-= AI Usage for Relational Design
-ChatGPT – OpenAI
-URL: https://chat.openai.com/
+= AI Usage for Relational Design =
 
-Type of subscription: Free online access (no paid subscription required)
+Name of AI service/solution that was used: ChatGPT (OpenAI)
 
-Note: This AI tool was selected to assist with database design and relational modeling based on a short survey of available AI tools. Its responses helped in structuring tables, foreign key constraints, and M:N relationships for this project.
+URL: https://chatgpt.com/
+
+Type of service/subscription: Free Tier
+
+Final result: I reviewed my initial core database schema with the AI assistant to identify potential gaps in tracking student-professor interactions and professor-university ties. Based on these discussions, I successfully refined my tables by designing and incorporating the Advice and Affiliated relation schemas.
 
 == Final Result
@@ -81 +83 @@
 
 
+Results in details / description:
 
-ChatGPT - https://chatgpt.com/c/69693542-7640-8327-920b-0065ba155df0
+Schema Normalization Review: I provided the AI with my initial 7-table layout (University, Faculty, Professor, Student, Subject, Subject_Professor, and Student_Subject). We reviewed the constraints to ensure proper cascading rules and column data integrity.
+
+Relationship Modeling: To handle business requirements for office hours and mentorship, I formulated an Advice entity. The AI helped me refine its composite key structure to accurately capture timeline interactions between students and professors.
+
+Affiliation Tracking: I noticed a missing link where a professor might be affiliated with a specific university outside of just their faculty assignment. The AI assisted me in mapping this out cleanly as an Affiliated bridge table to prevent normalization redundancy.
+
+Documentation Generation: The AI assisted in translating my updated schema into the clean, underlined notation style required by our project's Trac Wiki submission guidelines.
+
+== Entire AI usage log:
+
+User: I have created an initial relational schema for my university database tracking universities, faculties, professors, students, and subject enrollments. Can you review my baseline table structure to see if there are any logical gaps for a complete academic management system?
+
+AI: Analyzed your 7 core tables. The structure is highly normalized, but it currently lacks a way to track independent academic mentorship or office hours between a professor and a student outside of a classroom. It also lacks a clear way to track a professor's direct corporate or institutional affiliation to the primary university level if they span multiple departments.
+
+User: Good point. I want to add an office hours/mentorship feature called Advice and a connection table called Affiliated. How should I structure their primary keys and foreign keys so they map cleanly to my existing Student, Professor, and University tables?
+
+AI: Assisted by suggesting a many-to-many design pattern. For Advice, you can use a composite key pairing Student_Id and Professor_Id as foreign keys alongside tracking timestamps. For Affiliated, you can create a direct intersection table pairing University_Id and Professor_Id.
+
+User: Excellent, that fits exactly what I had in mind. Can you help me format my final, updated schema—including these two new tables—into the underlined notation style required for our project documentation?
+
+AI: Structured the final table schema list, explicitly emphasizing the primary keys with formatting underlines and clearly marking the foreign key dependencies and their referencing entities in parentheses.