EPPS 6354 Assignment 2

Question 1: Definitions

Relation schema defines the attributes and their allowed values. In a university database, this may specify that a student application profile application consists of a GPA, a Major, and an SAT score, for example, such that the schema is application (hs_GPA, Major, SAT_score). In contrast, a relation instance is the value that may change over time. For example, at one point there may be a student A with values such that A (3.8, Engineering, 1440). This may change, however, so that at some other time student A may have values such that A (3.9, Art, 1520). Relations themselves describe the association between groups, with tables and values allowing for connection of values across attributes.

---

Question 2 & 3: Schema Diagram

Foreign keys (as subset of relations) include branch_name as a primary key for branch and foreign key for loan and account. loan_number as aprimary key for loan and a foreign key for borrower. ID as a foreign key for depositer, borrower, customer. account_number is a primary key for account, foreign key for depositer.

---

Question 3: AI/LLM Use in Databases

Artificial Intelligence can help manage databases by addressing data cleaning tasks such as removing errors with invalid values. This can make databases more efficient by allowing errors to be identified and corrected for quickly, also making the database more accurate.

LLMs can help with querying databases by converting natural language into searches through conversion to SQL or other formats. This allows for users to not have knowledge of specific keys in the database, but still be able to use it quickly and efficiently.

---

Presentation

EPPS 6354 Assignment 2 by Nyssa Galatas