State your assumptions clearly

There are various galaxies in universe which consists of various solar systems. Planets and moons belongs to solar system and occasionally there are comets which may be travelling across various systems. Draw ERD.

XYZ airways is to design the database to meet the need of its customers. Manager offers choice of three meals of each flight. These are pure veg. Non veg. and Manager's choice. Each flight meal has 3 courses inclusive a soup & Sweet dish. Each passenger while booking a ticket can indicate choice of meal otherwise manager's choice meal will be provided by default. Draw ERD and Reduce Diagram Into Tables.

Transport Company is responsible for picking up shipment from various warehouses and delivering them to their depot locations. Currently there are 6 warehouses and 40 depot locations. Company uses a fleet of 15 trucks to make schedule trips to transport the goods. Each trip consists of
1. Picking up consignments from one or more warehouse by truck.
2. Delivering them to respective depot locations.
Each truck has specific weight and volume caring capacity. Each consignment is of known weight and volume. Trip schedules are made considering these parameters. Draw ERD.

A discounting policy is as under
Two types of customers Bookstores & Librarian / individuals
For Bookstores
If order qty. is 6 or more than 6 then 25% discount
Other wise No discount.
Whereas for Librarian and Individual
If order qty. is 50 or more than 50 then 15% discount.
If between 20 to 49 then 10% discount
If between 6 to 19 then 5% discount
else no discount
Draw Decision Tree, Table, Structure English.

Prepare Questionnaire to meet following objectives also ensure that questionnaire can be easily computerized.
Daily Sakal proposes to carry out readership survey. Questions should be related to following subjects.
Popularity of various features
Age GroupWise preference of features
Income GroupWise preference
Area / locality preference of features - 8 localities
Rating of Sakal with other papers
Most Preferred price.

Company ABC has appointed no of suppliers who supply the items used in production. Orders are placed on suppliers. Each item is identified by unique code and in addition to this description, UOM is other information is recorded. Different suppliers charge different for the items. When order is placed order details remarks and details or order, which includes supplier, name, items ordered in specific quantity and negotiated rate for each item in order is recorded. The total order amount is also required to be printed on some of the reports and documents of the company. Draw ERD and File Design.

Decision Tree & Table For Passing MCM Examination

Customer applies to an insurance Company for policies that are maintained by one of the zonal offices of company. The maintenance could involve activities such as change of Name, address etc. There are 10 zonal offices of company. Customer pays his insurance premium at a fixed branch office, which reports to zonal office convenient at him. Customer may take any one of the available policy schemes while buying policy, which will decide things such as duration, insurance amount etc. Draw ERD.

The gratuity scheme applicable in a Ltd. Com. has following rules
1. The employees are divided in 2 groups workers and administration staff.
2. In case of workers the gratuity is computed as 15 days salary for each completed year of service subject to a maximum of 20 months salary.
3. In case of admn. Staff employees less than 15 years of completed service are paid at the rate of ½ months salary for each years service subject to a max. of 20 months salary.
4. The admn. Staff with 15 or more years of service is paid at the rate of 7-month salary for each year of service without any max. Limit.
Draw Decision Tree And Table.

Draw logical DFD
1. Selling customer request organization to sell various items on their behalf.
2. Buying customer make request to buy items
3. Sale is arranged with buyers if the item requested by the buyer has been previously put forward for sale by a selling customer.
4. During sale arrangement

• Invoice is prepared for buyer and record of these invoices is kept.
• A notification is send to the seller whose item was sold. The seller will now hold item.
• A commission is computed and debited to selling customer. The commission is then subtracted from the amount to be sent to selling customer and is recorded in the sales advice, which is sent to the selling customer.
  5. The sale is completed when payment is received from the buyer. A cheque is sent to the seller together with a dispatch request for items to be sent to the buyer.

Computer Society India ( CSI ) holds seminars on various subjects in different cities. The same seminar may be schedule at various places on different dates. At the same venue different seminars may be schedule on same date. Some of the members of CSI body are assign duties related to organizational activities for the scheduled seminar at every location. Booking forms are received from all over India. A unique booking number is given to every applicant. The delegates specified in the form, the seminars he wants to attend along with the date of seminar. The delegate also sends the DD as a fee towards the participation in the seminar. The date of receipt of the DD is also recorded.
Draw ERD, File Design

