Database Concepts (8th Edition)
8th Edition
ISBN: 9780134601533
Author: David M. Kroenke, David J. Auer, Scott L. Vandenberg, Robert C. Yoder
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 1, Problem 1.14RQ
Explanation of Solution
Number of themes in The Veterinary Office List – Version Two table:
Themes:
Two themes in the list:
Note: Refer the table 1-35 in the textbook.
There are three themes. They are:
- Pet details
- Owner details
- Service details
Pet details table:
The pet details table contains the following attributes such as “PetName”, “PetType”, “PetBreed”, and “PetDOB”.
| PetName | PetType | PetBreed | PetDOB |
| King | Dog | Std.Poodle | 27-Feb-14 |
| Teddy | Cat | Cashmier | 1-Feb-13 |
| Fido | Dog | Std.Poodle | 17-Jul-15 |
| AJ | Dog | Collie mix | 5-May-15 |
| Cedro | Cat | Unknown | 6-Jun-12 |
| Woolley | Cat | Unknown | ???? |
| Buster | Dog | Border Collie | 11-Dec-11 |
| Jiddah | Cat | Abyssinian | 1-Jul-08 |
Owner details table:
The owner details table contains the following attributes such as “Owner_Lname”, “Owner_Fname”, “OwnerPhone”, and “Owner_mail”...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
I need help writing pseudocode for this function. The following pseudocode statement calls a function named half, which returns a value that is half that of the argument. (Assume both the result and number variables are Real.)
Set result = half(number)
Need help converting my pseudocode to python, AND have a flowchart showing everything!The code:Main Module Call InputModuleEnd Main Module
Module InputModule // This module gets input from the user Declare Principal, AnnualRate, Years as Float
Output "Enter the Principal amount (P): " Input Principal
Output "Enter the Annual Interest Rate (in percentage, e.g., 5 for 5%): " Input AnnualRate
Output "Enter the number of Years to repay the loan: " Input Years
Call DisplayPayment(Principal, AnnualRate, Years)End Module
Module DisplayPayment(Principal, AnnualRate, Years) // This module calculates and displays the monthly payment Declare R, N as Float Declare MonthlyPayment as Float Declare PowerFactor as Float // second local variable
// Calculate monthly interest rate R and number of months N Set R = (AnnualRate / 100) / 12 Set N = Years * 12
// Calculate PowerFactor = (1 + R)^N Set PowerFactor = (1 + R) ^ N
// Calculate…
Whats wrong with my pseudocode? Where did I make an error?Code:
Module main()
Declare Real mileage
Call getMileage()
Display “You’ve drive a total of “, mileage, “ miles
End Module
Module getMilage() Display “Enter your mileage: “
Input mileage
End Module
Chapter 1 Solutions
Database Concepts (8th Edition)
Ch. 1 - Prob. 1.1RQCh. 1 - Prob. 1.2RQCh. 1 - Prob. 1.3RQCh. 1 - Why is the study of database technology important?Ch. 1 - Prob. 1.5RQCh. 1 - Describe the purpose of a database.Ch. 1 - Prob. 1.7RQCh. 1 - Prob. 1.8RQCh. 1 - Prob. 1.9RQCh. 1 - Prob. 1.10RQ
Ch. 1 - Break the list in Figure 1-34 into two tables,...Ch. 1 - Show how the tables you created for question 1.11...Ch. 1 - Prob. 1.13RQCh. 1 - Prob. 1.14RQCh. 1 - Break the list in Figure 1-35 into tables, each...Ch. 1 - Describe in your own words and illustrate with...Ch. 1 - Prob. 1.18RQCh. 1 - Define the term database.Ch. 1 - Prob. 1.20RQCh. 1 - List the components of a database.Ch. 1 - Prob. 1.22RQCh. 1 - Prob. 1.23RQCh. 1 - Prob. 1.24RQCh. 1 - What is the purpose of a DBMS?Ch. 1 - List the specific functions of a DBMS.Ch. 1 - Define the term referential integrity constraint....Ch. 1 - Prob. 1.28RQCh. 1 - List the functions of a database application.Ch. 1 - Prob. 1.30RQCh. 1 - Prob. 1.31RQCh. 1 - Prob. 1.32RQCh. 1 - Prob. 1.33RQCh. 1 - Prob. 1.34RQCh. 1 - Prob. 1.35RQCh. 1 - Prob. 1.36RQCh. 1 - Prob. 1.37ECh. 1 - Prob. 1.38ECh. 1 - Prob. 1.39E
Knowledge Booster
Similar questions
- I need help!! Writing a long pseudocode for a modular program that will display the monthly payment on a mortgage. P=Principal amount borrowed (loan)R=Rate of interest computed for each monthN=Number of months to pay back the loan or mortgageThe help I need is creating a module that you can input the principle, rate of percentage, and years to repay the loan, and another module "displaypayment" that accepts the 3 values and calculates the monthly payment needed for the rates. Lastly 2 local variables needed!Equation:Monthly Payment=[(R*(1+R)^N)/((1+R)^N-1)]*Parrow_forwardTwo pseudocode questions I need help with: How do I design a module called findSum that will display the sum of two integer passed by parameter, and a module called findArea that will display the area of a rectangle when passed 2 real values for the length and width of the rectangle?arrow_forwardFor the pseudocode module, what is displayed with the call findValue(1, 4, 2)?Module findValue(Integer a, Integer b, Integer c) Declare Integer value value = b + c - a Display valuearrow_forward
- I need help finishing my python rock paper scissors code, where it asks the user "rock, paper, scissors", the user types either option (repeatedly asks until its one of the three), and for a random option from the code to select also rock paper scissors. The end result would be you winning, code winning, or a tie.My code:import randomOPTIONS = ("ROCK", "PAPER", "SCISSOR") def getInput(): """ Function getInput() will receive and validate user input to be the string ROCK, PAPER, or SCISSOR. Input must be spelled correctly and in all capital letters. Function will return the validated input @return user input as ROCK, PAPER, OR SCISSOR """ #need help here def checkWinner(user, computer): """ Function checkWinner will accept 2 string parameters that must be unique values of ROCK, PAPER, or SCISSOR. Functions should return true if the string in parameter user beats the string in parameter computer in a game of rock…arrow_forwardI need help understanding how could I got the IP Address for the 1st Host on this Subnet, the IP Address for the Last Host on this Subnet & the Broadcast Address for this Subnet My Explanation:8 bits --> 17 & 0 128 64 32 16 | 8 4 2 1 0 0 0 1 0 0 0 1 -->17+ 0 0 0 0 0 0 0 0 --> 0 0 0 0 0 0 0 0 0 --> 0 (The Major (Base) Network Address): 142.20.33.0 To find the broadcast address, we can set all the bits in the host portion of the address to 1, which gives us 142.20.33.255. Based on the subnet mask 255.255.255.0, no bits were borrowed from the host portion, meaning 8 bits remain in the host portion. Using the formula 2^h – 2 (where h represents the number of host bits), we get 2^8 - 2 = 254 hosts. 8 bits --> 17 & 252 128 64 32 16 | 8 4 2 1 0 0 0 1 0 0 0 1 --> 17+ 1 1 1 1 1 1 0 0 --> 252 0 0 0 1…arrow_forwardWhich of the following opens when you click the launcher in the Size group on the Ribbon? Question 19Select one: a. Size dialog box b. Layout dialog box c. Width and Height dialog box d. Format dialog boxarrow_forward
- How do you resize a graphic object horizontally while keeping the center position fixed? Question 20Select one: a. Drag a side sizing handle. b. Press [Ctrl] and drag a side sizing handle. c. Press [Alt] and drag a side sizing handle. d. Press [Shift] and drag a side sizing handle.arrow_forwardWhich of the following indicates that a graphic is anchored to the nearest paragraph? Question 18Select one: a. X and Y coordinates b. An anchor symbol c. A paragraph symbol d. ruler marksarrow_forwardWhich command in the Adjust group allows you to change one picture for another but retain the original picture's size and formatting? Question 17Select one: a. Change Picture b. Replace c. Swap d. Relinkarrow_forward
- How do you insert multiple rows at the same time? Question 10Select one: a. Select the number of rows you want to insert, then use an Insert Control or use the buttons on the Ribbon. b. Click Insert Multiple Rows in the Rows & Columns group. c. Select one row and click the Insert Above or Insert Below button. You will be prompted to choose how many rows to insert. d. You cannot insert multiple rows at the same time.arrow_forwardHow do you center the text vertically in each table cell? Question 9Select one: a. Select the table and click the Distribute Columns button. b. Select the table and click the Center button in the Paragraph group on the Home tab. c. Select the table and click the AutoFit button. d. Click the Select button in the Table group, click Select Table, then click the Align Center Left button in the Alignment group.arrow_forwardA(n) ____ is a box formed by the intersection of a column and a row. Question 8Select one: a. divider b. table c. border d. cellarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
Enhanced Discovering Computers 2017 (Shelly Cashm...Computer ScienceISBN:9781305657458Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. CampbellPublisher: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 LearningNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
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
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage