Levels Tought:
Elementary,Middle School,High School,College,University,PHD
Teaching Since: | Jul 2017 |
Last Sign in: | 213 Weeks Ago, 1 Day Ago |
Questions Answered: | 15833 |
Tutorials Posted: | 15827 |
MBA,PHD, Juris Doctor
Strayer,Devery,Harvard University
Mar-1995 - Mar-2002
Manager Planning
WalMart
Mar-2001 - Feb-2009
need help with question 4, 5 6 codes not working in SQL
ISM 218- Database Systems Assignment#10
Questions1-3areworth3pointseachandshouldbeansweredin3-5sentences.
Â
Â
Â
1.What is an index? How is used in adatabase? Which type of column would make an ideal index?
Â
2.Can an index be created in anytable? Whywouldyou NOT want to createan index in a table?
Â
3.What is a sequence? Whyare sequences used?What are some issues that occur when usingsequences?
Â
Â
Questions4-7areworth4pointseach.
Â
Â
4.Write the codeto createa new tableas shown below and createan indexon the Project_Namecolumn.
Â
Â
Table Name:Manager
Â
ColumnName: |
ManagerID |
Manager_Name |
Project_ID |
Project_Name |
KeyType: |
PrimaryKey |
 |
 |
 |
Null/Unique: |
Not Null |
 |
Not Null |
Not Null |
FKTable: |
 |
 |
 |
 |
FKColumn: |
 |
 |
 |
 |
DataType: |
INTEGER |
VARCHAR |
INTEGER |
VARCHAR |
MaxLength: |
7 |
30 |
7 |
30 |
Â
Â
5.Write the codeto createan indexon the Project_IDcolumn of the Manager table.
Â
6.Write the codeto removethe indexon the Project_Namecolumn of the Manager table.
Â
7.Write the codeto createa new tableas shown below and createasequenceon the Patient_ID column.
Â
Table Name:Patient
Â
ColumnName: |
Patient_ID |
P_Name |
 |
 |
KeyType: |
PrimaryKey |
 |
 |
 |
Null/Unique: |
Not Null, Unique |
NOT NULL |
 |
 |
FKTable: |
 |
 |
 |
 |
FKColumn: |
 |
 |
 |
 |
DataType: |
INTEGER |
VARCHAR |
 |
 |
MaxLength: |
7 |
30 |
 |
 |
Â
----------- Â ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly