Sunday, May 31, 2009
1. Development of physical Database design.
2. Understanding of DDL and DML SQL commands.
3. Understanding of mapping of logical design to physical design.
4. Functions in SQL
1. You are required to read roles & responsibilities of each entity mentioned in previous CS403_spring2009_module2.
2. You are allowed to consult the online material
3. Do not copy and paste other wise your case shall be submitted to unfair means committee. Copy and pasted material from any source will be awarded zero marks.
4. Please use a 12-point font in Times New Roman or Arial.
5. The Assignment includes Lecture # 21 to Lecture #31.
6. Last date for the Submission of the assignment is June 5, 2009.
7. Upload your assignment in .doc format (NOT in .docx & database file) and within due date and time. No assignment will be accepted after the due date and time.
8. You can use MS SQL server (any version) as DBMS software for execution of Queries and functions.
Consider the following few relations of Academic systems.
1. Semester (SemNo, Sem_Dur, Start_Date, End_Date)
2. Professor (VUPid, P_Name, Age, Deptid, CourseCode)
3. Prof_Exp(VUPid, Experience)
4. Department (Deptid, D_Name, Main_Office, HOD)
5. Project (Pid, Title, Start_Date, Due_Date, Prj_Instructor)
6. CoursePre-Req(CourseCode, Pre-requisite)
7. Course (CourseCode, C_Name, Prg_Code)
8. Student (VUSid, Std_Name, Std_Age, Prg_Code, )
9. Program (Prg_Code, Prg_Name, No_of_Sem)
10. ProgramDur (Prg_Code , Max_Dur)
Write down the QUERIES for the following given situations.
a. Create a new data base. Name it VUDBMS.
b. Create Tables with attributes and name them accordingly.
c. Insert data in related Tables (program, student, professor, degree).
***. Show one command for single entry in each relation.
d. List the names, ages, Department Name of professors, working in a different department.
e. List the professor Names, Total Experience and Group by professor Names.( using aggregate functions)
f. List the program code, program Name, Max. Duration from relations named Program. ( using aggregate functions)
g. List Department Name, Address and HOD Name.
h. List student ID, Student Name, student age where student ages are between 18 and 25 and sort by age field in ascending order.
i. Alter student relation by adding column Address.
j. List project title, start date and project instructor where project due date is greater then today date and sort result by start date field in Ascending order (using aggregate function getdate())
Hint (for b):
Specify the column data type. System or user-defined data types are acceptable. User-defined data types are created with sp_addtype before they can be used in a table definition. The NULL/NOT NULL assignment for a user-defined data type can be overridden during the CREATE TABLE statement. However, the length specification cannot be changed; you cannot specify a length for a user-defined data type in a CREATE TABLE statement.
Copy form previous Module:
Following are the roles and responsibilities of each of the given entities.
A. Withdrawal from course (s): A student shall not be allowed to add a new course, or substitute a course for another after the expiry of ten days from the commencement of the semester.
B. No student will take any course unless he/she has cleared the pre-requisite for it as determined by the University.
C. Professors can teach the same course in several semesters in different programs. Like CS201 is offering in 1st and 2nd semesters of Master and BS programs respectively.
D. Every professor must teach some courses.
E. Every professor teaches exactly one course (no more, no less), and every course must be taught by some professor.
F. Now suppose that certain courses can be taught by a team of professors jointly(MTH603 by Dr. Junaid Zaidi & Dr. Atta-ullah-khan), but it is possible that no one professor in a team can teach the course. Model this situation, introducing additional entity sets and relationship sets if necessary.
G. Professors have an Vupid, a name, an age, a rank, experiences and a research specialty.
H. Graduate students have an Vusid , a name, an age, and a degree program (e.g., M.S. or BS honors, etc).
I. Student can enroll in the same course in several semesters, and only the most recent such offering needs to be recorded. ( mostly incase of grade improvement)
J. Graduate students have one major department in which they are working on their degree.
K. Course projects have a project number, project title, a starting date, a Due date.
L. Each project is managed by one professor (known as the project instructor).
M. Each project is worked on by one or more professors (known as the project's Co-instructors).
N. Professors can manage and/or work on multiple projects.
O. Each project is worked on by one or more graduate students
P. Departments have a department number (deptid) , a department name, Contact no. and a main office
Q. Departments have a professor (known as the HOD **) who runs the department.
For better understanding about roles & responsibilities of course, program, semester entities you can visit: http://www.vu.edu.pk/pages/statutes.aspx
1. There are two semesters* in each academic year, Fall and Spring, of 18 weeks each.
2. VU is offering following programs.
2-yr Bachelors Programs
Certificate Courses MS
3. VU has following Academic departments:
Computer Science Department
Kindly do follow the blog and the solution is coming soon.
* “Semester” means teaching time of 18 weeks inclusive of admission, conduct of examination, preparation and declaration of result etc. and gazetted holidays
**. HOD stands for Head of Department.
Here is the solution in the form of Picture do it by your self adding the commands to SQL.Follow these pics one by one
Assignment # 4 Kindly send email to VUHELPS for the urgent reply.
Friday, May 29, 2009
Optical Fiber: Optical fiber is made of glass or plastic.It transmits signals in the form of light
The Nature of Light
The speed of light
–300,000 Km/sec in a vacuum
–Depends on the density of the medium through which it is traveling
–The higher the density, the slower the speed
Refraction:Light travels in a straight line as long as it is moving through a single uniform structure If a ray of light traveling through one substance enters another (more or less dense) substance, its speed changes abruptly causing the ray to change direction.This phenomenon is called Refraction Example of Refraction
A pencil sticking out of a glass of water appears bent because the light by which we see it changes direction as it moves from air to water.
Direction of Refraction Direction in which a light is refracted depends upon the density of a medium
A beam of light moves from a less dense into a more dense medium bend towards vertical axis
Incident angle is ‘I’ and Refracted angle is ‘R’
o We have a beam of light moving from a more dense to a less dense medium
o We gradually increase the angle of incidence measured from vertical axis
o As angle of incidence increases, so does the angle of refraction
o The angle at which refracted line lies on the horizontal axis is called
o When angle of incidence becomes greater than critical angle, reflection occurs
o Light no longer passes into the less denser medium but is reflected back into the same medium
o The Angle of Incidence (I) = Angle of Reflection (R)
Optical Fibers & Reflection :
o Optical fibers use Reflection to guide light through a channel
o A glass or plastic CORE is surrounded by a CLADDING of less dense glass or plastic
o The difference in the density of CORE and CLADDING is such that the beam of light moving through the core is reflected off the cladding
o Information is encoded onto a beam of light as a series of ON-OFF flashes that represent 1 and 0 bits
This is the assignment kindly follow the blog and You got the solution.
Your assignment must be uploaded/submitted at or before June 05, 2009.
Wednesday, May 27, 2009
Assignment # 04
Total Marks 20
Your assignment must be uploaded / submitted before or on 01-06-2009.
Please view the assignment submission process document provided to you by the Virtual University to upload the assignment.
Rules for Marking
Please note that your assignment will not be graded if:
• It is submitted after due date
• The file you uploaded does not open
• The file you uploaded is copied from some one else or from internet
• It is in some format other than .html file
The assignment has been designed to enable you to:
• Use HTML forms
Question 20 marks
1. Use HTML form, with one text box and a button as shown below:
2. Text box is to enter the number and when you press the “Have a Table” button a table of entered number should be shown.
3. Use loop to print the table
4. Output should be as shown below (if 5 is entered):
Here is some idea of the table programe. You should do some changes. It works you simply have to copy paste this code to notepad and then save as table.html and preview in internet explorer hope it will work fine. Also kindly join the blog by pressing the follow button.
See this image its the output of the assignment
The Coding you should write in Notepad and save as HTML is
Monday, May 25, 2009
Why should you be concerned about planning your career?
Because it is your career. If you don’t take responsibility for the success of your career, then who will? Besides, considering all the time and energy you spend at work, why not ensure you get maximum satisfaction from your work and career.
Additionally, GSFC benefits from having a competent and motivated workforce, capable of “re-tooling” itself to meet the demands placed on it by constant organizational and technological changes within NASA and GSFC.
The workplace has been affected by a number of significant changes or trends, which have definite ramifications for your career planning.
• Less job security and employer loyalty. Gone is the era of high job security, with the same employer for life, where good employees automatically move up well-defined career ladders. Even in the Federal sector, in response to increased pressures to reduce costs, solutions like restructuring, down-sizing and automation will continue to eliminate some jobs and drastically alter others. Workers will, of necessity, need to be more mobile in finding the right job--and employer.
• Up is not the only way. With the thinning of management positions and flattening of organizational structures, the traditional linear career patterns will be less available. Employees will need to be more flexible, adaptable and creative in identifying their next job, and may need to consider lateral moves or rotational assignments to broaden their experience or leverage their skills.
• Technical knowledge and skills obsolescence. Rapid advancements in technology and state-of-the-art knowledge requires employees to upgrade their skills and “re-tool” themselves just to remain current with their job requirements. For example, in high-tech organizations like Hewlett-Packard, the skills of some engineers have a half-life of 18 months! Also, missions and projects end and new ones start up, often requiring new or different technical skills or expertise from the workforce.
It is definitely to your advantage to position yourself for long-term employability in the rapidly changing world of work. Begin preparing now for the future, for it will be here before you know it.
Types of Careers
There are some major differences between the university environment and the industrial/laboratory one:
• Industrial jobs give you access to state-of-the-art equipment and give you influence over the next generation of equipment.
• Unless you really enjoy teaching, you are doing yourself and the students a disservice if you take an academic job.
• Industry gives you opportunities for profit sharing and entrepreneurship.
There are many varieties of nonacademic jobs:
A consulting job can provide flexible hours, a variety of work experience, and a chance to be your own boss. A consultant sells his/her services on a short or long term basis to an organization that needs a particular set of skills. The successful consultant must be flexible, work well under tight deadlines, be a good salesperson for his/her expertise, and tolerate risk well.
A government lab usually focusses on a particular set of research problems, related to the agency's mission - defense, energy, etc. Laboratories can provide good interdisciplinary opportunities, job security, and a healthy research environment.
Some organizations engage in classified research - particularly, some Department of Defense labs, National Security Agency, and Department of Energy labs. At installations such as this, some percentage of your time might be spent in research that cannot be made public. This work is important and interesting, but will do nothing to enhance your prospects for a move to a non-classified installation. If job mobility is important to you, then it is vital that you keep a high public profile as well, continuing to do research that can be published openly, and continuing to attend conferences in your research area.
Private industry hires people who can contribute in some way to the company's ``bottom line" of profits. Different companies evaluate the contribution in different ways. At one end of the spectrum are companies who operate labs like IBM Yorktown, Xerox Parc, or Bell Labs, where management has believed that a relatively unfettered research environment will lead to unexpected advances, some of which will generate new commercial products. Although people are encouraged to become involved in some less speculative work, a major part of their time can be spent in work much like that of universities. At the other end of the spectrum are companies that focus on short-term, product-specific tasks that lead to research questions whose answers will have immediate impact.
Again, an important consideration is how openly you will be allowed to talk about your work. Some companies do classified research, and others protect their research and their products as trade secrets or by copyright or patent.
What Is Industrial Life Like?
In an medium or large size organization, your first tasks will probably involve close team work with a more experienced colleague with similar background. You may participate in a project that is well underway, making a specific contribution to software, mathematical formulation, or modeling. Or you may be brought into a beginning project that you will help to shape and then make a fairly well-defined contribution. Evaluation of your work will include the quality of your contribution, your attention to deadlines, your ability to work harmoniously with others, and your oral and written communication skills.
After you have some experience, you may be asked to work more independently, perhaps serving as the sole person on a project with your particular specialty. For instance, Margaret Wright of Bell Labs speaks of a project that involved studying radio signal propagation in a building. The team involved one engineer, expert in radio signal modeling, two mathematicians, expert in numerical optimization, and one computer scientist, expert in graph algorithms. An important ingredient in such projects is mutual respect among the team members so that they can trust that the pieces of the project that they only vaguely understand are being handled well. Team members must contribute responsibly and be wise enough to ask help from people outside the team when they are unsure of themselves.
Further on, you may be asked to lead a team or perhaps direct a research division. This requires a whole new set of skills and you should be prepared for some retraining to meet a new set of challenges.
How Should You Prepare for an Industrial Career?
There are several things you can do (beginning in your first year of graduate study!) that will make the prospects of success in an industrial environment more likely. Check the list under the chapter about preparation for an academic career - all of that advice applies here. In addition, work experience is invaluable. Look for opportunities to work in industry for a summer or a semester. Look for industrial workshops that will give you a chance to work on applied problems for an intensive session, preferably in a multi-disciplinary environment.
Obtain some breadth of background. In interacting with engineers or biologists or physical scientists, it is invaluable to know the vocabulary and to be able to understand the underlying principles. Broaden your areas of expertise through course work or seminar attendance.
How Do You Find a Job?
Industrial and government positions tend to work on a shorter time scale than academic ones. It might take several months to have the paperwork progress through the system, be called for an interview, but (at least for unclassified work) the time between interview, offer, and starting data is often quite short.
As in finding an academic job, consult your advisor and other faculty members, and use any contacts you have to inquire about positions
• Choose as references faculty members who know your work well. Also try to include people who have supervised your work or industrial contacts who find your research useful. Talk to them about your goals and provide them with a transcript, dissertation summary, and resume. Ask for advice on whom to contact.
• Your resume should give your educational background, awards, publications, conference presentations, and a list of 3-5 references with addresses. You should list an objective; e.g., ``a research position that applies skills in x, y, and z to w." If you have practical experience of any kind, highlight it on the resume.
• Your cover letter can be brief, but express some enthusiasm, make a clear statement of your research accomplishments and research goals, and mention your advisor's name. Also provide a one page research summary.
• Apply to every company you are particularly interested in, even if it is not currently advertising. Sometimes positions become available unexpectedly, and an interesting application can trigger a position.
• Watch technical publications (SIAM News, Communications of the ACM, IEEE Computer, etc.) for ads. Contact your university's career center. Attend job fairs. Use Internet resources of job listings, maintained by the professional societies and others. Consider contacting a ``head hunter," an employment agency that circulates your resume to interested companies, charging the company a fee if you are hired.
How do you go about planning your career?
The diagram below illustrates the steps involved in the career planning process.
Step 1: Knowledge of Work Environment
1. How is the mission of my organization (i. e., section, branch, division or lab) changing? What other changes are occurring regarding our customers, services/products, work processes, organizational structure, reporting relationships and personnel? Is this a change of which I want to be a part? Or is it time for me to consider a move?
2. What are the organization’s changing needs regarding the workforce and what new expertise and skills will be required or desirable?
3. What opportunities are available for developing these new expertise and skills (experiences, training, brief exposure, professional conferences, mentoring, etc.)?
4. How might my role (job) change in my organization? How can I prepare for or develop new skills for these changes?
5. New expertise and skills my organization wants me to learn include...
6. What new missions or projects at Organization or within work place appeal to me? What are their needs for the future? What kinds of development activities would help position me for participation in another project?
Step 2: Knowledge of Self
1. Of the new and recent developments in my organization or field, what interests me the most?
2. What are my current strengths for pursuing these interests? What do I need to do to reposition my career so that I can get involved in these new developments?
3. Is it time for me to consider working outside of organization? If I am considering a complete career change, what experiences and learning would help reposition my career in the direction of my new interests?
4. Of all the things I have done in the last five years (work and non-work related), what specific activities and functions have energized me the most? What developmental activities--experiences, learning, skill building--would help me grow in or increase these energizing functions?
5. Other things I would like to learn are...
6. What non-work related issues do I need to consider as they might affect my career plans (e.g., health, family, financial, social)?
Step 3: Integration of Knowledge of Self and Work Environment
1. In what areas do my interests and personal plans overlap with the changing needs of my organization? [Any areas of overlap represent “first choice” development targets.]
2. What knowledge’s, skills or abilities are important for increasing or maintaining the quality of my performance in my present assignments? [Lack of attention to these development needs will surely affect my opportunities at GSFC.]
3. What knowledge’s, skills or abilities would help prepare me for opportunities or roles I might have in the future?
4. Compared to the developmental needs suggested by these factors, other interests for development that are important to me include...
Step 4: Goal Development
A goal is a statement of a desired outcome or accomplishment which is specific, observable and realistic. Based on the data you have generated about yourself on the previous worksheets and your specific career issues, write some goals for the next one, two and three years.
1. What I want to accomplish by this time next year is...
2. What I want to accomplish by the end of the second year is...
3. What I want to accomplish by the end of the third year is...
4. What barriers or obstacles might prevent me from accomplishing my goals on time (e. g., time, money, other commitments, etc.)?
5. What can I do to overcome these barriers or obstacles? What resources are available to help me?
Step 5: Method for Taking Action
1. There is a wide range of potential actions for me to consider in order to achieve my goals:
• New assignments in my current job -- Rotation to a different project/job
• Volunteer for a task force or process action team
• On-the-job learning from someone who is more expert in a specific area
• Seminars/conferences (on-site)
• Seminars/conferences (off-site)
• University courses
• Commercial/contracted courses
• Self-paced learning (books, videos, computer-based instruction, etc.)
• Academic degree or certification program
• Sabbatical leave
• Conduct informational interviews
• Move to a new job outside of the Federal Government
• Start my own business
2. In planning my career moves, I must be open to consider all the possibilities. “Up” is not the only way (i. e., moving from a technical/professional position into management). I must be willing to consider these moves:
Lateral Move: Change in position within or outside an organization, but not necessarily a change in status or pay. Job Enrichment: Expand or change my job in order to provide growth experiences for myself. Exploration: Identify other jobs that require skills I have and also tap my interests and values. Job rotation is an example. Downshifting: Taking an assignment or job at a lower level of responsibility, rank, and/or salary in order to reposition my career in something new and interesting to me, or to achieve a better balance between work and personal life. Change work setting: Keep my job duties pretty much the same, but have a different boss, organization or employer. No change: Do nothing, but only after careful consideration.
Your Individual Development Plan (IDP)
To the extent that any of your career goals involve acquiring some new skills or expertise, an Individual Development Plan (IDP) will be very helpful. Using the attached IDP form (MS Word Doc), begin drafting your plan by incorporating the goals you formulated on the “Goal Development WORKSHEET” and the relevent actions from the “Method for Taking Action WORKSHEET”. In selecting actions, try to achieve a balance between formal training activities (e. g., courses, seminars) and other kinds of learning experiences (e. g., work assignments, books). Also, include realistic timeframes for completing your actions.
Your Supervisor’s Role
Your supervisor is in an excellent position to support your development in several ways. He or she can:
• Give you feedback on your performance in your current job and identify your strengths and areas for improvement.
• Act as a mentor and coach for you.
• Represent the organization’s needs, goals and opportunities.
• Let you know what is happening around organization.
• Help assess your advancement potential and your qualifications for other positions.
• Act as a resource and referral for exploring your options.
• Support your training and development with time for training and funding.
Realistically, your supervisor may not be able to support you very much if your goals are to leave organization and work elsewhere. However, the more closely your goals are linked to those of organization, the more valuable a resource your supervisor can be in your career planning.
enlightened companies recognize the importance of rewarding senior researchers who do not choose (or have no aptitude for) management. A good manager understands the concerns of the researchers he/she manages and acts as buffer and advocate. A good manager is a filter, suppressing the ``noise'' from higher level management while keeping the unit informed of important news. At the same time, a good manager presents the unit's case for resources and keeps higher management aware of the unit's accomplishments and value
Saturday, May 23, 2009
Assignment # 03
Total Marks: 15
To assess students’ knowledge about business communication and ability to write an effective report according to the given situation
1. Late assignments will not be accepted.
2. If the file does not run properly, it will be marked zero.
3. Plagiarism will never be tolerated. Plagiarism occurs when a student uses work done by someone else as if it was his or her own.
4. If any assignment is found copied work, no marks will be awarded and the case may be referred to the academics for disciplinary action.
5. No assignment will be accepted through e-mail.
6. The font color should be preferably black and font size should be 12 Times New Roman.
7. Assignment should be uploaded as Word Document file.
Q1: You are a sales representative in Shine Mobiles, your General Manager wants to introduce a new package featuring Free Call to at least one number. You are supposed to write a Feasibility Report keeping in mind that how it would be different from other network packages. 10
Q2: Choose the correct option: 5
1. How can you target your audience?
a. By identifying your audience type
b. Level of expertise your audience
c. Audiences’ attitude towards you and the content of document
d. All of the above
2. Why Comparison is useful for paragraph development?
a. It emphasizes similarities
b. It emphasizes differences
c. It emphasizes advantages
d. Both a & b
3. If your message is specific, definite and vivid; you are applying which of the following principle?
4. To whom usually good will letters are written?
5. AIDA plan stands for:
a. Attention, Interest, Desire, Action
b. Authority, Interest, Disclose, Accuracy
c. Accuracy, Internal, Diction, Attention
d. Action, Interest, Desire, Authority
For Solutions kindly click on fallow and join it you will get the solution.
Assignment No. 03
CS201: Introduction to Programming
Total Marks: 20
Please read the following instructions carefully before submitting assignment:
It should be clear that your assignment will not get any credit if:
§ The assignment is submitted after due date.
§ The submitted assignment does not open or file is corrupt.
§ All types of plagiarism are strictly prohibited.
Note: You have to upload only .cpp file. Assignment in any other format (extension) will not be accepted. If you will submit code in .doc (Word document) you will get zero marks.
The objective of this assignment is to provide hands on experience of using
§ Memory Allocation in C/C++
§ Array in C/C++
§ Code should be properly aligned and well commented.
§ Follow c/c++ rules while writing variables names, function names etc
§ Use only dev-C++ for this assignment.
Dynamic memory allocation/reallocation of an Integer array.
Write a program in which you have to:
1. Dynamically allocate an array of integers.
2. Take array size as input from user and allocate memory according to this size.
3. Take values of array elements as an input from user.
4. Print all array values.
5. In this step; double the previous array size (taken in step 2) and reallocate memory for the array according to new array size. For example if user provided array size is 4; now it will become 8, i.e. allocate memory for array having size 8.
6. Now again take values for second half of the array as an input from the user to fill the increased size of an array.(You have already taken the values of first half of the array elements in step 3, now take values for remaining elements i.e. Second half).
7. Print all values of the array.
8. Also confirm that first half values of array are same in both printout statements (step 3 and step 7).
Program to dynamically Allocates an array of integers.
Enter the size of the array: 4
Enter a value: 1
Enter a value: 2
Enter a value: 3
Enter a value: 4
The elements of the array are:
1 2 3 4
Enter the elements in the array after reallocation:
Enter a value: 5
Enter a value: 6
Enter a value: 7
Enter a value: 8
1 2 3 4 5 6 7 8
Your assignment must be uploaded/submitted on or before
Dear fellows, If you want the solution kindly join this blog by followers then get the required solution.
Dear fellows, If you want the solution kindly join this blog by followers then get the required solution.
Saturday, May 9, 2009
Performing this lab you will able to get the benefit that are mentioned up.
Step 1: First click on start button and press run then type “control” press ok. It will open control panel.
Thursday, May 7, 2009
Its very useful way to access folders faster which are inherent or you try to hide them or they are in tee structure they way I am going to tell you it will definitely help you to access them easily and in one sec with a short string enter in the run command.
You may go to this folder just by a short sting . First have to configure it. Right click on my computer go click on properties.
Then entering the both name click ok and ok and in last click on ok.