create database instituto

create table Alumnos ( IdAlumno int identity, Nombre varchar (20), Apellidos varchar (20), DNI varchar (20), Dirección varchar (20), Distrito varchar (20), Email varchar (20), Telefono varchar (20), FechaNac datetime ) create table profesores ( Idprofesor int identity, Nombre varchar (20), Apellidos varchar (20), DNI varchar (20), profecion varchar (29), Dirección varchar (20), Distrito varchar (20), Email varchar (20), Telefono varchar (20), FechaNac datetime ) create table cursos ( IdCurso int identity, Curso varchar (20), IdProfesor int, Fechainicio datetime , Fechafin datetime , Horainicio datetime , Horafin datetime , Incidencias varchar (100)) create table evaluaciones ( IdAlumno int identity, IdCurso varchar (20), NotaFinal varchar (20), Observaciones varchar (20),)

Upload: ronald-torres

Post on 08-Apr-2016

4 views

Category:

Documents

0 download

Report

Download

Embed Size (px):

TRANSCRIPT

create table profesores(Idprofesor int identity,Nombre varchar (20),Apellidos varchar (20),DNI varchar (20),profecion varchar (29),Dirección varchar (20),Distrito varchar (20),Email varchar (20),Telefono varchar (20),FechaNac datetime )

create table cursos(IdCurso int identity,Curso varchar (20),IdProfesor int,Fechainicio datetime ,Fechafin datetime ,Horainicio datetime ,Horafin datetime ,Incidencias varchar (100))

create table evaluaciones(IdAlumno int identity,IdCurso varchar (20),NotaFinal varchar (20),Observaciones varchar (20),)

Create Single Instance Standby Database for RAC Database

Create Database Tables - Quia...Create Database Tables 39 CREATING A DATABASE In Access 2013, the process of creating a new database is easier than ever. You can create a data-base

Create Database Oracle Database (1)

OBJECTIVES Understand relational databases Explore a database Create a database Create a table Create primary keys Relate two tables Enter

Create your first Access 2013 database

Create a Duplicate ORACLE Database on Windows

Database Management. Database Management Systems A database management system (DBMS), or database program, is software that allows you to create, access,

OPEN SOURCE LABthe database system. DDL : Data Definition Language (DDL) statements are used to define the database structure or schema. CREATE - to create objects in the database

Create Access 2007 Database

Create Schema For Database Postgres

sql Tutorial - Tsql.info - Transact-SQL · SQL Tutorial Select Join Create database Avg Distinct Inner Join Create table Count ... 1 100 A 20 B 3 600 C 40 D Create Table Create Database