What data types would you assign to the City and Zip fields when creating the Zips table?
Question:
What data types would you assign to the City and Zip fields when creating the Zips table?
a. TEXT to City and SHORT to Zip
b. LONGTEXT to City and TEXT to Zip
c. TEXT to City and TEXT to Zip
d. SHORT to City and SHORT to Zip
Transcribed Image Text:
ProjectID ProjectStartDate ClientID EmployeelD 06-Feb-19 1 1 2 3 4 7 9 10 11 13 14 15 16 17 18 19 20 222 21 23 07-Feb-19 11-Mar-19 10-Apr-20 02-Sep-19 06-Jan-20 10-Feb-20 31-Mar-21 30-Apr-20 30-Nov-20 09-Dec-20 21-Dec-20 04-Jan-21 15-Feb-21 14-Apr-21 04-Jun-21 30-Jul-21 31-Aug-21 30-Sep-21 12-Nov-21 2 3 4 2 3 6 7 9 10 15 14 11 12 6 13 1 16 20 18 52 63 52 52 63 52 63 19 19 64 19 19 52 52 63 52 63 19 19 63 ProjectNotes Client wants digital solutions to help rebrand company name to emphasize commercial real estate. Client needs help converting, organizing, and managing various sources/formats of donor and donation data. Client wants to establish SEO goals. Client wants to set up an internal server as well as help with a domain name. Client has used the database for several months and now needs new report Develop and implement website SEO strategy. Needs help to manage and organize internal data. Develop new website content. Client needs internal database to manage personnel. Client needs subcontracting help installing a new database for a WordPress site. Client needs new functionality for current JavaScript application. Client needs new functionality for current Ruby/Rails application. Client needs help with server security. Current online sales solution is unreliable. Client needs internal database to manage inventory. Client needs new functionality for current C# / ASP.NET application. Client needs full website reskin. Client needs help with data analytics. Client needs an online reference database Client needs new blog and current pages updated to include responsive web design principles for mobile devices.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 0% (1 review)
Answered By
Nazrin Ziad
I am a post graduate in Zoology with specialization in Entomology.I also have a Bachelor degree in Education.I posess more than 10 years of teaching as well as tutoring experience.I have done a project on histopathological analysis on alcohol treated liver of Albino Mice.
I can deal with every field under Biology from basic to advanced level.I can also guide you for your project works related to biological subjects other than tutoring.You can also seek my help for cracking competitive exams with biology as one of the subjects.
3.30+
2+ Reviews
10+ Question Solved
Related Book For
Concepts Of Database Management
ISBN: 9780357422083
10th Edition
Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt
Question Posted:
Students also viewed these Computer science questions
-
Give some examples of field names that you would use for the Customer table in Figure. What data type would you assign to each field using Microsoft Access, and how large would you make each text...
-
You have been employed to create program to assist the manager of a coffee shop. You decide to make a prototype application in Java to show what you can do, and to be able to ask the manager what...
-
You are considering an investment in one of two preferred stocks, TCF Capital or TAYC Capital Trust. TCF Capital pays an annual dividend of $ 2.69, while TAYC Capital pays an annual dividend of $...
-
The number of males per 100 females, age 70 or over, in the United States for some recent years is shown in the following table. (a) Plot the data, letting t be the years since 1970. (b) Would a...
-
In 1944, W. E. Collins conveyed land to the Church of God of Prophecy. The deed said: This deed is made with the full understanding that should the property fail to be used for the Church of God, it...
-
A compression spring is needed to fit over a 0.5-in diameter rod. To allow for some clearance, the inside diameter of the spring is to be 0.6 in. To ensure a reasonable coil, use a spring index of...
-
Plaintiff sought to enforce against the defendant estate a promise made by his now-deceased uncle to pay Plaintiff a sum of money if Plaintiff refrained from the use of alcohol and tobacco for a...
-
Crowe Sales uses standard costs and variances for controlling costs. As a result of studying past cost data, it has established standards as follows: variable costs, $6 per sales call; nine sales...
-
The money supply process involves various factors, including the actions of commercial banks, the central bank's monetary policy, and the public's demand for money. My questions are: How do these...
-
Which SQL statement calculates the Bonus field in the Employees table as 10 percent of Salary? a. SELECT Salary * 0.1 AS Bonus FROM Employees; b. SELECT Bonus AS Salary * 0.1 FROM Employees; c....
-
Is Zip a text field?
-
December 31, 2014, trial balances for Pledge Company and its subsidiary Stom Company follow: Pledge Company purchased 72,000 shares of Stom Company's common stock on January 1, 2011, for $300,000. On...
-
Jon has an individual account and an UGMA account that he has opened up for his daughter. Both accounts are at the same brokerage house. what is the combined maximum SIPC coverage for both accounts?
-
1. Discuss the core tradeoffs about global marketing: standardization versus customization. Use at least on example in your presentation 2. What marketing potential does the internet offer small...
-
Suppose in 2015, DBP sold merchandise for $3,500,000 and, based on past experience, recorded a provision for sales returns of $75,000. In 2016, customers returned $50,000 worth of these goods sold to...
-
1. why is 12 a big age for development for children.? 2.why is 22 a big age for development for an adult.? 3. Government spending does not cause economic growth but it does cause economic disruption...
-
With regard to taxation of partnerships, Multiple Choice a partnership files a federal and state partnership tax return and pays taxes on its income. a partnership files a state partnership tax...
-
Waters Corporation has a stock price of $20 a share. The stocks year-end dividend is expected to be $2 a share (D1 = $2.00). The stocks required rate of return is 15 percent and the stocks dividend...
-
Read Case Study Google: Dont Be Evil Unless and answer the following: Given its mission of providing information to the world, should Google censor searches in China?
-
True or false? Consider congestion control in TCP. When the timer expires at the sender, the value of ssthresh is set to one half of its previous value.
-
Consider two network entities. A and B. which are connected by a perfect hi-directional channel (i.e., any message sent will he received correctly: the channel will not corrupt, lose, or re-order...
-
Suppose two TCP connections are present over some bottleneck link of rate R bps. Both connections have a huge tile to send (in the same direction over the bottleneck link. The transmissions of the...
-
ges of the cells.) 18. A power company charges a city $1.2167 per street lamp per month. There are 1,125 street lamps supplied with current. What is the city's power bill per year for the street...
-
John Haley hired Mary Black as a bookkeeper at Florida Dental Center, Inc. Haley fired Black when he learned that she embezzled more than $ 2 0 0 , 0 0 0 and did not pay over $ 1 5 0 , 0 0 0 in state...
-
Blossom Company has 2 Divisions: Computers and Appliances. Given the following data, what is the break-even point in sales dollars? Total fixed costs $620000 Sales-mix percentage 0.40 for Computers...
Study smarter with the SolutionInn App