# data[].attributes.body
Dear Peter,

I greatly appreciate if you could explain why the model 6 in the question 24 (practice exam) is the best, e.g. I find the first one is better.

Thank you!

# data[].attributes.body
Why is "The two tables contain values which are atomic" a TRUE statement? The Student Name column contains composite values - where Peter Stordy can be divided into Forename and Surname, and so on.

# data[].attributes.body
Hello,

Why is 8, 12, 16 empty and not null?

# data[].attributes.body
Hi, could you please explain why testing comes before implementation? Thank you.

# data[].attributes.body
Dear Peter:

I find the showed answer to this question is somehow conflict.

Problem Description

1. PRIMARY KEY: DOG_ID is a unique identifier for each record.

2. FOREIGN KEY: MOTHER_ID must refer to a DOG_ID that already exists in the DOG table.

3. NOT NULL: MOTHER_ID cannot be null.

Conflict Analysis

- When we create a new record, we must specify a MOTHER_ID, which must be a DOG_ID that already exists in the DOG table.

- However, when we insert the first record, it is unlikely that any record exists, so the condition that the MOTHER_ID must reference an already existing DOG_ID cannot be met.

- Clearly, a dog cannot be the mother of the dog itself.

-----------------

In conclusion, I believe the answer to this question should not contain UNIQUE constraint on MOTHER_ID.

# data[].attributes.body
Hi Peter,

I was wondering what makes the first table contains values that are atomic? I would have thought name column was not atomic because it can be split to first and surname.

Many thanks.

# data[].attributes.body
I am unsure how to answer normalisation questions which include the phrases like, "almost 2NF". Please would you help?

# data[].attributes.body
Hello,

Why is the unique keyword wrong? The Owner_ID is an identifier in the Owner entity.

Thanks,

# data[].attributes.body
Hello,

How do I approach this question, what structural conflicts are there?

# data[].attributes.headline
REVISION QUESTIONS: Conceptual Design 2 Question 13

# data[].attributes.subject
REVISION QUESTIONS: Conceptual Design 2 Question 13

# data[].attributes.body
Hi Peter,

Could you explain why the answer to this question is that there are structural conflicts？ I would really appreciate your help in understanding this.

Thank you very much.

# data[].attributes.body
Dear Peter:

I wonder whether the note for the exam has a language restriction; does it have to be written in English or other languages we are familiar with?

Thanks

# data[].attributes.body
Hi, are we allowed a pen and paper in the actual exam?

# data[].attributes.body
This question asked us to fill in the blanks, why is the correct answer for [1] 100 and not 50? [4] states that in the Yacht Table the name should be 50 long (which references the manufacturer table), so allowing the name to be 100 in the manufacturer table would surely cause conflicts

# data[].attributes.body
Hi Peter,

Could you please explain why the answer to this question is that there are structural conflicts?

Thanks for your help.

# data[].attributes.body
In the actual exam, for fill in the blank questions, if the entire question is worth 5 marks for instance, but we got one of the blanks incorrect, will we get 0 marks or a slightly reduced mark?

# data[].attributes.body
Hi,

Which weeks/slides can I refer to, to review about "data governance" ?

# data[].attributes.body
In the Physical Design 2 practice test, all 3 questions about Physical models for a company which sells yachts to customers. And I couldn't find any differences between these questions? All 3 questions ask to choose correct SQL code. Is this a mistake or am I missing something?

# data[].attributes.body
In question 1, only option 1 is an assertion. Every other is either a functional or non-functional requirement.

So, when being asked to choose which one is unlikely to be an assertion, how do we choose from the 3 non-assertions...?

# data[].attributes.body
Hi,

This is unrelated to the practice exam.

Can we put notes on both sides of the A4 paper or only one side?

Thank you.

# data[].attributes.body
Dear Dr. Peter, it's the last question about normalisation (Sorry to bother you so much).

It says that this table is in 3NF. However, I feel like this table still needs splitting into two tables, first one with 'MODULE_CODE and MODULE_TITLE', second one with 'MODULE_CODE' and 'MODULE_CREDIT'.

Could you please why my understanding is wrong?

Thank you so much all the time.

# data[].attributes.body
Dear Dr. Peter, this is the following question about normalisation.

In the example below, I selected the answer saying that it's not 2NF, because I thought there were partial dependencies between 'CAR_REG_NO' and 'CAR_DETAIL' / 'OWNER' and 'OWNER_NAME'.

Could you please explain me why this example is in 2NF? I'm afraid that I'm a bit confused about this. I'd appreciate your help.

# data[].attributes.body
Dear Dr. Peter,

I'm a bit confused about normalisation. Sorry to put 3 consecutive questions. This is one of the questions.

In Question 16, could you tell me whether my interpreation/understanding right or not?

The two tables (STUDENT_MODULE, PROGRAMME_MODULE) are in 1NF and there are partial dependencies between 'PROGRAMME_CODE' and 'PROGRAMME_TITLE'?

Thanks a lot.

# data[].attributes.body
Hi,

I am slightly confused why the correct answer involves removing some attributes such as Job_Title from Employee. I thought the attributes of same entity types were meant to be merged into one.

Any help would be appreciated,

Thanks!

# data[].attributes.headline
Question about REVISION QUESTIONS: Physical Design 1

# data[].attributes.subject
Question about REVISION QUESTIONS: Physical Design 1

# data[].attributes.body
Hi, I noticed that the answer to the first space is given as 100, but in the question the MANUFACTURER_NAME in the TABLE YACHT indicates that the data type is __(50), should the answer to this be 50?

# data[].attributes.body
I saw this in my mark, but not in week 12. Where can I practice this? Thank you.

# data[].attributes.body
Hi, last slide from logical design:

CREATE TABLE FILM (NAME, RELEASE_DATE) PRIMARY KEY (NAME, RELEASE_DATE)

CREATE TABLE SCREEN (SCREEN_NO, SEATS) PRIMARY KEY

(SCREEN_NO)

CREATE TABLE FILM_SHOWING (VIEWING_DATE, VIEWING_TIME, SCREEN_NO, FILM_NAME, FILM_RELEASE_DATE) PRIMARY KEY (VIEWING_DATE, VIEWING_TIME, SCREEN_NO) FOREIGN KEY (SCREEN_NO) REFERENCES SCREEN(SCREEN_NO) FOREIGN KEY (FILM_NAME, FILM_RELEASE_DATE) REFERENCES FILM(NAME, RELEASE_DATE) NOT NULL

why is NAME, RELEASE_DATE not null when it references a PK and then why not SCREEN_NO not null as it also 1 optionality (I assumed because references PK?) Many thanks

# data[].attributes.body
Dear Dr. Peter, could you explain why the two selected answers are wrong?

1) Primary keys must have a constraint where they reference a primary key in another table.

2) Primary key values (including each individual column value in a composite primary key) must be unique.

Thanks!

# data[].attributes.body
We can take this test at any time once it is released? And for every attempt would the questions be different or the same as the previous attempt? Thank You.

# data[].attributes.body
Hi, I just wanted to confirm if there are any restrictions on what we can include in our exam notes. Specifically, would it be acceptable to include glossary words? Thank you!