1. What two concepts are ER modelling based on?
2. The database in Figure 8.11 is composed of two tables. Use this figure to answer questions
DIRECTOR
DIRNUM
100
101
102
DIRNAME
J.Broadway
J.Namath
W.Blake
DIRDOB
01/08/39
11/12/48
06/15/44
PLAY
PLAYNO
1001
1002
1003
1004
1005
1006
1007
PLAYNAME
Cat on a cold bare roof
Hold the mayo, pass the bread
I never promised you coffee
Silly putty goes to Texas
See no sound, hear no sight
Starstruck in Biloxi
Stranger in parrot ice
DIRNUM
102
101
102
100
101
102
101
Figure 8.11. Director and Play tables for question 2, by A. Wott.
2.1 Identify the primary key for each table. 2.2 Identify the foreign key in the PLAY table.
2.3 Identify the candidate keys in both tables.
2.4 Draw the ER model.
2.5 Does the PLAY table exhibit referential integrity? Why or why not?
briefly describe the responsibilities of the following roles in terms of what they are for each information lifecycle and cloud data lifecycle stage (if the responsibilities change for different stages):
Select one of the four elements of digital disruption and discuss how that particular element of digital disruption can change the ways in which business operates?
Explain how machine learning can be utilised in a South African business context. Illustrate this by way of an example
using c# visual studio code
Count and display the several statistics, which are:
o Born in each different month
o For Malaysians:
▪ The number of those born in each state / or a foreign country
o The number of non-Malaysians
o Number of males and females, of which
▪ How many are married, divorced or single
Write a program that takes an array name X of 10 values as an input
parameter and an array name Y with 10 values as an output parameter.
The program should copy the integers in X into Y but in reverse order.
Input:
Array X [10] – 1 2 3 4 5 6 7 8 9 0
Process : copy array X in reverse order to array Y
Array Y[10] – 0 9 8 7 6 5 4 3 2 1
Output: print array X and array Y
Write a program that will input 20 values to array BSIT and to sum up the content of all even index. Print array BSIT and the sum of all even index.
3. Create a fitness application User stories grouped together by theme. Remember to use the prescribed format.
2. Create a product vision of a fitness application using the following template.
For [target customer] :
Who [statement of the need opportunity] :
The [product name] :
Is a [product category] :
That [statement of key benefits; that is; the compelling reason to buy] :
Unlike [primary competitive alternative] :
Our product [statement of primary differentiation] :
1. Create a problem statement for fitness application using the following template.
The problem is:
Affects:
The impact of which is:
A successful solution would be: