Assignment 4 Instructions (1)

Samples of 42 college students are considered for study and were categorized according to year level. The data set is FreshmenFreshmenFreshmenSophomoreJuniorFreshmenSenior SophomoreSeniorSeniorFreshmenSeniorSophomoreSophomore JuniorSophomoreFreshmenFreshmenSophomoreSophomoreFreshmen SeniorSophomoreSophomoreFreshmenFreshmenJuniorJunior SophomoreJuniorSophomoreJuniorJuniorJuniorFreshmen FreshmenSeniorJuniorFreshmenFreshmenFreshmenSophomore Solution:ClassTallyFrequency (f)Percentage (%)                     Total         Consider the scores of 50 Grade 7 students in Math.2939263520 2226363119 2026352528 2239323219 3732283320 2026353119 2531252220 4031193220 2228333919 2026373119 ScoresfPercentage 40   39   37   36   35   33   32   31   29   28   26   25   22   20   19   Total   Solution:

CUSTOMER Customer table is composed of customer number, name and phone number. Give and fill-in the appropriate attribute name for each of the column. custID 123 124 125 126 reservelD 5001 5002 5003 5004 5005 5006 5007 RESERVATION Each reservation is for one taxi. Reservation table is composed of reservation identification number, start reservation date, end reservation date, reservation days requested by customers starting from reservation date until end of reservation date, customer number that make the reservation and taxi number assigned to the reservation. Give and fill-in the appropriate attribute name for each of the column. taxill custName Ahmad Bin Abdullah Fatimah Binti Adam LAI LA2 Ruqayya Binti Idris Sulaiman Bin Daud LA3 LA4 startDate 01/10/2019 05/10/2019 05/10/2019 15/10/2019 20/10/2019 27/10/2019 02/11/2019 taxiType endDate 03/10/2019 12/10/2019 08/10/2019 17/10/2019 25/10/2019 Sedan Sedan Van Van 30/10/2019 04/11/2019 cust Phoneno TAXI Taxi table is composed of taxi…

Show the list of students (all attributes) who were born after 2000-01-01 and are currently in Active status in the alphabetical order of the last and the first name. Hint: To calculate easily, always use the date format YYYY-MM-DD

Course Title: Data Structure and Algorithms Question  A table stores the data for all the members of an exotic resort. Members are identified by these numbers 1,5,30,70,80,20,15,100,40,25,7,3,8,33,22.   All members are to be invited in a meeting to review the membership policies. What will be the fastest way to call all the members? Write algorithm to justify your answer.

Using the STUDENT table structure shown below, normalize the table to BCNF. Sample STUDENT Records Attribute Name Sample Value Sample Value Sample Value 199876 Sample Value 199877 STU_NUM 211343 200128 STU_LNAME Stephanos Smith Jones Ortiz STU_MAJOR Accounting Accounting Marketing Marketing DEPT_CODE ACCT ACCT MKTG MKTG DEPT_NAME Accounting Accounting Marketing Marketing DEPT_PHONE 4356 4356 4378 4378 COLLEGE_NAME Business Admin Business Admin Business Admin Business Admin ADVISOR_LNAME Grastrand Grastrand Gentry Tillery ADVISOR_OFFICE T201 T201 T228 T356 ADVISOR_BLDG Torre Building Torre Building Torre Building Torre Building ADVISOR_PHONE 2115 2115 2123 2159 STU_GPA 3.87 2.78 2.31 3.45 STU_HOURS 75 45 117 113 STU_CLASS Junior Sophomore Senior Senior Sample Value 223456 McKulski Statistics MATH Mathematics 3420 Arts & Sciences Chen J331 Jones Building 3209 3.58 87 Junior