Draw Context & 1st level DFD
Loan accounting system of a bank. The RBI sends parameters such as loan limits, interest rates for different types of loans etc. Customer approaches bank for loans and furnish all the details. Bank scrutinizes the applications and approves or disapproves. For approved proposals new loan account is created and loan amount is debited on that account. Customer pays loan installments every month and upon such payments account is created and transaction is recorded. The interest is computed every month by scanning all transactions during that month. The computed interest is charged on that account. Whenever the customer demands the statement of accounts is given to him. The interest transaction statement is given to the manager. Statement of NEW loans sanctions is generated every year and submitted to RBI.

ABC farma. Ltd. Distributes range of pharmaceuticals in 7 regions spread over 10 states. The regions are further divided into 2/3 zones. Each zone has 10/15 sales representative. The company product range includes 35 different items for each of which sales representative wise targets for quantities to be sold at each month or established. The target is set at the beginning of quarter. The actual sales made by each representatives built up from invoices submitted by sales representatives. The company has designed to have info. System to monitor sales representative performance with respect to targets for the zones, regions and the company as whole. Variation in the aggregate and actual sales beyond 5% on either side is to be highlighted. Give details of company system to achieve above objectives.
Draw File Design, Output Formats, ERD

ABC Company is in computer h/w business. Numeric Pagers are given to its service engineers. They want to generate a unique code (Code Design) so as to inform their service engineers. In all there are 56 customers. The complaints are of three types i.e. related with computers, printers or scanners. Also call may be regular or urgent. You are requested to design a suitable 10-digit code with last 6 digits for Tel. No.

Eng. Com. has 1500 items of inventory in their stores. Items are divided in 20 categories like electrical, mechanical etc. Each category is further divided into 50 groups. Electrical divided into insulators, cables. Items run into several sizes ( 20 diameter ranges of nuts and bolts ) There are 30 departments, which are regularly using these items. Suggest Coding System for these items.

ABC Pvt. Ltd. manufactured an array of house hod products having high price range. Its sales so far have done either directly from its main outlet or through its no. of dealers located in different parts of the city. The sales manager realizes from last two years experience that some of the company products are better sold directly where as some other products the dealers are able to sale well. Hence the decisions regarding the following are to be taken. Management would like to keep some of its products exclusively at the main shop only where as other products can be sold only by the dealers. By doing this the company also feels to reduce the blocked investment by avoiding stock of all the items at all places. The management also would like to reconsider the contract with those dealers who have been performing very poorly.
Design reports layout, which would form a basis for taking the above decisions. Justify your answer in terms of the usage of the reports for taking these decisions.

An information system is to be design for keeping the record of world cup cricket matches. 12 teams. Every team has 19 members out of 15 players and 4 are non players. Age and name of each member is to be recorded where as for non players designation and for players num of ODI played is the additional information to be recorded. Matches are scheduled between teams o specific days and on specific ground. There are 12 grounds selected as venue, where each ground has fixed sitting capacity. For 41 matches scheduled 11 umpires. Two are assigned duties for each match. The performance of every match is to be recorded in terms of the runs he scored and wickets he took. DRAW ERD 4 File Design 6 Screen layout for entering performance of player in match, indicate Edit, Display fields. 3 Specify validations that should be carried out in above data entry program. 3
Write program specification for above program.

Shikha advertising agency is fast growing advertising agency in Pune. Its services include publishing advertisements in the news papers, magazines and on hoarding. It main business is in the area of hoarding which are situated at different sites all over Maharashtra. The hoarding are of different sizes and types like painted screen-printed pasted etc. The same are hired by the clients on quarterly, half yearly or yearly basis for advertising their products.
Clients make enquiries with the agency for different hoarding. The agency submits its proposal for such enquiris against which it may or many not receive an order. Individual orders are assigned to different scrip-writers and artists for further processing.
Amount of each order is received from the client in three installments
1. 20% along with the order
2. 50% after actual display
3. remaining after contract period
The agency desires to computerize its hoarding business for the following aspects.
Order processing, Bill generation, Analytical information about clients and their orders, Hoarding wise income and occupancy details, periodical comparative details.
As a system analyst design and document
Data modeling with detailed and integrated ERD
Entire file design up to 3rd NF
Complete menu tree up to last level

Hitec University has computerized its examination system which includes the procedures like :
- Receiving examination forms filled by the students from different institutes and validate them
- Sending time tables and admit cards to different institutes which are also examination centers and
- Entering marks after assessment of answer-sheets and printing mark sheets.
- Draw context and first level DFD.

Killer Instinct is a company producing pesticides for cockroaches. Company is thinking of introducing a chalk-like pesticide "Seemarakha" after analyzing the public opinion collected through a market survey made by the company. Thousands of questionnaires were collected and the findings were computerized. Information collected is as follows.
- Details about the prospective consumers.
- Present methods for controlling cockroaches
- Details of competitor's products, if used and
- Expectations from new product
Give list all routine reports which can be generated
Give layouts of any two reports along with dummy records.

Galaxy communications provide Internet connections to general public. While alloting the connection, it required following information from the applicant
- details about the applicant
- Hardware details available at the proposed site.
- Type of connection requested (Three types available)
- Proposed usage of the connection and
- Method of remitting charges.
Prepare proper Application Form to be submitted by the applicant to Galaxy Communications. Instructions for filling the forms are also to be given.

New college of engineering felicitates the fourth year students in annual social gathering for their various achievements as follows.
If the student is a best artist he will gent an award of 500/- if the student is best sportsman he will gent an award of 750/- if the student is best scholar he will get an award of 1000/-. If the student is best outgoing student he will get an award of 2000/-. A best outgoing student is one who has received at least two of the above awards and has been honored by a scholarship by any non-govt. institution. Draw Decision Table

Maharashtra sport and recreation department has decided to hold different kinds of national sports competition in Pune. It has decided to computerize all the activities, events, results etc. etc. that are going to take place in national sports meet.
The requirements are as follows
Maintain data of the participants, representing different states and taking part in different type of sports competitions. There is a team of at the most 7 players representing every state.
To maintain the records of performance of the participants in various league rounds.
To maintain the result of the sports events such as who won Gold, Silver, and Bronze medals.
To maintain Umpires data and their specialization in various events.
To maintain complaints received from participants.
A ready information base of world records is also to be made available for comparison purpose. As a system analyst you are required to study above case and design
1. Data modeling with ERD
2. Table design with data types and sizes
3. Design screen layout for Data entry of Application form submitted by the state.

"Shri Ball Pens " is a manufacturing Co. of various varieties of Ball Pens. The company has decided to computerize their Purchase order system. Following procedure is followed in the company.
After receiving the purchase requisition for store department, enquiries are made to various suppliers. The suppliers send quotations to the company. All quotations are analyzed and final selection of suppliers is made and accordingly purchase orders to respective suppliers are send. The suppliers send invoice along with the raw material.
The requirements of the company are as follows :
Maintain supplier, raw material, quotation, P.O. Database
Generate quotation analysis report.
Generate purchase order, pending order details.
Generate various MIS reports such as item wise, supplier wise reports.
Draw Context and First Level Diagram

Design the layout of salary slip for the employees of "ABC and Co. Ltd." The salary slip should contain all relevant information about the employee, leave particulars, All earnings and deductions and also the date of the payment of the salary.

University wants to computerize MCM Examination system. It is necessary to maintain the database of marks obtained by each candidate. You are required to Design Data Entry Screen for data creation of marks (Internal & External) by considering usual validity checks. Justify screen design.

"Shri Laxmi Co-Op Bank" has following rate of interest structure for its fixed deposits.
For cumulative scheme of 1,2 and 3 years interest rated are 10,11 and 13 percent per annum respectively. Interest rates for non-cumulative scheme are 8,9,11 percent per annum respectively. For any pre-mature closure, interest rate which is 1% less than the actual is to be charged for the months completed - Draw decision table.

Video Cassette Library system, design significant digit Coding Structure for cassette which should give following information to user.
Language Type of Movie Location of the cassette
Justify the coding structure from the point of view of typical queries and access.

Design a suitable Data Entry Screen for entering the information about all the "Ganeshotstav Mandals" in the city. Also suggest data validations & controls necessary.

Swiftair Operates an air line service connecting important towns in the state of Gujrat. If plies two types of aircraft and has three classes. Executive, Business, and economy with different fare structure and facilities.
Ticket bookings are computerized and done through agents or directly on phone or in person at the company's booking offices. Bookings can be preponed, postponed or cancelled. Only cancellations under the last one-hour before the flight are charged at 40% of the ticket value and no show or loss of ticket results in forfeiture of entire ticket amount. Other changes are not charged.
Customers are offered a choice of veg and non-veg. Meals in flight. The customers are allowed to carry one piece or hand baggage and checked in baggage of permitted weight. Excess baggage is charged separately. The full ticket amount is to be paid at the time of issue of the ticket by cash, cheque or a credit card. Credit is given for 15 days to accredited agents.
The airline management needs analytical information for taking business decisions. Draw a functional decomposition diagram.

