Question: Kratz Computer Repair maintains a database that contains a table of information about each repair job the company agrees to perform. The jobs table is

Kratz Computer Repair maintains a database that contains a table of information about each repair job the company agrees to perform. The jobs table is described as: tblJobs(jobId, dateStarted, customerId, technicianId, feeCharged). Each job has a unique ID number that serves as a key to this table. The customerId and technicianId columns in the table each link to other tables of customer information (such as name, address, and phone number) and technician information (such as name, office extension, and hourly rate). When the tblJobs and tblCustomers tables are joined, which is the base table?
a. TblJobs
b. TblCustomers
c. TblTechnicians
d. A combination of two tables

Step by Step Solution

★★★★★

3.34 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

ANSWER a TblJobs EXPLANATION The tblJobs table is the base table in this scenario The other tables t... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Logic & Design Comprehensive Questions!

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

You are in the process to create a database that contains all information about different Taxi companies in your country. This will help the customers to select their desired company, and reserve the...

Create an ER diagram CSCI335: Project Taxi Reservation Database You are in the process to create a database that contains all information about different Taxi companies in your country. This will...

design compufix cultural web and its main elements. base your answer on the description offered in the case study at about the time when the workshops begun (1992) Case study: Compufix Inc, by...

\f\f\fChapter 2 Service Strategy Learning Objectives After completing this chapter, you should be able to: 1. Formulate a strategic service vision. 2. Describe how a service competes using the three...

SKY HIGH AIRLINES SAFETY MANUAL EXERCISE \"Getting you there higher and faster\" Instructions This is an actual aviation company Safety Manual (fictitiously named Sky High Airlines to protect the...

Please help me answer this question Background Veronese 81 Tiffany Inc. is a medium-sized business located in Elmira, Ontario. It sells designerjewelry to specialty stores through Canada as well as...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

Need help with the following task below: Scenario Prior to commencing your role as site supervisor, you will need to ensure that you are familiar with Australia Wide Landscaping standards, values,...

Hi, I am having trouble configuring the cost of debt from the attached 10-k for O'Reilly. These are steps I must follow: a.Cost of Debt i.Determine the market value of the firm's debt issues. Be sure...

Use the NPV method to determine whether Vargas Products should invest in the following projects: Project A: Costs $280,000 and offers eight annual net cash inflows of $57,000. Vargas Products...

Prediction of the thermal conductivity of a gas mixture, calculate the thermal conductivity of a mixture containing 20 mole % CO 2 and 80 mole % H 2 at 1atm and 300K. Use the data of Problem 9A.2 for...

If you sell a stock short when it is worth $ 1 0 0 , then cover your short sale some time later when the same stock is worth $ 1 8 0 , you have a _ _ _ _ _ _ of _ _ _ _ _ _ . Ignore any borrowing...

14. What are the three major legal forms of business enterprises? Which form is the most prevalent in terms of numbers? Which form is dominant in terms of total sales revenues?

You save text files containing Java source code using the file extension ____________. a. .java b. .class c. .txt d. .src

When data cannot be changed after a class is compiled, the data is _____________. a. Variable b. Constant c. Volatile d. Mutable

Which of the following is not a primitive data type in Java? a. Boolean b. Byte c. Sector d. int

Can i please get help with these please 14.A bond with a par value of $1000 sells for $960. The bond matures in 5 years and has a 7% annual coupon rate paid semi-annually. Calculate the realized...

ASSIGNMENT The Brief Founded in 1984, ShopHere has grown from a single market stall to a national, multi-channel retailer ShopHere sells high-quality products across 95 stores in Australia and...

You are considering producing a new product, which if it is successful will produce cash flows of $ 5 0 , 0 0 0 per year in perpetuity. If it is unsuccessful, the cash flow will be - $ 1 9 , 0 0 0 in...