<p>Let us consider the following relational databases</p><ul><li><em>Students(id, name, address, dob, email, advisor)</em></li></ul><p><strong>id</strong></p><p><strong>name</strong></p><p><strong>Address</strong></p><p><strong>Dob</strong></p><p><strong>email</strong></p><p><strong>Advisor</strong></p><p>950111111</p><p>Ann Smith</p><p>1 Main St.</p><p>1997-10-19</p><p>asmith@aggies.ncat.edu</p><p><strong>950850123</strong></p><p>950999999</p><p>Alan Turing</p><p>2 Lee St.</p><p>1988-08-10</p><p>aturning@aggies.ncat.edu</p><p>950850999</p><p>950111222</p><p>Karen Peters</p><p>4 Market St.</p><p>1998-01-02</p><p>kpeters@aggies.ncat.edu</p><p>950850999</p><p>950111333</p><p>Milo Bruni</p><p>15 Chelsea St.</p><p>1999-03-17</p><p>mbruni@aggies.ncat.edu</p><p>950850456</p><p>950111444</p><p>Jim Mattis</p><p>21 First St.</p><p>1992-09-04</p><p>jmattis@aggies.ncat.edu</p><p>950850999</p><p>950111555</p><p>John Kelly</p><p>33 Wall St</p><p>1995-05-05</p><p>jkelly@aggies.ncat.edu</p><p><strong>950850123</strong></p><ul><li><em>MajorsIn(studentID,deptName,