Question

.The class teacher has asked Sakshi to create a table for the class containing the following
fields
Table: Class_XB
Field Name Student_id First_name Address Age City Mobile
a. Mention the data types that Sakshi should choose for the fields in the table Class_XB.
b. Name the field that should be set as Primary Key.
c. Create a query to display the mobile number of the students who live in Delhi.
d. Add the following record of the student who has just joined:
Student_id First_name Address Age City Mobile
32 Sahir 530,Sector-8,Rohini 14 Delhi 9723435462
e. Delete the record of student with Student_id: 14 who has left the school.

Answer 1

Answer:

"Einstein riddle" The riddle asked us to complete a table of answers in a way that ensured various constraints were satisfied. A "correct" answer to the riddle was a completed table that satisfied all the constraints provided. The table was 5 rows by 5 columns. For each row you could pick the order of 5 parameters - for example, the order of 5 different colours or 5 different car models. In this particular problem there were no duplicate assignments - i.e. you couldn't have two cars of the same colour or make.

How would allowing duplication on the colour of the cars affected the problem ?​

Answer:

 

Explanation:

 

Explanation: