Create a fully functional relational database that able to demonstrate the requirements of a Berkely college Admission form.

Logical design of the database documents

Create physical design with the following features

The design must be in BoyceCodd normal form.

Each table must have keys primary, foreign keys

Create Integrity Constraints

Populate each table with data at least 10 rows (do not disable the constraints)

Be able to insert, update, delete, and select from table (DML)

Berkeley College International Student Application For Admission Wa look forward to roviowing your application for admission to Barkaley Collega The following information wil guide you through the application procees Admission: Graduaion from secondary school or its equivalent and proof of Engich proficienay are required for admission to Barkeley Collage Englich rguage proficiency can be demonstrated by the folowing methodx Completion of a reoognined ESL school's pram or by achieving the appropriate score an ane of the folowing Engish teats English Tests Aocepted Berksley College's Language Tes English for Sweden-grade VGC TOEFL-score of 50O PBT, 61 BT TOEC-score 560 or bette University of Cambridge- British Council with a grade af G or better STEP-core 2A or better 80 IET for MB.A) IELTS-score of E.5 or higher (8.5 for M.B.A Michigan Tast-score of 7B or better .APEL,grade 3 or higher #AS-Level 112 Kaplan-High Intermediate Rennert Interrational- Level ITEP-Level 5 Engish for Norway-level 4 Transfer Policy: Bm dey wil typica y accept rani r ?edts for oourses deemed applicable by the Colege to student's program The student must have eamed a minimum grade of C For a complete review of trarefer credits, students should subnit their pot-secondary tranacripts along wich their applicaion doouments. All documents must be traralated into Engiah Appication Checklist International students must aubmit the llowrg A completed Berkeley international application form AS60 (US) ppication fee Scholarship application form applicable A $300 (US tuition deposit fee A $400 (US) recidence depoeit for the White Plins residences Official seoondary or pod-secondary transoripts of acadenio grades (tranelated into Engich and proof of secondary graduation Proof af English pro?ciency (TOEAL score or ESL oertiication or admission to an approved ESL program) Official document of firancial support demonstrating a mirimum of $38,000 (U.SJ inavailsble fund Deposits/1-20 Certificates and Refund Policy A $300 (U.S) tuition depoeit reserves a place at Berkeley and wil lbe applied to tution The l-20 Certiicate will not be sent until the tuition depoait and all required academic and financial documents are reoeived This depoit wil be refunded f written notice of cancellation is nacvat least 60 days prior to the starting date of the semester for which the student has been accepted, if the student is refused admission to the College, or if the student is denied a student visa. In the event af a vice denisl, we wil need writtern proof of the denial from the U.S. Embaay. All refurnds are only available upon the first equested term of entry H a seoond -20 is requested, the $300 tuition depost wil be fiorfesited Residence fscilities should be neserved wall in advnce. A $400 room depoait is required for the Whie Paire residence facilies. C this amount, $200 icredited toward the firnal semester's rent;the remaining $200 is held as a deposit uril the student has checked out ofthe roornsatisfactori. The refund pooyfor the readence depot is the s me as te tuton depcet ?ed above. PAYMENT OPTIONS Online Payment Tool: Berkeley College accepts payments Hyou need further assictance, cortact the Inteational Department Telephone:1-212-687-3730 payment tool that uition payments for initernational students. To access the tool plesse visit Berkeley College International Student Application For Admission Wa look forward to roviowing your application for admission to Barkaley Collega The following information wil guide you through the application procees Admission: Graduaion from secondary school or its equivalent and proof of Engich proficienay are required for admission to Barkeley Collage Englich rguage proficiency can be demonstrated by the folowing methodx Completion of a reoognined ESL school's pram or by achieving the appropriate score an ane of the folowing Engish teats English Tests Aocepted Berksley College's Language Tes English for Sweden-grade VGC TOEFL-score of 50O PBT, 61 BT TOEC-score 560 or bette University of Cambridge- British Council with a grade af G or better STEP-core 2A or better 80 IET for MB.A) IELTS-score of E.5 or higher (8.5 for M.B.A Michigan Tast-score of 7B or better .APEL,grade 3 or higher #AS-Level 112 Kaplan-High Intermediate Rennert Interrational- Level ITEP-Level 5 Engish for Norway-level 4 Transfer Policy: Bm dey wil typica y accept rani r ?edts for oourses deemed applicable by the Colege to student's program The student must have eamed a minimum grade of C For a complete review of trarefer credits, students should subnit their pot-secondary tranacripts along wich their applicaion doouments. All documents must be traralated into Engiah Appication Checklist International students must aubmit the llowrg A completed Berkeley international application form AS60 (US) ppication fee Scholarship application form applicable A $300 (US tuition deposit fee A $400 (US) recidence depoeit for the White Plins residences Official seoondary or pod-secondary transoripts of acadenio grades (tranelated into Engich and proof of secondary graduation Proof af English pro?ciency (TOEAL score or ESL oertiication or admission to an approved ESL program) Official document of firancial support demonstrating a mirimum of $38,000 (U.SJ inavailsble fund Deposits/1-20 Certificates and Refund Policy A $300 (U.S) tuition depoeit reserves a place at Berkeley and wil lbe applied to tution The l-20 Certiicate will not be sent until the tuition depoait and all required academic and financial documents are reoeived This depoit wil be refunded f written notice of cancellation is nacvat least 60 days prior to the starting date of the semester for which the student has been accepted, if the student is refused admission to the College, or if the student is denied a student visa. In the event af a vice denisl, we wil need writtern proof of the denial from the U.S. Embaay. All refurnds are only available upon the first equested term of entry H a seoond -20 is requested, the $300 tuition depost wil be fiorfesited Residence fscilities should be neserved wall in advnce. A $400 room depoait is required for the Whie Paire residence facilies. C this amount, $200 icredited toward the firnal semester's rent;the remaining $200 is held as a deposit uril the student has checked out ofthe roornsatisfactori. The refund pooyfor the readence depot is the s me as te tuton depcet ?ed above. PAYMENT OPTIONS Online Payment Tool: Berkeley College accepts payments Hyou need further assictance, cortact the Inteational Department Telephone:1-212-687-3730 payment tool that uition payments for initernational students. To access the tool plesse visit