Examine the three tables with student data shown in Figure 9-1. Design a single-table format that will
Question:
Examine the three tables with student data shown in Figure 9-1. Design a single-table format that will hold all of the data (non redundantly) that are contained in these three tables. Choose column names that you believe are most appropriate for these data.
Figure 9-1
Transcribed Image Text:
STUDENT DATA StudentNo LastName MI FirstName Telephone Status 123-45-6789 Enright T Mark 483-1967 Soph 389-21-4062 Smith R Elaine 283-4195 Jr STUDENT EMPLOYEE StudentID Address Dept Hours 123-45-6789 1218 Elk Drive, Phoenix, AZ 91304 Soc 8 389-21-4062 134 Mesa Road, Tempe, AZ 90142 Math 10
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 72% (11 reviews)
STUDENT DATA StudentID StudentName Telephone Add...View the full answer
Answered By
Cyrus Sandoval
I a web and systems developer with a vast array of knowledge in many different front end and back end languages, responsive frameworks, databases, and best code practices. My objective is simply to be the best web developer that i can be and to contribute to the technology industry all that i know and i can do. My skills include:
- Front end languages: css, HTML, Javascript, XML
- Frameworks: Angular, Jquery, Bootstrap, Jasmine, Mocha
- Back End Languages: Java, Javascript, PHP,kotlin
- Databases: MySQL, PostegreSQL, Mongo, Cassandra
- Tools: Atom, Aptana, Eclipse, Android Studio, Notepad++, Netbeans.
Having a degree in Computer Science enabled me to deeply learn most of the things regarding programming, and i believe that my understanding of problem solving and complex algorithms are also skills that have and will continue to contribute to my overall success as a developer.
I’ve worked on countless freelance projects and have been involved with a handful of notable startups. Also while freelancing I was involved in doing other IT tasks requiring the use of computers from working with data, content creation and transcription.
5.00+
1+ Reviews
10+ Question Solved
Related Book For
Modern Database Management
ISBN: 9780134773650
13th Edition
Authors: Heikki Topi, Jeffrey A Hoffer, Ramesh Venkataraman
Question Posted:
Students also viewed these Computer science questions
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
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...
-
The Rockport Youth Center also runs half-day Winter Youth Events, Hip-Hop Dance, Secret Agent Day, and Zombietron Workshop, for boys and girls in grades 1 through 5. Stephen wants you to automate the...
-
The Kelly Services, Inc., and Subsidiaries statements of earnings from its 2008 annual report are presented in Exhibit 5-4. Required a. Using the statements of earnings, prepare a vertical...
-
Imagine a monopolist that has fixed costs but no variable costs (thus there are no marginal costs, so MC = 0). For example, consider a firm that owns a spring of water that can produce indefinitely...
-
A major criticism of the regulatory regime in the past was that it lacked independence from the accounting profession. Discuss the extent to which that criticism is still valid for the new regulatory...
-
Journalize the following adjusting entries at December 31: 1. Services provided but not recorded, $1,500. 2. Salaries earned by employees but not recorded, $2,300. 3. Accrued interest on a note...
-
Weiland Co. shows the following information on its 2016 income statement: sales = $173,000; costs = $91,400; other expenses = $5,100; depreciation expense = $12,100; interest expense = $8,900: taxes...
-
need perfect answer please Jason purchased an old car for $1000. He spent $5200 rebuilding and auctioning it. A dealer states at auction Jason has a 60% chance of selling the car at $40,000; a 25%...
-
A spherical vessel used as a reactor for producing pharmaceuticals has a 5-mm-thick stainless steel wall (k = 17 W/m K) and an inner diameter of D j = 1.0 m. During production, the vessel is filled...
-
Why should changes be made to the data warehouse design? What are the changes that need to be accommodated?
-
Create an index on the CustomerID column of the Customer_T and Order_T table in Figure 4-4. Figure 4-4 A CustomerID 4 A + + G + + 14 + f Record: H E 16:0 A OrderID # 3 Record: 14 Customer_T...
-
The results of a time study to perform a quality control test are shown in the following table. On the basis of these observations, determine the normal and standard time for the test, assuming a 23%...
-
Arch Airway expects to purchase 5.6 million gallons of jet fuel in three months and decides to use heating oil futures to hedge the fuel price risk. A regression has been performed: The dependent...
-
January 1: Issued 15,000 shares of $20 par common stock at $30, receiving cash. Record the transaction in the general journal.
-
Reider v. Louisiana 897 So.2d 893, 2005 WL 545142 (La., 2005) 1. What tort theory did the plaintiff use to establish liability? What doctrine was applied to establish the duty owed by the university?...
-
|Engineer Co. is submitting a bid for a major job and estimates the following direct labor costs: Hours Hourly Rate Engineers Drafters 210 250.00 140 $ 120.00 350 $ 20.00 Staff Engineer Co. has no...
-
Ali and Yousef established AY partnership on January 1, 2020. Each one invested 20000. On March 1, All invest 2000, on June 1 Yousef invests 4000. On September 1, Ali withdraws 1000. On November 1,...
-
The Financial Accounting Standards Board requires companies to supplement their consolidated financial statements with disclosures about segments of their businesses. To comply with this standard,...
-
Solve each equation or inequality. |6x8-4 = 0
-
What types of data transformations might be needed in order to build the Fitchwood data mart?
-
After some further analysis, you discover that the commission field in the Policies table is updated yearly to reflect changes in the annual commission paid to agents on existing policies. Would...
-
Any successful data governance program needs to address the people ("who"), ("how"), and technology ("what") aspects. Based on your reading of Chapter 10, provide some examples for each of these...
-
A sailboat costs $23,923. You pay 25% down and amortize the rest with equal monthly payments over a 15-year period. If you must pay 6.6% compounded monthly, what is your monthly payment? How much...
-
? 1 . ?Calculate Gross Revenue 2 . ?Calculate Total Revenue 3 . ?Calculate Expenses 4 . ?Calculate Net Operating Income 5 . ?Calculate Net Income Community Information Number of Apartments Monthly...
-
Two men, on either bank of a canal, pull a boat that moves at a constant speed on a straight path in the middle. The men pull through ropes with F 1 = F 2 = 300 N forces that make a 30 angle with the...
Study smarter with the SolutionInn App