| 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/Resources/Notes/ |
Upload File : |
SELECT emp# FROM Salary_tbl WHERE jobName = Sales AND (IfNull(commission,0) + salary) > 30,000 –> E10 and E12 Weak relationship. Customer(CustID*, CustName) Order(OrderID*, CustID@, Date) Strong relationship. Course(CrsCode*, DeptCode, Description) Class(CrsCode*@, Section*, ClassTime…) 1:M employee(EID*, Salary, Address, Name, Birthdate, DeptId@) department (DeptId*, Name, Office) M:N employee(EID*, Address, Name, Birthdate) join(EID*@ Code*@, StartDate) I would name it employee_project instead of join. project (Code*, Name, Budget) Unary relationship employee(EID*, Salary, Address, Name, Birthdate, Super-EID@[employee.EID]) Ternary relationship supplier(SID*, Name, Address) project (Code*, Name, Budget) part(PartID*, PartName, Color) supply(SID*@, Code*@, PartID*@, Quantity, Date) What if the part came form a particular suplier? supplier(SID*, Name, Address) project (Code*, Name, Budget) part(PartID*, SID@. PartName, Color) supply(Code*@, PartID*@, Quantity, Date) Fig 10.9 pp 67: NOT NORMALIZED: grades(StudentID*, StudentName, CourseID*, CourseName, Grade, CourseDate) 1 John Smith 2 Programming Level 1 75 1/5/2014 2 Sandy Law 2 Programming Level 1 61 1/5/2014 3 Sue Rogers 3 Business 81 1/7/2014 If I delete Sue Rogers from the class, data about the Business class is also lost. 4 Jim M 2 Prog 2 100 2/9/2021 Insertion anomoly. Allows Update anomoly. NORMALIZED: student(StudentID*, StudentName) 1 John Smith 2 Sandy Law 3 Sue Rogers 4 Jim M student_course(StudentID*@, CourseID*@, Grade) 1 2 75 2 2 61 3 3 81 4 2 100 course(CourseID*, CourseName, CourseDate) 2 Programming Level 1 1/5/2014 3 Business 1/7/2014 15:30:01 Server: localhost Database: bookinfo -- phpMyAdmin SQL Dump -- version 3.2.0.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 21, 2010 at 05:08 AM -- Server version: 5.1.36 -- PHP Version: 5.3.0 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO" Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Server: localhost Database: bookinfo -- phpMyAdmin SQL Dump -- version 3.2.0.' at line 1 0.000 sec