Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For the students that are currently studying in UK or USA display the following information: Student_id, student_name, last_name and the total amount of scholarships that

For the students that are currently studying in UK or USA display the following information:
Student_id, student_name, last_name and the total amount of scholarships that student receives
image text in transcribed
STUDENT(student id, name, father_name, last_name, gender, bth_date, birth_place, highschool_code, leaving_date, graduation_year) NOTE: Specifications for graduation year attribute: a) If the student is already graduated from bachelor program and he doesn't stady anymore abroad, this field contains simply information for graduation year. (e.g 2017) b) If the student isn't graduated yet from bachelos program, the value of this attribute will be: "On Going" c) If the student has completed the bachelor program and he continues to study abroad in master program, the value of this attribute will have the following format: "gradiation year (master)". e.g "2018/master)" The attribute Student_ID has the follows convention: Let assume that : 009034060109 is one student ID: 0090009034009034060090340601CountrycodeCityCodeUniversityCodeFacultyCode \& RESIDENCE_PERMISSION (country_cods, country_name, validation_period, renewal_duration, fee) CITY (city_cods, city_name, capital, population, official_lang, no_ universities, municipality_ scholarship) * ADDRESS_ABROAD (student_io, city_code, resident_perm_no, address, phone_no) \$ UNIVERSITY (uniy code, univ_name, foundation_year, no_of_faculty, no_of_inst, ) * FACULTY(faculry_code, foundation_datc, no_of_departments, teaching_lang, campus_address, faculty_scholarship) * EDUCATION_INFO(stadent id, university_code, faculty_code, registration_date, department_name, program_type, study_duration, grade, tuition_fee, GPA) Note: Possible Values of program type: "miaster" or "hachelor

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Database And Knowledge Base Systems

Authors: S Krishna

1st Edition

9810206208, 978-9810206208

More Books

Students also viewed these Databases questions