2) Given the following conceptual schemas, address the questions. (20) Students(sid: string, name: string, login: string, age: integer, GPA: real) Faculty(fid: string, fname: string, sal: real) Courses( cid: string, cname: string, credits: integer) Rooms(rno: integer, address: string, capacity: integer) Enrolled (sid: string, cid: string, grade: string) Teaches(fid: string, cid: string) Meets_In( cid: string, rno: integer, time: string) 1. Identify and list primary key for each and explain reason for your choice 2. List the foreign keys and their constraint. Explain your response

2) Given the following conceptual schemas, address the questions. (20) Students(sid: string, name: string, login: string, age: integer, GPA: real) Faculty(fid: string, fname: string, sal: real) Courses( cid: string, cname: string, credits: integer) Rooms(rno: integer, address: string, capacity: integer) Enrolled (sid: string, cid: string, grade: string) Teaches(fid: string, cid: string) Meets_In( cid: string, rno: integer, time: string) 1. Identify and list primary key for each and explain reason for your choice 2. List the foreign keys and their constraint. Explain your response

Fundamentals of Information Systems

8th Edition

ISBN:9781305082168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter7: Knowledge Management And Specialized Information Systems

Section: Chapter Questions

Problem 13SAT

See similar textbooks

Similar questions

113. The data model that is produced from reverse engineering is: a. a conceptual model. b. an internal model. c. a logical model. d. None of the above is correct.
1. Provide an example of a data model, and an example of data that could be stored using that model. 2. Provide an example of a data structure, and an example of a data model it could implement.
1. Define Computer Science in: Informal Definition:Formal Definition:Extended Definition: 2. Define Software in: Informal Definition:Formal Definition:Extended Definition: 3. Define Database in: Informal Definition:Formal Definition:Extended Definition: ps. 1-3 sentences is great as long as you define it categorically correct
Exercise 7-6 Symbolize the following so as to reveal as much logical structure as possible. Indicate the meanings of your abbreviations. 1. All marsupials have pouches. 3. Actually, not all marsupials have pouches. 5. Kangaroos and opossums are both marsupials. 7. Koala bears are not really bears at all. 9. Marsupials can be found in their natural habitats in both Australia and North America. 11.
1. PART (40%): Evaluation and optimization:A schema of the ski shop information system is given:Customer (cid, name, surname, address, telephone);Employee (eid, name, surname, address, telephone);Purchase (pid, sid, cid, eid, date);Skiis (sid, brand, model, length, hardness)Additional information is given:|Customer| =150 pages, 40 records/page|Employee| = 2 pages, 40 records/page|Purchase| = 2000 pages, 100 records/page|Skiis| = 250 pages, 30 records/pageBuffer can store up to 2500 pages.Let's assume that the following indices are now set on the schema from the previoustask:- Level 2 B+ index on the attribute Purchase.date- Hash index on the attribute Skiis.sidOur DBMS has the following algorithms to perform the join:- Hash join- Index nested loops join- Sort-merge joinTranslate the following SQL query into relational algebra and find the plan that readsthe fewest pages or blocks:SELECT Skiis.model, Skiis.lengthFROM Skiis JOIN Purchase ON (Skiis.sid = Purchase.sid)WHERE Skiis.brand =…
1. The Intranet: A. Is the internal system of the organization B. Is the external system of the organization C. Links external data networks D. Prevents access to others outside 2. Citation database includes A. ScienceDirect B. Google Scholar C. Web of Science D. Scopus E. Academic Search Complete F. All answers are correct 3. Moderating Variable A. is one that has a strong contingent effect on the independent-dependent variable relationship. B. modifies the original relationship between the independent and the dependent variables C. is one that surfaces between the time the independent variables start operating to influence the dependent variable. D. All answers are correct 4. The questions in the questionnaire survey should be avoided: A. Ambiguous Questions B. Double-Barreled Questions C. Leading Questions D. Short Questions 5. Regarding ethics in data collection, the researcher should not: A. Misrepresent the nature of the study to…
43. The application of database management system in air flight seat booking in a way that one seat is accessed by only one clerk for customer reservation is classified as a. online transaction processing b. offline transaction processing c. online logical representation d. offline modeling representation
Computer Science 1.Consider a conceptual schema in which the only fact type associated with Department (code) is: Department at Level {UG, PG} has students in Quantity. Here “UG” and “PG” abbreviate “undergraduate” and “postgraduate”, respectively. The role played by Department has a frequency constraint of 2. Let a focused query be: What is the ratio of postgraduate to undergraduate enrollments for the department of computer science? (a) Draw the conceptual fact type, and Rmap it. (b) Optimize the conceptual (sub)schema, and Rmap it. (c) Although primarily identified by its code (e.g., “CS”), each department also has a unique name (e.g., “Computer Science”) which is now mandatorily recorded. The enrollment figures are now optional, but if any figures are recorded, both UG and PG figures are required. Draw the new conceptual schema and Rmap it. (d) Optimize the new conceptual schema, and Rmap it.
Analyze the diagram bellow and transform it from conceptual model to a logical model using the textual notation. You must represent it by respecting the following textual notation. Table name: is represented by the first word in capital letters in front of the parentheses. i.e. TABLE ();Columns name: are inside the parentheses separated by commas. i.e. (column1, column2);PK: Stay with the column which is the primary key. i.e. TABLE (column1 (PK), column2);FK: Stay with the column which is the foreign key. i.e. TABLE (column1 (PK), column2, column3 (FK));CPK: Stay with the column that makes up the composite primary key. i.e. TABLE ((column1, column2 (CPK)), column3);
Explain the distinction between information and data by providing some concrete instances.
122. The concepts of data models that are only useful to computer specialists rather than end users of programs are classified as a. triggered data models b. logical data models c. conceptual data models d. physical data models
Suppose you are working within the framework of the conceptual model in Figure Q4.5. FIGURE Q4.5 THE CONCEPTUAL MODEL FOR QUESTION 5

SEE MORE QUESTIONS

Recommended textbooks for you

Fundamentals of Information Systems

Computer Science

ISBN:

9781305082168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781305082168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS