Search & Filtering
You have recently graduated from college and are hired as an administrative assistant at a local bicycle repair shop. Your manager asks you to create an inventory list of the bicycle parts sold in the shop. He thinks he might be losing money because he is charging too little for his parts. He wants to be able to compare his shop's prices with the prices of the nearest bike shop.
a) What software could you use to compile an inventory list to keep track of bicycle parts, your prices, quantity, and the competition's price efficiently?
A multinational company opens multiple branches all over that Pakistan. If you are hired to design the networking from the company, what type of network you will select? What type of network topology will be suitable for the linking different branches or different department inside the single company branch? List down the network equipment you may require during this implementation.
A multinational company opens multiple branches all over that Pakistan. If you are hired to design the networking from the company, what type of network you will select? What type of network topology will be suitable for the linking different branches or different department inside the single company branch? List down the network equipment you may require during this implementation.
Q no. 1 30 Marks
A new movie theater has opened in your town and the owner needs a system that facilitates the
Reservation of seats in the cinema’s auditorium. Design a windows application Form that
Facilitates the reservation of tickets for this Movie Theater.
Design and connect the following database using LINQ or Entity Framework for the given
scenario.
Database:
Movie (id (PK), name, description )
ScheduleMovie (id (PK), movieID (FK), time, price)
Seat (id (PK), number, rownumber, columnnumber)
Reservation (id (PK), scheduledMovie(FK), seatnum(FK), customerId(FK), haspaidTicket)
Customer (id (PK), email, name)
The user of this application is a cinema staff, for example the admin and the Cashier.
The Admin Panel
The admin registers the cashiers and also, add new movies when released.
The panel has various menus named Add, Remove, and detail
Add menu has sub menu named AddMovie, and AddCashier. Remove menu has sub menu
named removeMovie and removeCashier.
Click event raised on the click of AddMovie which displays a new form for the movie entry
that includes name, ticket price, timing, and total seats.
Make session gets out after every 10 minutes. (Timer component)
The Cashier Panel
First screen shows the Movie Image that is available in Movie Theater. (Use Picture Box)
Click event raised on the click of Movie Image that display new form for customer
registration.
The Cashier registers the customer for the seat. The program assigns the first vacant seat
number counted from the seat at the most rear part of the auditorium i.e. the last chair.
Requirements
The GUI must include textboxes for input, labels for read only information such as
headings and also output. In addition a listbox must also be used.
The values entered by the user in the textboxes must be validated when the user clicks the
Reserve/Cancel button.
The value entered in the name textbox should at least contain one character that is not a
blank, otherwise a message box is to be shown to the user with appropriate error (use
regex).
The value entered in the price textbox most be a valid double value greater or equal to 0 (0
for free tickets) (use regex).
Test the application with a total number of seats = 240. The program should keep track of
the number of vacant seats.
Every time the user clicks the Reserve/Cancel button, and if the radio button Reserve is
checked, increase the number of vacant seats by one. Also accumulate the price of each
reserved seat to show in the revenue output label, i.e. revenue = Sum of prices.
When the user selects the Cancel Reservation option, the TextBoxes are to be disabled.
Even the Reserve/Cancel button is to be disabled as cancel function will not be
implemented in this version.
Use Error provider to show errors to the user.
Use the Customer and the Movie class to maintain the records.
Design database and perform the crud operations where necessary.
Generate day to day Crystal Report for the on-screen shows your report should also contain
number of sold tickets.
Q no. 2 10 Marks
Design a suite like MS office using WPF. Your application must include at least two application
like word or excel or PowerPoint, or OneNote.
Question [40 Marks]
Owner of the largest used car selling business in Karachi who deal in almost every type of four-wheel vehicles, Mr Khan wants you to build a desktop application for the selling of used cars online. Until now all of the work was being done offline which includes the users’ data records and the bidding of the cars.
His team has spent quite a time in outlining the requirements so that they can hire a Visual Programmer to develop the desktop application.
The requirements are as follows:
• User registration panel
o The user details must be submitted using the web service approach in terms of implementation.
• User login panel
o The user must login using the web service approach in terms of implementation.
• User Profile
o User Id
o Full Name of the user
o Phone number of the user
o Email Address
o User’s Uploaded Car Details
▪ Pictures
▪ Colour
▪ Model
▪ Transmission
▪ Engine Capacity
▪ Starting Price
o User can add new a car to the existing records.
o User can update existing car(s).
o User can delete previous car(s).
• Home Screen to see other cars uploaded by users. Cars belong to some owner where one owner may own more than one car but one car can be owned by only one owner.
Page 3 of 3
o The user can bid to the cars shown on this screen if they show available status (keep track of the foreign key(s)).
o They can view the initial selling price on the car.
o They can contact owner via owner’s number outside the scope of the application.
• The user with the highest bid wins when the owner changes the available status to sold status.
o The message is displayed on the profile of the bidder.
o The report can be generated of the overall bids by the user (showing how many bids were successful and also the failed ones along with their details) by a user from Generate Report Button on his Profile.
• You are required to build the desktop application with smart and intuitive User Interface. The designing of the application is not specific and you are given the free will to make a few changes of your own given your experience.
• For all types of data objects, create suitable model classes or abstract classes wherever necessary.
Solution Marking Criteria:
Functionality
Marks
User Registration & Login
8
Windows Forms (User Interface)
5
Delegates
3
Database
4
Entity Framework & LINQ
7
Exception Handling
2
Reporting
5
Web Service
6
Given a string s containing just the characters '(', ')', '{', '}', '[' and ']', determine if the input string is valid.
An input string is valid if:
Open brackets must be closed by the same type of brackets.
Open brackets must be closed in the correct order.
Example 1:
Input: s = "()"
Output: true
Example 2:
Input: s = "()[]{}"
Output: true
Example 3:
Input: s = "(]"
Output: false
Example 4:
Input: s = "([)]"
Output: false
Example 5:
Input: s = "{[]}"
Output: true
*Your program output should follow the example in the instruction.
* The program should print the input parentheses and the output (true/false).
*Parentheses.txt : ((()))
You are required to follow this program template I provide and use stack to solve the problem. Please test the program.
#include <stdio.h>
#include <stdlib.h>
// This is where the parentheses are stored in memory
char buffer[1024];
char stack_pop();
void stack_push(char ch);
int stack_size();
int main(){
FILE *fp;
// The parentheses sequences is in the parentheses.txt file.
fp=fopen("parentheses.txt","r");
if(fp==NULL){
printf("The input file does not exist.\n");
exit(-1);
}
// Read the parenthese sequences into buffer array.
fgets(buffer,1024,fp);
//printf("%s",buffer);
}
// The pop operation in the stack. To be done.
char stack_pop(){
return ')';
}
// The push operation in the stack. To be done.
void stack_push(char ch){
}
// The number of elements in the stack. To be done.
int stack_size(){
return 0;
}
A small manufacturing company is expanding by its business by opening multiple branches across the country. Currently all the database is managed by individual employees on Microsoft Excel or sometimes using Microsoft Access. The company is considering updating to a central database management system comprising of several modules for maintaining their manufacturing, inventory, employees and accounting requirements. You are hired to develop a feasibility report as the first phase of the SDLC cycle including the recommendations on economic, operational, technical aspects of the on-going project
A small manufacturing company is expanding by its business by opening multiple branches across the country. Currently all the database is managed by individual employees on Microsoft Excel or sometimes using Microsoft Access. The company is considering updating to a central database management system comprising of several modules for maintaining their manufacturing, inventory, employees and accounting requirements. You are hired to develop a feasibility report as the first phase of the SDLC cycle including the recommendations on economic, operational, technical aspects of the on-going project.
create a GUI tool for Cyclomatic complexity using any language