"Smart and Co" are a firm of practicing chartered accountants. They handle mainly income tax matters, carry out statutory and tax audits and prepare project reports for clients. The clients are spread over the western Maharashtra and comprise of different types of entities like companies, firms trusts, individuals etc. each having different activities and work requirements.
Mr. Smart wants to computerize and prepare a database of all the clients to enable him to develop better strategy to focus his professional activity, to improve productivity and ensure timeliness.
Design a suitable proforma to be filled by each client for development of a database.

Following are the three data structures available in a computerize system of a Personnel inventory. Give Data Dictionary for the following data structures assuming important attributes.
- Employee Master
- Department Master
- Language Master

ShowTime Network provides cable TV channel services. There are approx. 2000 customers currently on the record of the company. Company charges Rs. 1000/- as deposit and Rs. 500/- as installation charges to a new customer. Customer has to pay RS. 150/- as monthly charges.
In fact first week of every month, 5 employees of the company go to different customers to collect the monthly charges for the previous month. A receipt is given after payment. At the same time, the employees enquire with the customers about the complaints, if any. Also customers are requested to give names of all those movies which they would like to see in the next month. Accordingly, a schedule is prepared. Two movies are shown per day.
The customers willing to remove the cable connection temporarily or permanently have to inform the company one-month in advance. The deposit amount is returned back to the customer in case of permanent removal.
Reminders are sent to all those customers who haven't paid the charges for consecutive three months.
ERD 8, File Layouts 8, Any three reports 10

"Romit engineers" has decided to computerize their financial accounting which includes the following procedure.

• Recording payment, receipt sales, purchase, deposits, withdrawals, sales return, purchase return and other transactions online.
• Update the account balances immediately
• Print daybooks, ledgers, and trial balance at the end of the month
  Draw FDD

"Sitanagar Municipal Corporation" has decided to computerize data regarding all the cinema theatres in the city. Theatre managers are requested to fill the form giving detailed information about the respective theatre. Design a layout of a form to be filed by the manager.

Design the layout of a final bill given to the patient by "Ashwini Hospital" at the time of discharge. It should contain all relevant information about the patient, disease, test done, treatment and services rendered by the hospital.

Normalize the entry form up to 3NF filled by customer at reception while getting a room in the hotel.

Pizza hut established in 1996, delivers various types of pizzas on order to the customers of Mumbai, home delivery of pizzas is managed through the delivery boys.
Procedure followed is :
Customer places order by phone or in person
Reception clerk fills the order form in duplicate, one is given to kitchen manager and other is retained as office copy
Kitchen manager prepares KOT in triplicate sending two to kitchen and third to accounts department.
Kitchen prepares the pizza, sends it to reception along with signed copy of KOT
Accounts department prepares the bill in duplicate, sending one to reception and other is retained as on office copy.
Delivery boy delivers the Pizza and bill to customers.
Customers pay the bill after receiving pizza.
Delivery boy submits cash to accounts at the end of the day
The jut wants to generate MIS for pizza type wise sales, orders handled by delivery boys, customer details etc.
Draw ERD and CLD

Design a complete Menu Tree for a payroll system of an educational Institute.

New marketing agency is responsible for conducting the marketing surveys in India. A television manufacturing company has assigned a responsibility to the agency, of conducting a survey for collecting the performance of different televisions in the market. It also wants to assess the present features and drawbacks of different televisions.
The survey is to be conducted in all metro cities. Some questionnaires are also to be collected through postal mail.
As a systems analyst, you are required to Design the Questionnaire for survey and instructions for filling the questionnaire.

Chai cyber café provides the facility of Internet surfing on hourly basis. It also offers membership on discounted rates to regular surfers. Design a proper application form for these memberships so as to give all necessary details of these surfers to the Café. The Café plans to use such collected data for business promotion purposes.

Global computer Institute admits the students by following the procedure given below
A student having more than or equal to 60% of marks in graduation exam is accepted for special batches, students having marks between 45 to 60% marks are accepted for Regular batches and remaining students are rejected.
20% additional fees are taken from students who opt for prime time batches. 5% discount is given to students, if the fees are paid on or before 15th august.