Good Day
I have just passed the beginner stage of self-learning SQL. I applied for a Job as I am currently unemployed, I've received feedback to perform the following task.
Now for the mere fact that I am NOT even at intermediate level of my self learning SQL, I need assistance, pleeeease, my time of unemployment may come to an end if I am able to perform the following. I know it may come across as cheating, but this is how I learn, by asking questions. Please, can somebody assist me with this
THE BELOW HAS BEEN REQUESTED OF ME AS A TEST EXERCISE. NOTE, I have to have this ready for the morning of Sunday - 18 April 2021
****"Produce a 3 Normal Form ERD using the following SQL statement as input. Explain what steps you took to get to 3NF"****
DECLARE @ProgramID uniqueidentifier
SELECT @ProgramID = programID from program where title = 'NovoCare'
DECLARE @LanguageId uniqueidentifier-- NVARCHAR(20)
Select @LanguageId = LanguageId from Language where Title = 'English'
SELECT DISTINCT
Patient.PatientID,
Person.FirstName, Person.Surname,
Program.Title
FROM Patient
JOIN Person on Patient.PersonId = Person.PersonId
JOIN Program on Patient.ProgramID = Program.ProgramID
JOIN Language on Person.ServiceLanguageID = Language.LanguageID
WHERE Patient.ProgramID = @ProgramID
Order by Person.Surname, Language.Description