Answered step by step
Verified Expert Solution
Question
1 Approved Answer
> CGS 2545C: Database Management Systems home > ng and dropping tables E zyBooks catalog CHALLENGE ACTIVITY 4.3.1: Creating and dropping tables. Jump to level
> CGS 2545C: Database Management Systems home > ng and dropping tables E zyBooks catalog CHALLENGE ACTIVITY 4.3.1: Creating and dropping tables. Jump to level 1 Table Country has a column IndepDate that currently accepts only a date. Write a statement that renames IndepDate to OfficialindepDate and changes OfficialindepDate to accept a date and time. /* Your code goes here * CHANGE / Your code goes here: Country TLD Capital ISOCode3 PopDensity 10.6 CAN .ca Ottawa QAT qa Doha 620.5 MWI .mw Lilongwe 498.4 Complete the statement that creates the table. CREATE TABLE Country ( ISOCode3 CHAR(3), TLD CHAR(3), Capital VARCHAR(15), PopDensity DECIMAL(7.2). /* Your code goes here */ ): Start CREATE TABLE Country PopDensity DECIMAL(7/2), Capital VARCHAR(15), TLD CHAR(3) NOT NULL) Area DECIMAL(92) NOT NULL) ISOCode2 CHAR(2), ContinentCode CHAR(2). PRIMARY KEY (PopDensity) ). Which columns can contain NULL values? PopDensity ISO Code TLD CntinentCode W Capital Area erting, updating, and deleting rows Start Refer to the column information produced by the SHOW COLUMNS FROM Country, statem Result Field Null Key Default Extra Type varchar(50) Name NO NULL ISO Code2 char(2) NO PRI NULL Population integer YES 0 Complete the statement to correctly insert a row with Population 7650154, ISOCode2 'SL', ana Leone'. Write the most straightforward code. INSERT INTO Country (Name, IsoCode2, Population) * Your code here */ earch 58 CGS 2545C: Database Management Systems home > grows zyBooks catalog CHALLENGE ACTIVITY 4.7.1: Selecting rows Start Country ContinentCode Area TLD D-O-D-D.O. 95900 SA ec AS vn 119700 223700 EU ua What columns are returned by the giver statements? SELECT ContinentCode SELECT FROM Country FROM Country A Contradd Continent Code 6 S 3 6 8 E R. T
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started