Dynamic Top Menu Positioning

create database bdmatricula;

use bdmatricula;

drop table if exists nota;

drop table if exists matricula;

drop table if exists alumno;

drop table if exists curso;

drop table if exists profesor;

drop table if exists titulos;

#creacion de tablas

create table alumno(

coda smallint(4) unsigned not null primary key auto_increment,

noma varchar(20),

apea varchar(30),

unique i_nomape(noma,apea)

);

create table curso(

codc smallint(4) unsigned not null primary key auto_increment,

nomc varchar(30) unique,

credito tinyint unsigned

);

create table profesor(

codp smallint(4) unsigned not null primary key auto_increment,

nomp varchar(20),

apep varchar(30),

titulo varchar(20),

unique i_verifp(nomp,apep)

);

create table matricula(

coda smallint(4) unsigned not null,

codc smallint(4) unsigned not null,

codp smallint(4) unsigned not null,

dia varchar(20),

hora time,

unique i_verif(coda,codc)

);

create table nota(

coda smallint(4) unsigned not null ,

codc smallint(4) unsigned not null ,

pr1 tinyint unsigned,

pr2 tinyint unsigned,

efinal tinyint unsigned,

unique i_verfifN(coda,codc)

);

create table titulos(

nom varchar(30) not null primary key

);

#Visualizar estructura de las tablas

#describe alumno;

#describe curso;

#describe nota;

#describe profesor;

#describe matricula;

show tables;

insert into titulos values ('Administrador'),('Abogado'),('Ing. Sistemas'),('Ing. Industrial'),('Ing. Economico'),('Ing.

...