Write an sql statement to create a table named picture

Assignment Help Basic Computer Science

Reference no: EM131221291

Write an SQL statement to create a table named PICTURE with columns Name, Description, Date Taken, and File Name. Assume that Name is char (20), Description is varchar (200), Date Taken is small date, and File Name is char (45). Also assume that Name and Date Taken are required. Use Name as the primary key. Set the default value of Description to ‘(None)'.

Reference no: EM131221291

Questions Cloud

How will you declare the boundaries of the transaction : Suppose that you are writing a stored procedure to change values in the CUSTOMER table. What transaction isolation level will you use?

Summarize the procedures required to achieve star status : Provide your opinion as to which OSHA voluntary cooperative program would be the most beneficial to a small business. Summarize the procedures required to achieve Star status under OSHA's Voluntary Protection Program (VPP).

Miller to experience economies of scale : Describe 2 ways in which you would expect a company such as Miller to experience economies of scale that Corpus Christi Cheer Beer does not.

What roles have first ladies served in the government : What roles have first ladies served in the government? In your opinion, what is the appropriate level of power and monetary resources that should be granted to the presidential spouse?

Write an sql statement to create a table named picture : Also assume that Name and Date Taken are required. Use Name as the primary key. Set the default value of Description to ‘(None)'.

What factor contributed to the development of slavery : How and why did the transformation from early european settlement of the americas to slavery in the late 1600s occur?

Economic factors play in war : Trace the forces that led to the Second Gulf War ( aka The Iraq War of 2003). What role, if any, did oil or other economic factors play in this war?

Describe the risks and hazards to the community : Describe the risks and hazards to the community and why they are risks and hazards. Explain how your plan would address and/or utilize media (traditional and/or social media).

Explain the concepts of evidence-based practice : Explain the concepts of evidence-based practice and practice-based evidence and identify controversies associated with these concepts - Discuss the methodological issues and challenges that are unique to psychological research investigating effecti..

User Account

All Pages