Description
i have a database table containing:
SEG,AMK,101427Y,EG3902,EG3902-G1
SEG,AMK,101427Y,EGS650,EGS650-G1
SEG,AMK,103852S,EG3901,EG3901-G1
SEG,AMK,103852S,EG3904,EG3904-G1
SEG,AMK,103852S,EGS104,EGS104-G1
SEG,AMK,103852S,EGS650,EGS650-G1
SEG,AMK,106581C,EG3901,EG3901-G1
SEG,AMK,106581C,EG3902,EG3902-G1
SEG,AMK,111713M,EG3901,EG3901-G1
SEG,AMK,111713M,EG3902,EG3902-G1
column names are: SCHOOL, CAMPUS, ADMINNO, MODULECODE, MODULEGROUP
another table, paperslist containing:
1 SEG-AMK EG1832 abc 286 1.5 EG1832
2 SEG-AMK EG1833 def 375 1.5 EG1833 EG1952 EG1903
3 SEG-AMK EG1835.1 ghi (1) 456 1.5 EG1835 EG1001
4 SEG-AMK EG1835.2 ghi (2) 363 1.5 EG1907 EG1681 EG1951
column name: s/n(paperNo), school, paperID, papertitle, no.ofstudents, duration, modulecodes, modulecode2, modulecode3
2 SEG-AMK EG1833 def 375 1.5 EG1833 EG1952 EG1903
3 SEG-AMK EG1835.1 ghi (1) 456 1.5 EG1835 EG1001
4 SEG-AMK EG1835.2 ghi (2) 363 1.5 EG1907 EG1681 EG1951
column name: s/n(paperNo), school, paperID, papertitle, no.ofstudents, duration, modulecodes, modulecode2, modulecode3
Student modulecodes
111411H eG1001 eg1002
s/n papertitle modulecodes
3 abc eG1001 eg1009
4 xyz eg1002
then there is common student between paper 3 & 4 such that later the exam time table scheduler knows that he can't schedule these 2 papers on the same time, as it will clash. I need to get the output of:
3 abc eG1001 eg1009
4 xyz eg1002
then there is common student between paper 3 & 4 such that later the exam time table scheduler knows that he can't schedule these 2 papers on the same time, as it will clash. I need to get the output of:
Conflictivepaper no.ofstudents adminno
Paper1 : paper2 2 111411H, 11380y
Paper1 : paper2 2 111411H, 11380y
displaying in multi line textbox or dgv
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Thank you for the opportunity to help you with your question!
In most cases, the discipline is self-governed by the entities which require the programming, and sometimes very strict environments are defined
Studypool
4.7
Indeed
4.5
Sitejabber
4.4
Similar Content
Virtual Private Database Lab
This is a six step lab. The attachments are the instructions to the lab and I will need to send you a compressed folder wh...
Java using notepad ++
file will be attached below, add comments to it ...
Austin College Data Exploration Using Python Decision Tree Worksheet
FRED Graph Observations
Federal Reserve Economic Data
Link: https://fred.stlouisfed.org
Help: https://fredhelp.stlouisfed....
Python Art and Literature Who Painted Starry Night Question
The most difficult part of this assignment are the technical aspects of making the quiz work. To start on the techni...
SEU Implementing a Simple Mobile Application Project
...
Reducing Bullying in Childhood Website Project
Final project: Students are required to produce a digital final project for this course. Topic: (a) Identify ways to r...
