52 Consider this table below, what could go wrong if a patient visits the office multiple times?
53 we have come up with the new design below for keeping the records of patients' visits.
What could go wrong ?
54 list two major problems with the design below
55 The DB below is not 1NF and 2NF normalized. How would you normalize it?
56 What could be a potential problem with the way we designed the table below ?
57 What is the proper way of storing the date of birth?
58 Develope the SQL statement to create the table below
59 How would you insert records in the tables patient and visit created in the previous
question?
60 In the table below, find the name of patients who were born before March 1st, 1940
61 Without using CAST operator, in the table below, find the name of patients who were
born before March 1st, 1940
62 in the table below, find one of the oldest patient(s )
63 In the table 'visit' below find the id of the patine who visited the office the most often
64 What type of relationship do you see between the two tables below?
65 what data type would you choose to define the column ID in the table below?
66 How would you create the tables of the previous questions?
67 how would you insert the presented data in the two tables below?
68 Using union operator, what would the following SQL statement return ?
69 considering the tables of question 65, How many records whole the query below return?
70 NULL Zip code
71 in the table below we added the UNIQUE constraint. Was it a good idea?
72 in the table t1 find all unique ID values which are not null
73 the table t2, the NULL value is represented as a string. Find all ID values which are not
NULL
74 in the table below find all ID values which are not 'null'
75 Why string comparisons are case insensitive in mySQL?
76 how can we force the string comparisons to be case sensitive ?
77 find all ID values from the two tables below which are not NULL
78 what would be the resulting table after execution of this query ?
79 what would the query below generate?
80: What kind of relationship do you see in the DB below ?
81: is this DB complying with 1NF and 2NF?
82: write a SQL statement to create this table. Do you have to redesign the table's schema ,
or normalize it? If so, write your SQL statement to create the table which is normalized (1NF
and 2NF) and can be used in next question
83 For the table you created in the previous question, write a query to list all boxers who are
heavier than their trainer. Your resulting table must include:
84: For the Boxers table, sort and list all the Boxers according to their weight in ascending