SYM 400 Tables Keys and Constraints

docx

School

Grand Canyon University *

*We aren’t endorsed by this school

Course

400

Subject

Computer Science

Date

Jan 9, 2024

Type

docx

Pages

6

Uploaded by PeanutButterEater102

Report
Tables, Keys, and Constraints 1 SYM 400 Introduction to Database Structures
Tables, Keys, and Constraints 2 First I need to log into this week’s assignment through LopesCloud. 1. C reate a new table called Birthday with the following columns: BusinessEntityId column as an integer, and a DoB (Date of Birth) column in as date. To do this I type in the following query:
Tables, Keys, and Constraints 3 Create Table DateofBirth( BusinessEntityId int, DoB Date ); The table already exists so to pull up the DateofBirth table I use the command Select * and in line two From DateofBirth:
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Tables, Keys, and Constraints 4 2. Add a constraint to make BusinessEntityID a primary key. To do this I type in the following command: ALTER TABLE DateofBirth ALTER COLUMN BusinessEntityId int NOT NULL; GO ALTER TABLE DateofBirth ADD PRIMARY KEY (BusinessEntityId); 3. Insert one record for BusinessEntityID 1 and include 1990/01/01 as the birthday. To do this I type in the following command: INSERT INTO DateofBirth (BusinessEntityId, DoB) VALUES (1, ‘1990-01-01’);
Tables, Keys, and Constraints 5 I then received a 1 row affected message indicating it only changed the 1 record. 4. Once added, query your new table showing the new record. This is a test to make sure my new table shows the new date of birth is displayed when I execute the following command: SELECT * FROM DateofBirth
Tables, Keys, and Constraints 6 This pulls up BusinessEntityId number 1 and date of birth 1990-01-01. Lastly, I saved the query as a .sql file in my folders drive which concludes the assignment
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

ITT 370 Designing a Wireless Network Part 2.docx
BIT 415 Topic 4 DQ2.docx
ITT 370 802.11 Standards.docx
8288-questions-1-10.txt
CIS9350 Syllabus Spring 2023.docx
SYM 400 Topic 2 DQ1.docx
SYM 400 Expanding the Scope of Queries COMPLETE.docx
ITT 307 Topic 3 DQ1.docx
SYM 400 Storage Indexing and Views COMPLETE.docx
ITT 307 Installing GUI Hash Generator.docx
ITT 370 Topic 2 DQ1.docx
Database Optimization and Performance Tuning Paper COMPLETE.docx
Recommended textbooks for you
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
SEE MORE TEXTBOOKS
Recommended textbooks for you
  • Text book image
    Oracle 12c: SQL
    Computer Science
    ISBN:9781305251038
    Author:Joan Casteel
    Publisher:Cengage Learning
    Text book image
    Database Systems: Design, Implementation, & Manag...
    Computer Science
    ISBN:9781305627482
    Author:Carlos Coronel, Steven Morris
    Publisher:Cengage Learning
    Text book image
    Database Systems: Design, Implementation, & Manag...
    Computer Science
    ISBN:9781285196145
    Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
    Publisher:Cengage Learning
  • Text book image
    CMPTR
    Computer Science
    ISBN:9781337681872
    Author:PINARD
    Publisher:Cengage
    Text book image
    A Guide to SQL
    Computer Science
    ISBN:9781111527273
    Author:Philip J. Pratt
    Publisher:Course Technology Ptr
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
SEE MORE TEXTBOOKS