Algorithm for a name search [School Project]
0
I need help with making a algorithm (Pseudocode) which will search for a student from the list of students. the students details are in a database and I'm not sure how to go about this.
So far , I've come up with
BEGIN StudentSearch (KeyInput, Firstname [ ] , Surname [ ] , Mark [ ]) :
rownum = 1
IF KeyInput length = 0:
Display alphabetical order of names
OTHERWISE:
WHILE NOT EOF:
If KeyInput = FirstName
Display FirstName [i] , Surname [i] , Mark [i] in Row rownum
rownum+=1
How should I go about sorting the names based on matching characters or considering the data types and structures.
database algorithm search pseudocode
asked Nov 25 '18 at 6:46
Andrew CheaAndrew Chea
12
add a comment |
0
I need help with making a algorithm (Pseudocode) which will search for a student from the list of students. the students details are in a database and I'm not sure how to go about this.
So far , I've come up with
BEGIN StudentSearch (KeyInput, Firstname [ ] , Surname [ ] , Mark [ ]) :
rownum = 1
IF KeyInput length = 0:
Display alphabetical order of names
OTHERWISE:
WHILE NOT EOF:
If KeyInput = FirstName
Display FirstName [i] , Surname [i] , Mark [i] in Row rownum
rownum+=1
How should I go about sorting the names based on matching characters or considering the data types and structures.
database algorithm search pseudocode
asked Nov 25 '18 at 6:46
Andrew CheaAndrew Chea
12
Have you considered SQL and wildcards?
– saketk21
Nov 25 '18 at 9:02
Is this pseudocode? The code looks like pseudocode but it's not tagged with pseudocode. Edit: The lack of mcve makes it difficult to provide an accurate answer.
– TrebuchetMS
Nov 25 '18 at 9:10
@TrebuchetMS yeah It is pseudocode, sorry about that.
– Andrew Chea
Nov 25 '18 at 9:22
@saketk21 I have no knowledge of either so no. We haven't begun or will be writing the actual codes until next year. This is just the algorithm in pseudocode (sorry if it wasn't clear)
– Andrew Chea
Nov 25 '18 at 9:25
add a comment |
0
0
0
I need help with making a algorithm (Pseudocode) which will search for a student from the list of students. the students details are in a database and I'm not sure how to go about this.
So far , I've come up with
BEGIN StudentSearch (KeyInput, Firstname [ ] , Surname [ ] , Mark [ ]) :
rownum = 1
IF KeyInput length = 0:
Display alphabetical order of names
OTHERWISE:
WHILE NOT EOF:
If KeyInput = FirstName
Display FirstName [i] , Surname [i] , Mark [i] in Row rownum
rownum+=1
How should I go about sorting the names based on matching characters or considering the data types and structures.
database algorithm search pseudocode
asked Nov 25 '18 at 6:46
Andrew CheaAndrew Chea
12
I need help with making a algorithm (Pseudocode) which will search for a student from the list of students. the students details are in a database and I'm not sure how to go about this.
So far , I've come up with
BEGIN StudentSearch (KeyInput, Firstname [ ] , Surname [ ] , Mark [ ]) :
rownum = 1
IF KeyInput length = 0:
Display alphabetical order of names
OTHERWISE:
WHILE NOT EOF:
If KeyInput = FirstName
Display FirstName [i] , Surname [i] , Mark [i] in Row rownum
rownum+=1
How should I go about sorting the names based on matching characters or considering the data types and structures.
database algorithm search pseudocode
database algorithm search pseudocode
asked Nov 25 '18 at 6:46
Andrew CheaAndrew Chea
12
asked Nov 25 '18 at 6:46
Andrew CheaAndrew Chea
12
edited Nov 25 '18 at 9:21
Andrew Chea
asked Nov 25 '18 at 6:46
Andrew CheaAndrew Chea
12
asked Nov 25 '18 at 6:46
Andrew CheaAndrew Chea
12
asked Nov 25 '18 at 6:46
Andrew CheaAndrew Chea
12
12
Have you considered SQL and wildcards?
– saketk21
Nov 25 '18 at 9:02
Is this pseudocode? The code looks like pseudocode but it's not tagged with pseudocode. Edit: The lack of mcve makes it difficult to provide an accurate answer.
– TrebuchetMS
Nov 25 '18 at 9:10
@TrebuchetMS yeah It is pseudocode, sorry about that.
– Andrew Chea
Nov 25 '18 at 9:22
@saketk21 I have no knowledge of either so no. We haven't begun or will be writing the actual codes until next year. This is just the algorithm in pseudocode (sorry if it wasn't clear)
– Andrew Chea
Nov 25 '18 at 9:25
add a comment |
Have you considered SQL and wildcards?
– saketk21
Nov 25 '18 at 9:02
Is this pseudocode? The code looks like pseudocode but it's not tagged with pseudocode. Edit: The lack of mcve makes it difficult to provide an accurate answer.
– TrebuchetMS
Nov 25 '18 at 9:10
@TrebuchetMS yeah It is pseudocode, sorry about that.
– Andrew Chea
Nov 25 '18 at 9:22
@saketk21 I have no knowledge of either so no. We haven't begun or will be writing the actual codes until next year. This is just the algorithm in pseudocode (sorry if it wasn't clear)
– Andrew Chea
Nov 25 '18 at 9:25
Have you considered SQL and wildcards?
– saketk21
Nov 25 '18 at 9:02
Have you considered SQL and wildcards?
– saketk21
Nov 25 '18 at 9:02
Is this pseudocode? The code looks like pseudocode but it's not tagged with pseudocode. Edit: The lack of mcve makes it difficult to provide an accurate answer.
– TrebuchetMS
Nov 25 '18 at 9:10
Is this pseudocode? The code looks like pseudocode but it's not tagged with pseudocode. Edit: The lack of mcve makes it difficult to provide an accurate answer.
– TrebuchetMS
Nov 25 '18 at 9:10
@TrebuchetMS yeah It is pseudocode, sorry about that.
– Andrew Chea
Nov 25 '18 at 9:22
@TrebuchetMS yeah It is pseudocode, sorry about that.
– Andrew Chea
Nov 25 '18 at 9:22
@saketk21 I have no knowledge of either so no. We haven't begun or will be writing the actual codes until next year. This is just the algorithm in pseudocode (sorry if it wasn't clear)
– Andrew Chea
Nov 25 '18 at 9:25
@saketk21 I have no knowledge of either so no. We haven't begun or will be writing the actual codes until next year. This is just the algorithm in pseudocode (sorry if it wasn't clear)
– Andrew Chea
Nov 25 '18 at 9:25
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53465296%2falgorithm-for-a-name-search-school-project%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53465296%2falgorithm-for-a-name-search-school-project%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Have you considered SQL and wildcards?
– saketk21
Nov 25 '18 at 9:02
Is this pseudocode? The code looks like pseudocode but it's not tagged with pseudocode. Edit: The lack of mcve makes it difficult to provide an accurate answer.
– TrebuchetMS
Nov 25 '18 at 9:10
@TrebuchetMS yeah It is pseudocode, sorry about that.
– Andrew Chea
Nov 25 '18 at 9:22
@saketk21 I have no knowledge of either so no. We haven't begun or will be writing the actual codes until next year. This is just the algorithm in pseudocode (sorry if it wasn't clear)
– Andrew Chea
Nov 25 '18 at 9:25