Click here to Skip to main content
15,943,082 members
Home / Discussions / Database
   

Database

 
QuestionI need advice on storing application level encrypted data. Pin
Gilbert Consellado5-Jun-17 18:26
professionalGilbert Consellado5-Jun-17 18:26 
SuggestionRe: I need advice on storing application level encrypted data. Pin
Kornfeld Eliyahu Peter5-Jun-17 20:50
professionalKornfeld Eliyahu Peter5-Jun-17 20:50 
QuestionHow do I write the insert sql statement for the following scenario ? Pin
karengsh3-Jun-17 22:30
karengsh3-Jun-17 22:30 
AnswerRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes4-Jun-17 13:49
professionalMycroft Holmes4-Jun-17 13:49 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh4-Jun-17 20:41
karengsh4-Jun-17 20:41 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes4-Jun-17 20:58
professionalMycroft Holmes4-Jun-17 20:58 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh4-Jun-17 22:12
karengsh4-Jun-17 22:12 
OK. Tks.

Can I know if the ammended database schema is correct ?

SQL
Create table tutor(
id integer, auto_increment;
tutorName varchar(50), not null,
tutorNRIC varchar(50), not null, (Primary Key)
tutorEmail varchar(50), not null,
);


SQL
Create table subject(
id integer, auto_increment;
subject varchar950), not null;
subject_id, integer, not null, (Primary Key)
_;


SQL
Create table tutor_subject(
tutorNRIC integer,
subject_id integer,
Primary Key(tutorNRIC, subject_id),
Foreign Key(tutorNRIC) references tutor(tutorNRIC),
Foreign Key(subject_id) references subject(subject_id));

GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes5-Jun-17 12:05
professionalMycroft Holmes5-Jun-17 12:05 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh10-Jun-17 19:12
karengsh10-Jun-17 19:12 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes10-Jun-17 20:45
professionalMycroft Holmes10-Jun-17 20:45 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh11-Jun-17 17:38
karengsh11-Jun-17 17:38 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes11-Jun-17 23:39
professionalMycroft Holmes11-Jun-17 23:39 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh14-Jun-17 18:55
karengsh14-Jun-17 18:55 
Questionwhy we use datareader Pin
Mazahir Habib1-Jun-17 20:10
Mazahir Habib1-Jun-17 20:10 
AnswerRe: why we use datareader Pin
John C Rayan1-Jun-17 22:16
professionalJohn C Rayan1-Jun-17 22:16 
GeneralRe: why we use datareader Pin
Mycroft Holmes1-Jun-17 22:25
professionalMycroft Holmes1-Jun-17 22:25 
Questionattempt to load oracle client libraries threw badimageformatexception ssis Pin
indian1431-Jun-17 13:59
indian1431-Jun-17 13:59 
AnswerRe: attempt to load oracle client libraries threw badimageformatexception ssis Pin
Richard Deeming2-Jun-17 1:18
mveRichard Deeming2-Jun-17 1:18 
QuestionLoading Data on Demand Pin
Richard Andrew x6431-May-17 11:02
professionalRichard Andrew x6431-May-17 11:02 
AnswerRe: Loading Data on Demand Pin
Richard Deeming31-May-17 11:44
mveRichard Deeming31-May-17 11:44 
GeneralRe: Loading Data on Demand Pin
Richard Andrew x6431-May-17 13:05
professionalRichard Andrew x6431-May-17 13:05 
AnswerRe: Loading Data on Demand Pin
Mycroft Holmes31-May-17 13:01
professionalMycroft Holmes31-May-17 13:01 
GeneralRe: Loading Data on Demand Pin
Richard Andrew x6431-May-17 13:07
professionalRichard Andrew x6431-May-17 13:07 
GeneralRe: Loading Data on Demand Pin
Mycroft Holmes31-May-17 13:21
professionalMycroft Holmes31-May-17 13:21 
GeneralRe: Loading Data on Demand Pin
Richard Andrew x6431-May-17 13:28
professionalRichard Andrew x6431-May-17 13:28 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.