Question Answered step-by-step If I could please get some tip/advice for my SQL data dictionary. I… If I could please get some tip/advice for my SQL data dictionary. I need to use the CHECK constraint to add these attributes on my data dictionary. How would I write it and please give advice on any others issues/feedback you think is required on my data dictionary that I attached below as a pic:1. A customers email must have a hashtag.2. A customers DOB must be 12years in the past (12yrs and above)3. Rating a review:The scenario details in the brief specify that the value must be between 0 and 5. This can be enforced using a CHECK constraint – a “BETWEEN” comparison should be perfect.The additional details state that it must allow for “half stars”, i.e. 0.5 values. This means the data type should allow for exactly 1 decimal place. Using the DECIMAL data type, you should be able to specify a number that will only allow one whole number digit and one decimal place.4. A movie sequel – Since a movie cannot be a sequel to itself, a CHECK constraint should be used to ensure that the value in the movie ID column cannot be the same as the value in the “sequel_of” column (i.e. they cannot be the same in the same row of data). This will need to be written as a table-level constraint since it involves comparing the values of two different columns. Image transcription text”Classification” table (stores detailsabout movie classifications Column NameData Type & Length Null Co… Show more… Show moreImage transcription text”Cinema” table (stores details about the cinema)Column Name Data Type & Length Null Constraints OtherCinemaIDNumber SMALLINT NOTNULL PK IDENT… Show more… Show more Computer Science Engineering & Technology Software engineering CSG 1207 Share QuestionEmailCopy link Comments (0)