Think of an organizational database in which some of the fields in the CUSTOMER table must have
Question:
Think of an organizational database in which some of the fields in the CUSTOMER table must have the following data types. Explain they mean and they are used.
a. Customer ID (auto-numeric field)
b. Customer Name (text field)
c. Fee Paid (logical field)
d. Pay Date (date field)
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 75% (12 reviews)
a The Customer ID field is an autonumeric field which means that it automatically generates a u...View the full answer
Answered By
Marvine Ekina
Marvine Ekina
Dedicated and experienced Academic Tutor with a proven track record for helping students to improve their academic performance. Adept at evaluating students and creating learning plans based on their strengths and weaknesses. Bringing forth a devotion to education and helping others to achieve their academic and life goals.
PERSONAL INFORMATION
Address: , ,
Nationality:
Driving License:
Hobbies: reading
SKILLS
????? Problem Solving Skills
????? Predictive Modeling
????? Customer Service Skills
????? Creative Problem Solving Skills
????? Strong Analytical Skills
????? Project Management Skills
????? Multitasking Skills
????? Leadership Skills
????? Curriculum Development
????? Excellent Communication Skills
????? SAT Prep
????? Knowledge of Educational Philosophies
????? Informal and Formal Assessments
0.00
0 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
-
Name two types of organizational design and explain how they differ.
-
Name a leader you think manages organizational culture well. How does the leader do this? Use Scheins description of how leaders reinforce culture to analyze the leaders behavior.
-
The mean numeric grades given by full-time and part- time faculty at Siena College are shown in Table 9 for various years. Let F and P be the mean numeric grades (in points) given by full-time...
-
What other advice can you offer owners of seasonal businesses about coping with the effects of their companies highly irregular sales patterns? About managing cash flow in general?
-
The Wizard's Corner, a company that sells video games and related items, had the following account balances at the end of June 2011: Cost of goods sold$103,000 Share capital.. 33,000 Advertising...
-
The source moves away from the stationary listener at 80 m/s. (a) Find the wavelength of the sound waves between the source and the listener. (b) Find the frequency heard by the listener.
-
Omar Corporation paid \($200,000\) for a tract of land that had an old gas station on it. The gas station was demolished at a cost of \($20,000\) and a new warehouse was constructed on the site at a...
-
Chem-Lite, Inc., maintains its accounts on the basis of a fiscal year ending March 31. At March 31, 20X1, the Equipment account in the general ledger appeared as shown below. The company uses...
-
You hear on the news that the S&P 500 was down 2.9% today relative to the risk-free rate (the market's excess return was -2.9%). You are thinking about your portfolio and your investments in Zynga...
-
State with brief reason whether the following statements are true, false, or uncertain: a. In the presence of heteroscedasticity OLS estimators are biased as well as inefficient. b. If...
-
Consider a book rental system in a comic store. When a customer borrows or returns a comic book, the shopkeeper needs to note down the transaction or update the corresponding record on the...
-
Contrast transactional and analytical data management approaches.
-
What steps are involved in a control risk assessment?
-
1--Explain how the IRS might use social media data to profile taxpayers that might be underpaying taxes. What additional information would they need to consider in addition to social media data to...
-
Juan Diego began the year with a tax basis in his partnership interest of $50,800. During the year, he was allocated $20,320 of partnership ordinary business income, $71,120 of $1231 losses, and...
-
On January 1, 2018, Lime acquired 80,000 common shares of Stone's for $900,000. On that day, Stone's balance sheet showed the following shareholders' equity: $ 2 Cumulative preferred shares, 20,000...
-
On November 7, Mura Company borrows $270,000 cash by signing a 90-day, 10%, $270,000 note payable. 1. Compute the accrued interest payable on December 31. 2. & 3. Prepare the journal entries to...
-
Kristen Lu purchased a used automobile for $22,900 at the beginning of last year and incurred the following operating costs: Depreciation ($22,900 + 5 years) Insurance Garage rent Automobile tax and...
-
Three moles of neon expand isothermally to 0.250 from 0.100 m3. Into the gas flows 4.75 103 J of heat. Assuming that neon is an ideal gas, find its temperature?
-
Dawson Companys balance sheet information at the end of 2019 and 2020 is as follows: Additional information: The company did not issue any common stock during 2020. Required : Next Level Fill in the...
-
Add a subtype discriminator (named Person Type) to the diagram you created in Problem and Exercise 2-29.
-
Develop an EER model for the following situation, using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor: A technology...
-
Draw an EER diagram for the following description of a law firm: Each case handled by the firm has a unique case number; a date opened, date closed, and judgment description are also kept on each...
-
The annual rainfall in a particular area of the country is normally distributed, with mean 100 cm and standard deviation 20 cm. A drought is said to occur after a year in which the annual rainfall...
-
Revenue $525.000 Sales Returns $13,900 Sales Discounts $12.400 Net Sales $498.700 Cost of Goods Sold $79.500 Gross Profit Gross Profit Margin % 84.0696
-
Start by entering the total units sold in B1. You get this information from the Inventory Sheet by summing the Units Soldcolumn. Hint: Don't do anything fancy with naming ranges or creating tables....
Study smarter with the SolutionInn App