Dean of Admission at DeAnza College has hired you to do the database design for a new registration system. Keeping in the mind the following requirements, design a Database Schema. 1. College has several departments 2. Department offer several courses 3. Courses have sections. 4. College has locations (Room Sem 5 etc.) 5. Students register for a section from a catalog (which is composed of Departments, Courses, Sections, Location.) 6. Students have to pay for the course they take. You may want to think about resident, non resident. 7. Their status is updated based on their registration. A document to help you remind the symbols for DB Schema is posted in the notes area for Session 1 - called introduction to RDBMS. doc. Help Files 1. Lab6DesignProposal.txt. Dean of Adrisaice at Deknti collepe hai hared you to do the database deaiph for d. nev teglatratiod iysten, reeping in the mind the schema. 1. Coliege has ieverat departments 2. Departapt otter several eolarese 3. Courtes bave seetiont. 4. Coljege has Jocat lons (hocm ben inte 1 S. stodenta reginter for a pection frem a eatillog f which in ceepoind of Departeneti. Courbes, Beetions, teedtiens) 6. skudenes have no pay for the oodree they take. Tou aay want to think about resident, ane reididect. 7. Their etatus in upelated based en roeir registration: A dopunent to help you remind the ayatedis for Ds schera in pouted in the notea ared far Eetaioh I - eallied "tnterduetion te imams-doe". Entiey/ateributei MWALIE Dier - Id(pk), Tirateke, Labtakhe, Mddress, nail, Telfo. Neaidetsid. Tyfe [RaABri] Location - (dipk), Loedtion dumen [Parkent visa/me/eosh = epeiosal I Phestert I Reaident - Id(pk), ReuiMane. Teeschedate RhMendeent/lon-3oudident I Fuarke) College idipik, same. Mddrese, felme Icirle of collepel Departinent - idfpkt. Wase, Locid, Collegeid(tk) jchitco of bepartment? Course = id(pk) , Cowrselis, Courspiane, Prereg. Peptide fk I (Cilted of Courae, Dewiditatruetor) whe Loeation 1 Beetios =1d(pk). Betiotsod ceurselatinj. Loost ionid(fik), starteime, endtime, startaste. enddace, uewrld fkl fehild of wher, section, Thyeat 1 sectionfd(tk).. Feestates. Paypentid(tk) f/ atudent - betien Cataloy = vies tquery = peperthetit, Gesirse, section, hoesatsen! Wetationahipan 1. College(gateot) dan have tero or more deparkmens (child) 2. Departmentiparent) han aero or nore nourien fistudenta eorplete the 1 liating of the felatienshigol Cros Motatido keresentation ficonpletepd by studeata erev hotatien practiee.ppt. in juet a mansple and not a coeplete repesesentition ef the arheme You are supposed to ereate this documest whd the +PPt. Ilite only providen a itarting point. 2:13 Back Crow notation practice.ppt Crow notation practice Crow Notation Crow Notation CD Dashboard The following two styles are in wide use, and are generally easier to create using drawing (e.g. Microsoft Visio) or CASE (e.g. Rational Rose) tools. The elements making up both diagrams are as follows: -STUDENT is a strong entity with the attributes: Name, Address, and Student Number. .COURSE is a strong entity with the attributes; Course Number and Title. -TRANSCRIPT is a weak entity with the attribate: Grade. - A SIUDENT may enroll in sero or more COURSEs. A COURSE may be attended by zero or more STUDENIs. - A STUDENT either has been issued a TRLNSCRIPT or has not. A TRANSCRIPT is assigned to a single STUDENT. A TRANSCRIPT must record at least one COURSE. A COURSE may appear on zero of many TRANSCRIPTs. -A TRANSCRIPT is identified by both a STUDENT and one or more COURSE. - A COURSE may specify zero or more prerequisite COURSEs. A. COURSE may be a prerequisite for zero or more COURSER
