Friday, April 9, 2010

Cases in MIS

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...

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


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