Programming & Computer Science Answers

CREATE DATABASE rgi_student;

CREATE TABLE student_reg (

STID INTEGER (4)

USERNAME VARCHAR(30)

PASSWORD HASH CHAR(25)

CONFIRM PASSWORD

FIRSTNAME VARCHAR(30)

SURNAME VARCHAR(30)

EMAIL TEXT

QUALIFICATION VARCHAR(15)

CELL NUMBER INTERGER(10)

GENDER VARCHAR(6)

NATIONALITY VARCHAR(25)

);

2.3.3 How can we determine that the expressions are equivalent?

2.3.2 Why do we care that the expressions are equivalent?

2.3.1 Which query can produce a contrasting answer? Give the simplest database instance you can think of where a different answer is produced.

1.2 SELECT and RETURN all students with qualification HCIT from relations STUDENTS X BOOKS.

If we apply the cross-product operation to these two instances of STUDENTS & BOOKS, what would be the resulting relation?

1. p = m(67a - 32j) + 23-5m/a

1. s = 6a/mn - (24j + 32)^9m+1

1. M= j(31k + 2r/n)²ⁿ

Name Surname Score

1. Sam Williams 60

2. John Phoenix 85

3. Simon Johnson 75

4. Sarah Khosa 81

5. Mat Jackson 38

6. Nick Roberts 26

7. Isaac Wayne 74

8. Anna Mishima 34

9. Daniel Rose 64

10. Aaron Black 83

11. Jack Mohamed 27

12. Kathrine Bruckner 42

Create a C++ program that has 3 Stacks.

Insert, into the first stack, all the data above (which is the data of student’s names, surnames and the marks they obtain in a particular assessment)

Display the content of the stack on the screen (console)

Then, remove all the students whose surname starts with the alphabets ‘R’, ‘J’ and ‘M’, from the first stack and insert them into the second Stack.