CamScanner XXXXXXXXXX
https:
digital-camscanner.onelink.me/P3GL/g26ffx3k
https:
digital-camscanner.onelink.me/P3GL/g26ffx3k
https:
digital-camscanner.onelink.me/P3GL/g26ffx3k
https:
digital-camscanner.onelink.me/P3GL/g26ffx3k
https:
digital-camscanner.onelink.me/P3GL/g26ffx3k
https:
digital-camscanner.onelink.me/P3GL/g26ffx3k
https:
digital-camscanner.onelink.me/P3GL/g26ffx3k
https:
digital-camscanner.onelink.me/P3GL/g26ffx3k
https:
digital-camscanner.onelink.me/P3GL/g26ffx3k
https:
digital-camscanner.onelink.me/P3GL/g26ffx3k
https:
digital-camscanner.onelink.me/P3GL/g26ffx3k
Sample Assignment 1 Solution
Student name: Lisa
Question 1: What is the meaning of the primary key in a table? (x points)
Answer:
A primary key is defined over a set of columns of a table such that the columns of the set “must” uniquely
specify a row in a table. A primary key is also a minimal superkey of the table. For example, in a student
table, the student id column can distinguish any two rows.
Question 2: Write the following query in relational alge
a and SQL: Find the details of all customers
where the nation-id is 15. You MUST provide the following
• Write relational alge
a expressions in your answer sheet. (x points)
• Provide screenshots of the query and the result. (y point)
Answer:
Relational alge
a:
??????????=15 (????????)
SQL Query screenshot:
Output screenshot: