The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | Apr 2017 |
| Last Sign in: | 103 Weeks Ago, 4 Days Ago |
| Questions Answered: | 4870 |
| Tutorials Posted: | 4863 |
MBA IT, Mater in Science and Technology
Devry
Jul-1996 - Jul-2000
Professor
Devry University
Mar-2010 - Oct-2016
Question on the attach file
DATABASES AND DATABASE USERSÂ
DATABASE SYSTEM CONCEPTS AND ARCHITECTURE
DATA MODELING USING THE ENTITY-RELATIONSHIP (ER) MODEL
Â
CHAPTER 1: DATABASES AND DATABASE USERS1.Figure 1.2 shows the database structure and a few sample data records (in five different filesor tables) for a University database that has the goal of maintaining information on students,courses, and grades in a university.(Total for que 1 is 10 marks)i)Provide 2 informal queries from this database with their answers. Each query shouldinvolve at least 2of the files in the database and your answer should indicate thefiles (e.g., Student, Course) needed to answer each query and specify what fields arebeing retrieved as the result (e.g., Course_name, Course_number). Please, provideyour solution in the 3 column table below.(3 marks)Solution :QueryAnswerFiles involved1
Attachments: