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: 50% (2 reviews)
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...
-
Which of the relationships in Questions 4 and 5 is a positive relationship and which is a negative relationship?
-
Iliana and Ilias commenced a partnership on 1 January 2009, each contributing capital of 25,000, and agreed to share profits equally. The partnerships net profit is 9,000 for the period to 30 June...
-
Simmons Manufacturing Company makes various electronic products. The company is divided into a number of autonomous divisions that can either sell to internal units or sell externally. All divisions...
-
MY NOTES PRACTICE ANOTHER The National Sleep Foundation surveyed representative samples of adults in six different countries to ask questions about sleeping habits.+ Each person in a representative...
-
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?
-
In lean production, what is just-in-time delivery of parts?
-
Referring to the Sustainability Policy of Blue Bay Learning Centre and your knowledge of sustainability practices, briefly explain a strategy that can be used to improve children's experiences and...
-
Sandhill, Inc.'s static budget at 3,000 units of production includes $12,990 for direct labor, $3,990 for utilities (variable), and total fixed costs of $25,000. Actual production and sales for the...
-
Explain the link between leadership and organisational culture, and provide an example of a specific leadership style that can facilitate a specific organisation culture. 2 Describe the...
-
How do hormonal signaling pathways orchestrate complex physiological processes at the cellular and systemic levels, and what are the implications of disruptions in these pathways for...
-
Wide Company desires to have 700 units as an ending inventory of July 31. Budgeted sales for July are 3,450 units. Inventory on June 30 was 850 units. What are the number of units to purchase?
-
Indicate whether each of the following statements is (i) Always true, (ii) Sometimes true, or (iii) Never true. For those that are (ii) Sometimes true, explain when the statement is true. a. The...
-
A certain Christmas tree ornament is a silver sphere having a diameter of 8.50 cm. Determine an object location for which the size of the reflected image is three-fourths the size of the object. Use...
-
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...
-
Encuentre las partidas que se estn omitidas en el siguiente resumen de declaracin de impuestos. a. Ingreso Bruto $42,685 b. Ajustes al ingreso $3,670 c. Ingreso Bruto Ajustado ? d. Deducciones $8,978...
-
A business employs other individuals, which of the following, paid out of its own funds as an employer, can be deducted as expenses? Question 9Select one: a. Social Security (FICA) b. Medicare c....
-
Vito's investment fund is not doing so well and there is mounting pressure to show results of growth in his fund. He decides to invest in obscure penny stocks and started spreading over exaggerated...
Study smarter with the SolutionInn App