EBK MODERN DATABASE MANAGEMENT,
13th Edition
ISBN: 9780134792279
Author: TOPI
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 8, Problem 8.69PAE
Program Plan Intro
Filling the table by Y for yes and N for No based on the given assumptions.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Q: 2. Create the database name Company which consists of one Entity name Employee which
consists of 10 attributes
(ID/First Name/Last Name/CNIC/Gender/Department/Sal ary/Address/Age)
ID should be primary key
Insert at least 10 records in the Entity Employee with respect to their type.
a) Implementation the example of stored procedure now creates the stored procedure which:
a. Have an ability to insert the record in the table.
b. Have an ability to delete the record in table.
c. Have an ability to update the record in the table.
d. Have an ability to display the record in the table.
|
Subtitle
Dictate
Font
Paragraph
A Select v
Styles
Editing
Voice
Question 5I
Consider the following database instance.
For each of the following questions, show the contents of the database (1,e, re-draw the
tables showing the data) after performing the given SQL statements. Assume each SQL
statement is performed on the original database instance considering the effect of the
previous statements, so these are done in the order listed. After each step the data is
committed (written) to the database.
Table name: Student
Primary key: SID
SID
SNAME
5.1)
2.
Fred
delete from Student where sid = 1:
commit:
Mack
Shell
Table name: Course
5.2)
Primary key: CID
update Course set cid 5 where cid 1:
commit:
CID
CNAME
1
Finance
CIS
Table name: Register
5.3)
Primary key: SID.CID
Foreign key: SID references Student(SID)
on delete cascade
insert Register values(3,2);
commit
Foreign key: CID references Course(CID)
on update cascade
CID
SID
2.
5.4)
1
2.
update Register set gid = 1 where sid=2
commit…
The following are the basic processes of Boarding School Outing System.
Student may enter the outing request such as date, reason, check-out time
(check-in time is auto-set at 6.00 PM) to request for outing. The outing request
details are stored in 'Outing Request' record.
Warden can view the outing request and he/she may approve or disapprove the
request. The status of the request is updated in the Outing Request' record.
Once the status is updated, a short message service (SMS) notification will be
sent by the system to the student and parents. The hand-phone numbers are
retrieved from the Student' record.
Student will check-out and check-in via this system whenever he/she is about
to leave from the school and reports back to the school. The data (date and time)
is kept in the existing outing record.
Note:
**Definition of outing (in boarding school context): A day out from the hostel/school,
normally during the weekend.
Based on the scenario above:
a) Draw a Context Diagram for…
Chapter 8 Solutions
EBK MODERN DATABASE MANAGEMENT,
Ch. 8 - Prob. 8.1RQCh. 8 - Prob. 8.2RQCh. 8 - Prob. 8.3RQCh. 8 - Prob. 8.4RQCh. 8 - Prob. 8.5RQCh. 8 - Prob. 8.6RQCh. 8 - Prob. 8.7RQCh. 8 - Prob. 8.8RQCh. 8 - Explain why you sometimes have to reserve much...Ch. 8 - Why are field values sometimes coded?
Ch. 8 - Prob. 8.11RQCh. 8 - Prob. 8.12RQCh. 8 - Explain why normalized relations may not comprise...Ch. 8 - Prob. 8.14RQCh. 8 - List three common situations that suggest that...Ch. 8 - Explain the reasons why some experts are against...Ch. 8 - Prob. 8.17RQCh. 8 - Prob. 8.18RQCh. 8 - Prob. 8.19RQCh. 8 - Prob. 8.20RQCh. 8 - Prob. 8.21RQCh. 8 - Prob. 8.22RQCh. 8 - One of the strongest recommendations regarding...Ch. 8 - Explain why an index is useful only if there is...Ch. 8 - Indexing can clearly be very beneficial. Why...Ch. 8 - Prob. 8.26RQCh. 8 - Prob. 8.27RQCh. 8 - Describe the role of data dictionary in the...Ch. 8 - Prob. 8.29RQCh. 8 - Prob. 8.30RQCh. 8 - Explain how creating a view may increase data...Ch. 8 - Prob. 8.32RQCh. 8 - Prob. 8.33RQCh. 8 - Prob. 8.34RQCh. 8 - Prob. 8.35RQCh. 8 - Prob. 8.36RQCh. 8 - Prob. 8.37RQCh. 8 - Prob. 8.38RQCh. 8 - Prob. 8.39RQCh. 8 - How can views be used as part of data security?...Ch. 8 - Prob. 8.41RQCh. 8 - Prob. 8.42RQCh. 8 - Consider the following two relations for...Ch. 8 - Prob. 8.44PAECh. 8 - Prob. 8.45PAECh. 8 - Prob. 8.46PAECh. 8 - Prob. 8.47PAECh. 8 - Suppose you are designing a default value for the...Ch. 8 - When a student has not chosen a major at a...Ch. 8 - Prob. 8.50PAECh. 8 - Prob. 8.51PAECh. 8 - Consider the relations in Problem and Exercise...Ch. 8 - Prob. 8.53PAECh. 8 - Prob. 8.54PAECh. 8 - Prob. 8.55PAECh. 8 - Prob. 8.56PAECh. 8 - Prob. 8.57PAECh. 8 - Consider the relations specified in Problem and...Ch. 8 - Prob. 8.59PAECh. 8 - Prob. 8.60PAECh. 8 - Prob. 8.61PAECh. 8 - Prob. 8.62PAECh. 8 - Prob. 8.63PAECh. 8 - Prob. 8.64PAECh. 8 - Problems and Exercises 8-65 through 8-68 refer to...Ch. 8 - Prob. 8.66PAECh. 8 - Problems and Exercises 8-65i5 through 8-68 refer...Ch. 8 - Refer to Figure 4-5 0. For each of the following...Ch. 8 - Prob. 8.69PAECh. 8 - Prob. 8.70PAECh. 8 - Prob. 8.71PAECh. 8 - Prob. 8.72PAECh. 8 - Prob. 8.73PAECh. 8 - Prob. 8.74PAECh. 8 - Prob. 8.75PAECh. 8 - Prob. 8.76PAECh. 8 - Prob. 8.77PAE
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Access path A database table is composed of records and fields hold data. Data is stored in records. A field is a part of a record and contains a single piece of data for the subject of the record. The access path for finding the list of books is AUTHOR: AuthorID, Lname BOOKAUTHOR: AuthorID, ISBN BOOKS: Pubdate, ISBNarrow_forward(a) List all employees. Relational Algebra(RA): Tuple Relational Calculus(TRC): Domain Relational Calculus(DRC): (b) List all details of employees who are female. Relational Algebra(RA): Tuple Relational Calculus(TRC): Domain Relational Calculus(DRC):arrow_forwardDatabase course: a. List the details of all the employees who are from the department number 2. b. List the details of all the employees who joined the company after 01-JAN-11. c. List employeeNO and DepartmentNO of all the employees who work as ‘Engineer’ and earn more than 1800 Omani Rials. (I need the codes to copy it)arrow_forward
- please send me solution of this complete question subject: DBMSarrow_forwardNeed help in ER diagramarrow_forwardQuestion 3: ( DATABASE APPLICATION DEVELOPMENT ) The following table represents the hours worked per week for temporary staff at eachbranch of a company. TempStaffHours staffNo Branch No Branch Office Name Position Hours Address Phone Per Week Center 111125 Seattle, S4555 City Plaza, ВО02 Ellen Assistant 16 Layman WA 98122 S4555 ВО04 16 14th 422263 Ellen Assistant 9. Avenue, Seattle, Layman WA 98128 S4612 Center 111125 City Plaza,Seattle, ВО02 Dave Assistant 14 Sinclair WA 98122 S4612 B004 16 14th 422263 Dave Assistant 10 Avenue, Seattle, WA 98128 Sinclair S4718 Down Town 523632 Mary Kay ВО01 Cleaner 8 Alley, Jersey, JS 76542 a) Determine one anomaly that exist in the TempStaffHours table and criticize thedesign by giving an example of the anomaly. b) Given the following functional dependencies, perform normalization until the third normal form. Give justification related to anomalies on the design of the derived relations. staffNo, BranchNo → BranchAddress, OfficePhone, Name,…arrow_forward
- a. Display the employees where the salary is 2200-Upload Screen shot b. Display the employees where the salary is above 2000- Upload Screen shot c. Display the employees where the salary is greater than 2000 and the age is less than 25- Upload Screen shot d. Display only the Top 3 records from the employee table - Upload Screen shot e. Delete the employee whose ID is 2 - Upload Screen shot f. Display again only the Top 3 records from the employee table - Upload Screen shotarrow_forwardormulate the following queries in Structured Query Language SQL The following tables form part of a database held in an RDBMS: Employee (empNo, fName, lName, address, DOB, sex, position, salary, deptNo) Department (deptNo, deptName, mgrEmpNo) Project (projNo, projName, deptNo) WorksOn (empNo, projNo, dateWorked, hoursWorked) where Employee contains employee details and empNo is the key. Department contains department details and deptNo is the key. mgrEmpNo identifies the employee who is the manager of the department. There is only one manager foreach department. Project contains details of the projects in each department and the key is projNo (notwo departments can run the same project). WorksOn contains details of the hours worked by employees on each project, and empNo/ projNo/dateWorked form the key. Formulate the following queries in Structured Query Language SQL List all the details of employees who are female and born after 1990. List employee numbers and names of all…arrow_forwardThe following four tables form part of a library database: • Book (isbn, title, author, genre, price) • Copy (copyId, isbn) • Loan (userId, copyId, loanDate, dueDate) • User (userId, name, address, email) Where: • Book contains details of books and isbn is the primary key• Copy contains details of individual copies of books and copyId is the primary key• Loan contains details of loans and (userId, copyId, loanDate) forms the primary key • User contains details of library users and userId is the primary key 3.1 Identify the primary in the above schema. 3.2 Identify the foreign keys in the above schema. 3.3 Draw an Entity relationship model (ER-model) for the above schema, including: • all attributes• correct notation for primary and foreign keys • relationships• multiplicities 3.4 Draw sample tables for the above relations, ensuring relational integrity rules are met. 3.5 Explain the Entity Integrity constraint with reference to the Book relation.arrow_forward
- Perform the following operation in sql for insertion, updating and deletion using the referential integrity constraintsarrow_forwardAssumptions: The database stores information about houses, each with a house ID, address, and zip code. 2. The database stores information about person, including person ID, house ID where the person lives, person name, phone number, and status where 1 means currently tested positive (i.e., the most recent test result is positive), 0 means currently tested negative (i.e., the most recent test result is negative), and null (no test so far so status is unknown). 3.The database stores information about a person's all past tests, including person ID, test date, and result (1 means positive and 0 negative). 4.The database stores information about events (could be gathering, party, etc.). Each event has an event ID, event name, date, and address. 5. The database stores information about a person participated in an event. 6. The database stores information about flights, including flight ID, flight date, flight number (a varchar type e.g., 'DL 345' is a delta 345 flight). 7. The database…arrow_forwardSubject: DatabaseQuestion: Draw an ERD based on the given infoarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Programming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:Cengage
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage