EBK CONCEPTS OF DATABASE MANAGEMENT
8th Edition
ISBN: 8220100706004
Author: Last
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Question
Chapter 8, Problem 1CATC
To determine
To identify the data to be archived, when it should be archived and whether it should be archived from another table.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
access databases
Normalization Exercise
Represent this table as a collection of tables in 3NF:
Student (StudentNumber, StudentName, NumberCredits, AdvisorNumber, AdvisorName, CourseNumber, CourseDescription, Grade)
The manager of a consulting firm has asked you to evaluate a database that contains the table structure shown in the table below.Table: Sample CLIENT records Attribute name Sample value Sample value Sample value CLIENT_NUM 298 289 289 CLIENT_NAME Marianne R. Brown James D. Smith James D. Smith CLIENT_REGION Midwest Southeast Southeast CONTRACT_DATE 10-Feb-2018 15-Feb-2018 12-Mar-2018 CONTRACT_NUMBER 5841 5842 5843 CONTRACT_AMOUNT R22,985,00.00 R1,670,300.00 R11,250,000.00 CONSULT_CLASS_1 Database administration Internet services Database design CONSULT_CLASS_2 Web applications Database administration CONSULT_CLASS_3 Network installation CONSULT_CLASS_4 CONSULTANT_NUM_1 29 34 25 CONSULTANT_NAME_1 Rachel G. Carson Gerald K. Ricardo Angela M. Jamison CONSULTANT_REGION_1 Midwest Southeast Southeast CONSULTANT_NUM_2 56 38 34 CONSULTANT_NAME_2 Karl M. Spenser Anne T. Zuma Gerald K. Jele CONSULTANT_REGION_2 Midwest Southeast Southeast CONSULTANT_NUM_3 22 45 CONSULTANT_NAME_3 Julian H.…
For this problem, the registrar’s office has requested that we create a report of students and the number of courses they have taken to verify minimum graduation requirements. You have been tasked with creating a table and procedure that track this information. To complete this problem:
a. create a table (NOT a temporary table) called student_course_nums within the university database schema.
b. Write a procedure that accepts a student ID as input. You must name your procedure: __stuCourseNumsProc Where is your last name and is the day of the month you were born. Below is an example of how I named my procedure: Hollers_21_stuCourseNumsProc
c. The procedure calculates the total number of course sections attended by that student, and adds a tuple to the student_course_nums table consisting of the student’s ID number, name, and total courses attended - call these attributes: ID, name, and tot_courses.
d. If the student already has an entry in the table, then the procedure makes sure the…
Chapter 8 Solutions
EBK CONCEPTS OF DATABASE MANAGEMENT
Ch. 8 - Prob. 1RQCh. 8 - Prob. 2RQCh. 8 - Prob. 3RQCh. 8 - Prob. 4RQCh. 8 - Prob. 5RQCh. 8 - Prob. 6RQCh. 8 - Prob. 7RQCh. 8 - Prob. 8RQCh. 8 - Prob. 9RQCh. 8 - Prob. 10RQ
Ch. 8 - Prob. 11RQCh. 8 - Prob. 12RQCh. 8 - Prob. 13RQCh. 8 - Prob. 14RQCh. 8 - Prob. 15RQCh. 8 - Prob. 16RQCh. 8 - Prob. 17RQCh. 8 - Prob. 18RQCh. 8 - Prob. 19RQCh. 8 - Prob. 20RQCh. 8 - Prob. 1TDECh. 8 - Prob. 2TDECh. 8 - Prob. 3TDECh. 8 - Prob. 4TDECh. 8 - Prob. 1CATCCh. 8 - Prob. 2CATCCh. 8 - Prob. 3CATCCh. 8 - Prob. 4CATCCh. 8 - Prob. 1SCGCCh. 8 - Prob. 2SCGCCh. 8 - Prob. 3SCGCCh. 8 - Prob. 4SCGC
Knowledge Booster
Similar questions
- Use UStayWell Student Accommodation Database to answer the following questions A. Create a LARGE_PROPERTY table with the structure shown in Figure 6-29. B. Insert into the LARGE_PROPERTY table the office number, address, bedrooms, baths, monthlyrent, and owner number for those properties whose square footage is greater than 1,500 squarefeet. C. StayWell has increased the monthly rent of each large property by $150. Update the monthly rentsin the LARGE_PROPERTY table accordingly. D. Delete all properties in the LARGE_PROPERTY table for which the owner number is BI109. E. The property in managed by Columbia City with the address 105 North Illinois Rd is in the processof being remodeled and the number of bedrooms is unknown. Change the bedrooms value in theLARGE_PROPERTY table to null. F. Add to the LARGE_PROPERTY table a new character column named OCCUPIED that is onecharacter in length. (This column indicates whether the property is currently occupied.) Set thevalue for the OCCUPIED…arrow_forwardTask 10: User Oliver must be able to retrieve data from the PROPERTY table. 1 Task 11: Users Crandall and Perez must be able to add new owners and properties to the database. 4 Task 12: Users Johnson and Klein must be able to change the monthly rent of any property.arrow_forwardbased on the image, write SQL statement to display the patient's IC, name, the city's name of the quarantine centre and the nuber of the total days the patients been admiited in the quarantine centrearrow_forward
- Explain why it is necessary to limit the kinds of updates performed on data when referencing data through a view.arrow_forwardThe Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENACNE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys.arrow_forwardJoan Yancey has been asked to create a database for her company, Yancey Shipping. The database is to track employees and the special projects to which the employees may be assigned. A special project can have between 2 and 5 employees assigned to it. She has determined that she needs the following tables and fields in her database:(Table 1) Employee Information:Fields - Last Name, First Name, Street Address, City, State, Zip Code, Social Security Number, Phone Number, Hourly Pay Rate, and Project Number (Table 2) Project Information:Fields - Project Number, Project Name, Project Leader, Project Location, Total Hours, and Actual Completion Date What data type should Joan Yancey use for the Actual Completion Date field and why?arrow_forward
- For table EP, the attribute is a foreign key referencing target table For table EP, the attribute is a foreign key referencing target table For table ER the attribute is a foreign key referencing target table For table ER the attribute is a foreign key referencing target tablearrow_forwardbased of the image, write a sql statement that shows the total number of patients handle by each nurse. sort the result based on the nurse's ID and display the nurse's name tooarrow_forwardModify the CHARTER table to add the attributes shown in the following table. TABLE P8.37 ATTRIBUTES AND VALUES FOR PROBLEM 37 ATTRIBUTE NAME ATTRIBUTE DESCRIPTION ATTRIBUTE TYPE CHAR_WAIT_CHG Waiting charge for each model (copied from the MODEL table) Numeric CHAR_FLT_CHG_HR Flight charge per mile for each model (copied from the MODEL table using the MOD_CHG_MILE attribute) Numeric CHAR_FLT_CHG Flight charge (calculated by CHAR_HOURS_FLOWN CHAR_FLT_CHG_HR) Numeric CHAR_TAX_CHG CHAR_FLT_CHG tax rate (8%) Numeric CHAR_TOT_CHG CHAR_FLT_CHG + CHAR_TAX_CHG Numeric CHAR_PYMT Amount paid by customer Numeric CHAR_BALANCE Balance remaining after payment Numericarrow_forward
- What is a primary key? What is the primary key for each of the tables in the Colonial Adventure Tours database shown in Chapter 1?arrow_forwardAccess 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_forwardProblem 1 and 2 are based on the following query: SELECT EMP_LNAME, EMP_FNAME, EMP_AREACODE, EMP_SEX FROM EMPLOYEE WHERE EMP_SEX = 'F' AND EMP_AREACODE = '615' ORDER BY EMP_LNAME, EMP_FNAME; What indexes should you create? Write the required SQL commands.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
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
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning