Hola jessica, perdon por responder tarde......se me paso una coma de mas en la primera tabla y en la segunda me falto definir como primary key el campo idemp, quedaria asi:
Código PHP:
CREATE TABLE IF NOT EXISTS Doctores (
key_cedula int(11) NOT NULL PRIMARY KEY,
doctorNOMBRE varchar(50) NOT NULL default '',
doctorAPELLIDO varchar(10) NOT NULL default '',
doctorNUMERO int(8) NOT NULL default '0',
doctorGRADO varchar(2) NOT NULL default '',
login varchar(10) not null unique,
password varchar(8) not null
) ENGINE=INNODB ;
CREATE TABLE IF NOT EXISTS Notas (
idemp int(11) NOT NULL auto_increment,
key_cedula int(11) NOT NULL ,
notaUNO varchar(2) NOT NULL default '',
notaDOS varchar(2) NOT NULL default '',
notaTRES varchar(5) NOT NULL default '',
notaCUATRO varchar(2) NOT NULL default '',
notaCINCO varchar(2) NOT NULL default '',
notaSEIS varchar(2) NOT NULL default '',
notaSIETE varchar(2) NOT NULL default '',
notaOCHO varchar(2) NOT NULL default '',
notaNUEVE varchar(10) NOT NULL default '',
notaDIEZ varchar(2) NOT NULL default '',
primary key(idemp),
INDEX (key_cedula),
FOREIGN KEY (key_cedula)
REFERENCES Doctores(key_cedula)
ON UPDATE CASCADE ON DELETE CASCADE
)ENGINE=INNODB ;
Para puedas ver si tienes activado el motor INNODB usa el comando : show variables like '%inno%';
asi en la consola de MySQL
Código:
mysql>show variables like '%inno%';
+---------------------------------+------------------------+
| Variable_name | Value |
+---------------------------------+------------------------+
| have_innodb | YES |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_checksums | ON |
| innodb_commit_concurrency | 0 |
| innodb_concurrency_tickets | 500 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_doublewrite | ON |
| innodb_fast_shutdown | 1 |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_log_arch_dir | |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | ./ |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_rollback_on_timeout | OFF |
| innodb_support_xa | ON |
| innodb_sync_spin_loops | 20 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| innodb_thread_sleep_delay | 10000 |
+---------------------------------+------------------------+
where have_innodb | YES | quiere decir que tienes activado el motor innodb y tus tablas puedes relacionarlas..
En espera de avances...
Saludos