Few important things regarding MIS case study
1. there is no particular solution of the cases.
2. the person who is solving the case must have to consider himself / herself as a part of the management.
As, if u solving a case of hospital management consider yourself in the hospital management or in the administrative part.
basically there are 3 things to be solved in the case study
1. Normalised file layout
2. Input Screen/ layout
3. Output Screen or report.
0 level DFD, 1st level DFD, Flowcharts, ERD are rarely asked now a days
Important tips:
1. Please solve normalised file layout with proper Datatype (Date, Number, Charecter, etc), size and also give proper remark with the concept of primary key , foreign key, use of numbers, charecters etc.
2. Input Screen / layout- you can say new account opening in yahoo/ rediff. or profile editing in Orkut / facebook. or railway reservation website.
3. Output layout/ reports like exam score card, attendance record, salary and payment, class wise students records, etc...
INPUT LAYOUT
An input layout deals with
- Text Box
- Dropdown Box
- Memo Box
- Check Box
- Radio Buttons
And three specific buttons
SUBMIT, RESET & CANCEL
Prof. A. R. Sayyed
1. there is no particular solution of the cases.
2. the person who is solving the case must have to consider himself / herself as a part of the management.
As, if u solving a case of hospital management consider yourself in the hospital management or in the administrative part.
basically there are 3 things to be solved in the case study
1. Normalised file layout
2. Input Screen/ layout
3. Output Screen or report.
0 level DFD, 1st level DFD, Flowcharts, ERD are rarely asked now a days
Important tips:
1. Please solve normalised file layout with proper Datatype (Date, Number, Charecter, etc), size and also give proper remark with the concept of primary key , foreign key, use of numbers, charecters etc.
2. Input Screen / layout- you can say new account opening in yahoo/ rediff. or profile editing in Orkut / facebook. or railway reservation website.
3. Output layout/ reports like exam score card, attendance record, salary and payment, class wise students records, etc...
NORMALISED FILE LAYOUT:
We will solve the NFL/ Database Layout with one example….
If we want to make a layout of a Company,
We have to consider different ENTITIES to be covered under it.
Like__
- Employees
- Logistics
- Production
- Branches
- Account Dept.
- Bank. Etc.
Then you have to prepare normalized file layouts for the above mentioned entities
There is a particular format of preparing a NFL
Sr no. Particular Datatype Size Remark
Particular includes all the attributes of the entity
Eg. For Employee---
The attributes are__
- Employee_id
- Employee_name
- Employee_DOB
- Employee_Gender
- Employee_Address
- Employee_Phone
- Employee_designation
- Employee_salary
Etc…etc…
ID is a unique number by which you are going to identify the table, so just note that you have to take ID in every table..
Eg. If Employee table.. then Employee_ID, if Account Table then Account_ID, etc…
Name the ID as a primary key in Remark
DATATYPE includes
- Character : any alphabet, number, symbol, space, etc
- Number
- Date : It doesn’t have size
- Time : It doesn’t have size
- Memo : if the size of character table is more than 150 you have to use memo.
SIZE: deals with the length. One has to mention the maximum limit of the size in database
Eg. If you take the word AKHTAR ALI as an example the size is 10. we must have to include space as a character.
REMARK : remark deals with the specification of the datatype
Eg. If you take only ‘alphabets & space’ as a remark, it shows invalid syntax for any thing else. You can also give a format for date and time in the remark
THERE IS A PARTICULAR FORMAT OF NFL WHICH WE HAVE TO FOLLOW
We will solve the NFL/ Database Layout with one example….
If we want to make a layout of a Company,
We have to consider different ENTITIES to be covered under it.
Like__
- Employees
- Logistics
- Production
- Branches
- Account Dept.
- Bank. Etc.
Then you have to prepare normalized file layouts for the above mentioned entities
There is a particular format of preparing a NFL
Sr no. Particular Datatype Size Remark
Particular includes all the attributes of the entity
Eg. For Employee---
The attributes are__
- Employee_id
- Employee_name
- Employee_DOB
- Employee_Gender
- Employee_Address
- Employee_Phone
- Employee_designation
- Employee_salary
Etc…etc…
ID is a unique number by which you are going to identify the table, so just note that you have to take ID in every table..
Eg. If Employee table.. then Employee_ID, if Account Table then Account_ID, etc…
Name the ID as a primary key in Remark
DATATYPE includes
- Character : any alphabet, number, symbol, space, etc
- Number
- Date : It doesn’t have size
- Time : It doesn’t have size
- Memo : if the size of character table is more than 150 you have to use memo.
SIZE: deals with the length. One has to mention the maximum limit of the size in database
Eg. If you take the word AKHTAR ALI as an example the size is 10. we must have to include space as a character.
REMARK : remark deals with the specification of the datatype
Eg. If you take only ‘alphabets & space’ as a remark, it shows invalid syntax for any thing else. You can also give a format for date and time in the remark
THERE IS A PARTICULAR FORMAT OF NFL WHICH WE HAVE TO FOLLOW
INPUT LAYOUT
An input layout deals with
- Text Box
- Dropdown Box
- Memo Box
- Check Box
- Radio Buttons
And three specific buttons
SUBMIT, RESET & CANCEL
OUTPUT LAYOUT
examples:
Prof. A. R. Sayyed
