Desing a database called DbEscuela Using Microsoft SQL Server

Create the following tables:

 

 

In the table identified as Students insert the following data:

 

 

Change the name of the student with account number 87654321 to Edgar Rene López González. Race 60

Insert the following races in the race table

 

Change the major 60 Bachelor of Psychology for Bachelor of Administration.

 

Delete the student with account number 11111111 from the Students table.

 

Show all items in the student table sorted by student name

 

Show all items in the Careers table, sorted by name.

 

Show the data of Students with their respective degree ordered by name of the degree

Alumnos Texto(10) NoCla Nombre Texto(80) CveCar Numerico Carreras Clave Nombre Numrico Texto(360)