Mar 12
11
is actually GSM?
GSM delivers built in voicemail, high-speed info, send, paging and small sales message products and services functions. GSM clients take pleasure in protected marketing communications, and also GSM offers remarkable call solitude plus deception avoidance. Since folks the actual GSM World wide Network, GSM buyers will use their own mobile phones in your house, across town, over the country, or maybe around the world (with the exception of with place certain Sim card greeting cards). GSM runs using the numerous spectrum frequency artists used around the globe — 1900MHZ, utilized throughout Canada and america and also 900MHz plus 1800 Megahertz pertaining to areas. Various cellular phone cpa affiliate networks perform during various frequencies, which means if you want to make use of phone at an office country, people typically desire a mobile phone that will can handle several rate of recurrence groups. Make sure that the cellular phone you would like to try works with this GSM gang of the country you will use this around.
A new dual-band cell phone runs in the two Nine hundred Megahertz and also 1800 Megahertz range. Dual-band functions with The eu, Africa, Most of asia, Australia, Nz and much regarding The philipines. Any tri-band cellphone runs using some consistency bands, Nine hundred Megahertz, 1800 MHz plus 1900 Megahertz, permitting you to work with it around European countries, Cameras, Japan, nearly all of North America, New zealand and australia. Your quad-band telephone lets you roam pretty much just about anywhere worldwide. The item includes the particular Eight hundred fifty Megahertz, 900 Megahertz, 1800 Megahertz plus Nineteen hundred Megahertz consistency ranges. A lot of nations within The philipines simply have 850 Megahertz GSM program when both Nineteen hundred Megahertz along with Eight hundred fifty MHz GSM providers are usually supported in america. 99% off nations around the world makes use of the GSM standard. We know gradually GSM may be the exclusively mobile normal in the world.Just what is a SIM card?
The actual Simulator (Prospective subscriber Identity Module or even Reader Identification Element) credit card ( space ) any.e.some sort of. “smart card” ( blank ) maintains most of the subscriber’s private information and make contact with options. In essence, this is the subscriber’s authorization make use of the actual multi-level. Additionally, it supports the contact number, individual stability crucial along with files required for the actual device to work. The credit card may be flipped coming from mobile phone to cellular phone, permitting the revolutionary phone obtain every call towards the subscriber’s number.
How do Simulator charge cards function?
The actual Simulator can be interior each and every mobile phone handset and procedures because its digital brain. The particular verification plus encryption abilities of the Sim card prevent your mobile phone by being stolen and also your telephone calls via staying eavesdropped in. This SIM’s electronic digital storage, which usually suppliers info much like your charge prepare, number and service options, additionally allows you to simply individualize your merchandise and has now consumer Username in addition to billing details which might be turned between unique phones. So, using your SIM card mounted, you could make or perhaps collect telephone calls privately regardless if you have some sort of lent cellphone. Upgrading a person’s cellular phone is as simple as falling ones SIM card within the new cell phone.
Get yourself a Prepaid sim greeting cards and find out the way they perform
When pre-pay and also “pay just like you go” cellphone services have been 1st unveiled within The european countries, in the end with 1996, Eu Mobile phone transmission only agreed to be under 6%. It has due to the fact risen over 74%. Not a soul arguments the enormous side of the bargain which will “contract free”, “commitment free” pay as you go cell services make to the increase. The truth that through 64% of most mobile phone customers with The european union now are attached to pre-pay ideas, is actually a concrete demonstration of prepay cellular phone impression. Prepaid mobile support allows you to to live hooked up without the month to month, contractual obligations therefore making it possible for far more overall flexibility regarding while you will make use of a person’s phone. Furthermore, it avoids over use therefore is far more “worry free” than monthly subscription service. When 64% of most Euro cellular phone consumers have wanted pre-paid cellular company, it’s specifically convenient for visitors checking out individuals market segments.
Summation
Pre-paid SIMs commence with a monetary sense of balance on the accounts. As you make calls, the fees tend to be deducted through the credit score offered using the per-minute costs. Premiums will vary depending on the carrier’s plans, no matter whether regional, to some area cellular phone, or maybe global. The particular premiums will be added with the particular SIM card product packaging. Within virtually all European plus Western places, inbound calling are free.
Whenever your contact credit score becomes reduced, you actually go to virtually any comfort keep or perhaps paper endure and acquire a bit scuff off chit from your similar company because the Sim card inside your phone. Enter the magic formula program code in the voucher in the mobile phone’s intelligent top-up method, as well as voucher’s consumer credit is usually added to your account. It’s really an absolutely free telephone to check your balance and to combine credit. It really is including getting gas as part of your automobile and another lots of people all around subsequently planet perform each day. If you can not wish to quit usually, get a significant denomination credit card, maybe a 50-Euro.
If you are interested in Telecoms in general and SIM technology in particular, visit
http://www.freesimscard.co.uk/free-o2-sim-card/
Posted in GSM by .
We first need to know what Android phones are before we start to discuss the qualities of the best Android phone. The term Android describes an operating technique developed by Google android Inc. (after bought around by Yahoo and google), which is an open source program. This means anyone can create software, and make the product highly tailored to suit individual needs. Other phones just like iPhone permit you to create applications, but they do not allow you change the core program, which is probable with an Google android phone. Which means you can change cell phones or the supplier, and still have the particular menus you want.
Apps are available at a minimal cost reely, and they can be downloaded from the Android Market on to the mobile. All Android os phones possess a touch screen program; however, there are models with keypads as well. The initial best Google android phone had been HTC G1, along with was accessible through T-Mobile company. This mobile phone had a touchscreen technology and a total keyboard.
Android os System
The primary components of Android operating system are usually Applications, Application Framework, Libraries, Android Playback, and Linux Kernel. An Android os developer can make apps utilizing Java, and earn use of the Google android SDK, which provides the mandatory APIs and resources. The Android operating system has developed after a while, and there are different versions obtainable. However, it is quite easy to up grade to a new version.
Android 3.Zero Phones
To be able to compete with iOS, Google developed Android mobile phone 3.0, and it had been awaited excitedly to become your OS variation for the best Android os phone. However, this OS was intended for tablets, and it would be challenging to implement with a small cell phone. HTC Chart was anticipated having Android Three.0, yet due to specific difficulties faced because of a smaller sized screen when compared with a product, Android Only two.3 Gingerbread Computer itself was used as an alternative. Later the HTC Experience also utilized Gingerbread, but had a planned improve for v4.a.
4G Android Phones
With the progression of 4G technology, Race became the first US service provider to apply this technology. The 1st 4G, best Google android phone had been HTC EVO 4G, and yes it still gives a stiff competitors to after models. The best 4G Android telephones currently available would be the HTC Thunderbolt and also HTC Inspire 4G. Thunderbolt is the initial 4G device pertaining to Verizone carrier, possesses a 1 GHz processor, Some.3 inches screen along with 768MB of RAM. It runs Android 2.2 together with HTC Perception. Inspire on the other hand is the first 4G set for AT&T, having 1GHz processor associated with Snapdragon, and the very same display dimensions and Memory as the Thunderbolt.
Top 5 Google android Phones pertaining to 2012
The last year was dominated by dual central technology, nevertheless 2012 considers quad core because hottest object in mobiles. The best android mobile phone phone up to now has been your HTC One particular X, that has NVIDIA Tegra 3 using four cores, clocking a new processor speed of 1.5GHz. They have 1GB RAM as well as a screen size of four years old.7 in . that has a High-definition resolution associated with 720p. It operates Android 4.0 ICS.
The other four telephones to look out for are Motorola Droid Razr Maxx, Panasonic Xperia S, Samsung Galaxy S3, as well as Meizu MX that will be unveiled in May well.
The best Android os phone is dependent upon many factors and person needs; nonetheless, the above discussions can help you get the one best suited for you.
Posted in Androids by .
Mar 12
11
MCSE-004
Click here to download complete solution of MCSE-004
Course Code : MCSE-004
Course Title : Numerical and Statistical Computing
Assignment Number : MCA(5)/E004/Assign/2012
Maximum Marks : 100
Weightage : 25%
Last Date of Submission : 30th April, 2012
This assignment has four questions in all and carries 80 marks. The rest of the 20 marks are for viva-voice. Answer all the questions. You may use illustrations and diagrams to enhance the explanations. Please go through the guidelines regarding assignments given in the Programme Guide for the format of presentation.
Question 1:
a) Write short notes on:
i) Jacobi iterative method to solve linear equations
ii) Gauss- seidel method to solve linear equations
iii) Absolute and Relative Error
iv) Eular Method for solving differential equations
v) Ranga-Kutta Method for solving differential equations
b) Calculate the value of integral I = by h=0.5
i) By Simpson 3/8 rule
ii) By Weddle’s rule
iii) By Simpson 1/3 rule
iv) By Trapezoidal rule
c) Compute the integral by applying Gaussa Quadrature formula.
Question 2:
(a) Write a program in C to find a root of a given equation using Secant Method. Perform five iterations to obtain the smallest positive root of the equation f(x) = sin x + 2tanx. Verify your answer with the program written by you.
(b) Write a short note on Secant method, Regula Falsi method and the Newton Raphson method and further discuss their relative advantages and disadvantages. Determine the efficiency or the order of these three methods?
Question 3:
a) Are the following matrices diagonally dominant?
b) Solve the following systems using the Gauss elimination method
(i) 2x + 8 y+2 z = -10 x + y + 6 = -12 6 x – 2y +2z = -18
Question 4:
a) Find the interpolating polynomial that fits this data given in the following table given below.
x : 0 1 2 3 f(x) : 2 7 14 32
b) Find the two lines of regression from the following data:
Age of Brother: 2 5, 22, 28, 26,35,20,22, 40, 20, 18. Age of Sister : 18, 15, 20, 17, 22, 14, 16, 27,75, 14.
Hence estimate
(i) The age of Brother when the age of his sister is 19,and
(ii) The age of sister when the age of her brother is 30.
Question 5:
(i) What is utility of residual plots? What are its disadvantages of residual plots?
(ii) Consider the following density function
60 x3 (1-x) 2 if 0<=x <=1 f(x) = 0 Otherwise
Generate random derivatives from f(x) by using Acceptance Rejection Method. (5 Marks)
(iii) The number of people who visit India Gate during week is normally distributed with a mean of 20,000 and a standard deviation of 600. Consider the probability that fewer than 12000 people visit in a week.
Mar 12
11
MCSL-054
Click here to download complete solution of MCSL-054
Course Code : MCSL-054
Course Title : Laboratory Course
Assignment Number : MCA(5)/L054/Assign/2011
Maximum Marks : 100
Weightage : 25%
Last Date of Submission : 30th April, 2011 (For January Session)
This assignment has two parts A (Advanced Internet Technologies) and B (Computer Graphics & Multimedia) and each part is for 20 marks. Answer all the questions. Lab record for all the respective sessions (given in the MCSL-054 Lab Manual) for each course carries 20 Marks each. Rest 20 marks are for viva voce. Please go through the guidelines regarding assignments given in the MCA Programme Guide for the format of presentation. Made assumptions if any while solving the problems and state them clearly.
PART-I: Lab for MCS-051 (Advanced Internet Technologies)
Question 1: Write a Servlet program for session tracking using cookies. (3 Marks)
Question 2:
Write a JSP Program, which displays a web page containing two web links one for showing details of your Study Centre and other for FAQs on Practicls in MCA Programme . When one click on link Study Centre it goes to a page which shows all the details of study centre and counselling schedule for MCA students .Clicking on link for FAQs on Practicls in MCA ,another JSP page consisting of some FAQ related to different practical courses in MCA, will open.
(5 Marks)
Question 3:
Write a program using JSP and JDBC to provide details of MCA/BCA/CIT study centres in your regional centre of IGNOU. This program should provide the list of students in different semesters of MCA/BCA/CIT.
(8 Marks)
Question 4: Create an XML document for keeping books records in a Library. (4 Marks)
PART-II: Lab for MCS-053 (Computer Graphics and Multimedia)
Question 1:
Write a program in C/C++ using OpenGL to draw a circle of red colour inside of a
rectangle of blue colour on a background of green colour.
(3 Marks)
Question 2:
Write a program in C or C++ to implement Scan-Line Polygon Filling Algorithm. (5 Marks)
Question 3:
Write a program in C/C++ using OpenGL to draw a hard wire diagram as shown in
figure given below. Use basic primitives of openGL. (5 Marks)
120
40
40 120
Question 4:
Write a program in C/C++ using OpenGL to perform a 3-Dimensional transformation,
such as translation ,rotation and reflection, on a given triangle.
(3 Marks)
Question 5:
Write a program in C/C++ to implement Cohen-Sutherland line clipping algorithm. In this
implementation consider two cases of a line: totally visible, totally invisible, against the rectangular clipping window.
(4 Marks)
Mar 12
11
MCSE-011
Click here to download complete solution of MCSE-011
Course Code : MCSE-011
Course Title : Parallel Computing
Assignment Number : MCA(5)/E011/Assign/2012
Maximum Marks : 100
Weightage : 25%
Last Dates for Submission : 30th April,2012 (For January Session)
There are ten questions in this assignment. Answer all questions. 20 Marks are for viva-voce. You may use illustrations and diagrams to enhance explanations. Please go through the guidelines regarding assignments given in the Programme Guide for the format of presentation.
Question 1:
(a) What do you understand by Bernstein conditions? Find out Bernstein condition in the following example.
A = B x C
C = D + E
C = A + B
E = F – D
H= l + J
(b) What are the differences between Control flow and Data flow architecture?
Question 2:
Explain the following terms:
(i) Matrix Multiplication
ii) Grid computing
(iii) Cluster Computing
(iv) Message Passing Interface (MPI)
(v) Multitasking
Question 3:
(a) List various visualizations tools employed in performance analysis.
(b) Briefly discuss the following laws to measure the speed-up performance:
Question 4: Explain the following terms related with interconnection network:
a) Node degree
b) Static and dynamic connection network
c) Bisection Bandwidth
d) Topology
Question 5: Explain how parallelism is based on grain size.
Question 6:
a) What are the differences between Control flow and Data flow architecture?
b) Define and discuss instruction and data streams.
Question 7:
(a) Write a shared memory program for parallel systems, to add elements of an array using two processors.
(b) Write a program for PVM (Parallel Virtual Machine), to give a listing of the “slave” or spawned program.
Question 8:
(a) Explain the following basic concepts :
(b) Explain the concepts of multithreading and its uses in parallel computer architecture.
Question 9:
Define Hyper Threading Technology with its features and functionality
Question 10:
(a) Draw a Clos network for
(b) Explain INTEL ARCHITECTURE-64(IA-64) architecture in detail.
Mar 12
11
MCSE-003
Click here to download complete solution of MCSE-003
Course Code : MCSE-003
Course Title : Artificial Intelligence and Knowledge Management
Assignment Number : MCA(5)/E003/Assign/2012
Maximum Marks : 100
Weight age : 25%
Last Date of Submission : 30th April,2012 (For January Session)
This assignment has ten questions and carries 80 marks. The rest of the 20 marks are for viva-voce. Answer all the questions. You may use illustrations and diagrams to enhance the explanations. Please go through the guidelines regarding assignments given in the Programme Guide for the format of presentation.
Question 1:How does the use of heuristics reduce the search space ?
Suggest a god heuristic function for travelling salesman problem.
Question 2: Write short notes on the following :
(i) Knowledge manipulation
(ii) Associative networks
(iii) Fuzzy matching algorithms
(iv) Conceptual Dependency Graph
Question 3:Discuss state space representation for the following well-known problems:
(i) Travelling Salesman Problem
(ii) Water-Jug Problem
(iii) Human Cannibal River-Crossing Problem.
Question 4:Represent the following situation with Associative networks.
“IGNOU is an open university established by an act of parliament. It has various schools of studies and Divisions to support academic activities at the Head Quarters. IGNOU’s regional centers are spread all over the country to manage the academic and administrative activities. Each School and Division is headed by a Director and each Regional Centre is headed by Regional Directors.”
Question 5: (a) Compare and contrast the following (Any two):
i) A* and AO*
ii) Conceptual graph and conceptual representation
iii) Scripts and frames
Question 6: Write a LISP program to solve a quadratic equation ax2 + bx + c = 0 having real coefficients a, b, c.
Mar 12
11
MCS-053
Click here to download complete solution of MCS-053
Course Code : MCS-053
Course Title : Computer Graphics and Multimedia
Assignment Number : MCA (5)/053/Assign /2012
Maximum Marks : 100
Weightage : 25%
Last Dates of Submission : 15th April, 2012 (For January Session)
There are four questions in this assignment. Answer all the questions. 20 Marks are for viva-voce. You may use illustrations and diagrams to enhance explanations. Please go through the guidelines regarding assignments given in the Programme Guide for the format of presentation.
Question 1:
Differentiate between the following:
- Painting and Drawing
- Raster Scan and random Scan
- Simulation and Animations
- Visualisation and Image Processing
b) What are the advantages and disadvantages of using DDA algorithm for line generation? List the steps of the algorithm. Use this algorithm to draw a line with endpoints (2, 3) and (9, 8).
c) What is line clipping? Explain the Cyrus Beck line clipping algorithm with the help of an example.
d) Explain the Sutherland Hodgman polygon clipping algorithm.Using this algorithm clip the followingpolygon against the rectangular window as given below. Make suitable assumptions.
Question 2:
a) Explain the Homogeneous Coordinate System with the help of an example. Assume that a triangle ABC has the coordinates A(0, 0), B(5,8), C(4,2). Find the transformed coordinates when the triangle ABC is subjected to the clockwise rotation of 45° about the origin and then translation in the direction of vector (1, 0). You should represent the transformation using Homogeneous Coordinate System.
b) A polygon has 4 vertices located at A (0, 0) B (3, 0), C (3, 3), D (0, 3). Apply the following transformations on the polygon:
(i) Translate 2 units along x-axis and (ii) xy shear about the origin.
You must make and state suitable assumptions.
c) What is projection? What are the different types of projections? Explain the Oblique projection. Obtain the isometric view of a cuboid of the size 8×6×4.
d) Obtain the perspective transformation onto z = 2 plane, where centre of projection is at (0,0,10). Also define the term vanishing point.
Question 3:
a) What are the uses of Bezier Curves in Computer Graphics? Draw a Bezier curve having the control points as p0 (0, 0), P1 (2, 5), P2 (5, 9), P3 (10, 20). Calculate the coordinates of the points on the curve corresponding to the parameter u = 0.2, 0.4, 0.6. Draw a rough sketch of the curve and show coordinates of various points on it?
b) Why do you need to use visible-surface detection in Computer Graphics? Explain Scan Line method along with the algorithm for the visible-surface detection with the help of an example. How scan line method is different to z-buffer method?
c) Explain the following terms in the context of computer Graphics using suitable diagram and /or mathematical equations or one example.
(i) Depth Buffer Method
(ii) Area Subdivision Method
(iii) Basic Ray Tracing Algorithm
(iv) Diffuse Reflection
(v) Equation of a plane that passes through point P(0,0,0) and the normal to plane is given bt N (1,0,-1)
Question 4: Explain the following terms with suitable diagram / example
(i) Refreshing Buffer
(ii) Analog and Digital Sound
(iii) Interlaced and progressive scan
(iv) Compression and decompression in digital video
(v) Hypermedia and hypertext
(vi) Types of Bitmap and Vector graphics
(vii) gif and jpeg images
(viii) Ray tracing and Ray casting
Compression and decompression in digital video
Mar 12
11
MCS-052
Click here to download complete solution of MCS-052
Course Code : MCS-052
Course Title : Principles of Management and Information Systems
Assignment Number : MCA(5)/052/Assign/2012
Maximum Marks : 100
Weightage : 25%
Last Date of Submission : 15th April,2012(For January Session)
This assignment has seven questions. Answer all questions, carries 80 marks. Rest 20 marks are for viva voce. You may use illustrations and diagrams to enhance the explanations. Please go through the guidelines regarding assignments given in the Programme Guide for the format of presentation. Answer to each part of the question should be confined to about 350 words.
Question 1 (a): Explain difference horizontal and vertical organization
Question 1 (b): At what level of management, following is decided? Also, explain how?
(i) Selling of products in international market.
(ii) What should be overall production plan during festive season
(iii) What business the company should close
Question 2(a) : Explain 5 most distinct stages in Life cycle of an organization.
Question 2(b): Explain 5 critical requirements and requirements definition and management process areas analysis process area analysis. Give some requirement analysis tools?
Question 3: What are Artificial Intelligence Systems and how can they be categorized? Also, discuss the role of these AI systems in the Management and Marketing.
Question 4(a): What are steps in IT Risk management process.
Question 4(b): What are steps involved in Disaster management
Question 5: Suppose you are a project Manager and you have to develop ERP package or your company. Discuss with management, whether to develop it in-house or get it developed from outside.
Question 6: How is knowledge is created and shared and also indicate factors that complicate knowledge transfer
Question 7: Write short notes on the following:
- Artificial Neural network
- Different Computer crimes
Mar 12
11
MCS-051
Click here to download complete solution of MCS-051
Course Code : MCS-051
Course Title : Advanced Internet Technologies
Assignment Number : MCA(5)/051/Assign/2011
Maximum Marks : 100
Weightage : 25%
Last Date of Submission : 15th April,2011 (For January Session)
There are eight questions in this assignment. Each question carries 10 marks. Rest 20 marks are for viva-voce. Answer all the questions. You may use illustrations and diagrams to enhance the explanations. Please go through the guidelines regarding assignments given in the Programme Guide for the format of presentation.
Question 1:
Write an application to create a XML document from a university employee database .The XML document should contain the following:
i) Employee code
ii) Employee Name
iii) Designation
iv) Address
v) Department
vi) The last twelve month performance summary
Question 2:
Assume there is a student database in Oracle with the following fields:
Student enrollment No.
Student Name
Program
Address
School of Study
Write a code for Servelet which will display all the fields of the student database in the tabular manner.
Question 3:
Write a web based student registration application where students can register online with their enrolmentnumber. The registered students should be able to log on to the site after getting registered. You are required to use JSP, Servlet and JDBC.
Question 4:
For a shopping website you have to select Entity beans over stateful session beans. Justify your selection criteria.
Question 5:
Why is XML more suitable than HTML for use in the web? With the help of an example briefly explain the structure of XML documents and its components
Question 6:
Explain SSL and TLS with their working and security measures.
Question 7:
What are the advantages of using an Entity Bean for database operations over directly using JDBC API to do the same? When would I need to use one over the other?
Question 8:
Explain database handling in JSP using type 2 and type 4 drivers.
Aug 11
19
MCSL-045
Click here to download complete solution of MCSL-045
Course Code : MCSL-045
Course Title : UNIX and DBMS Lab
Assignment Number : MCA (4)/045/Assign/11
Maximum Marks : 100
Weightage : 25%
Last Date of Submission : 15th October, 2011 (for July, 2011 session)
15th April, 2012 (for January, 2012 session)
The assignment has two parts A and B. Answer all the questions. Each part is for 20 marks. UNIX and DBMS lab record carries 40 Marks. Rest 20 marks are for viva voce. You may use illustrations and diagrams to enhance the explanations. Please go through the guidelines regarding assignments given in the MCA Programme Guide for the format of presentation. If any assumptions made, please state them.
PART-I: UNIX Lab
Question 1:
(a) Perform the following in UNIX operating system using the UNIX commands: (3Marks)
(i) Find the number of users that are presently logged in to your system. You must count them using UNIX command only.
(ii) Create three files with at least a paragraph of text. Print these three files using minimum number of UNIX commands.
(iii) Create a directory. Change its permission to Read only. Now try to copy a file in this directory. Record the outcome of the operation and explain it.
(iv) Create a file having some text. Copy its content to another file. Edit at least two lines of the copied file. Now use UNIX command to display the difference between the two files. Explain the result so obtained.
(v) Change the command prompt to % and then restore the original command prompt.
(vi) Find the number of files in you directory.
(b) Perform the following tasks using grep. You may use additional commands, if needed: (2 Marks)
(i) Count the number of blank lines of a file.
(ii) Display all those lines in a file that has only upper case characters.
(iii) Select all those lines that has a ? at the end of the line.
(iv) Select all those lines which has any of the following patterns
ab aab aaab or like wise
Question 2:
(a) Write a shell program that converts all the alphabets in a file to uppercase alphabets and displays the translated file on the screen. (5 Marks)
(b) Write a shell program that counts the occurrences of the complete word MCA in a file. (5 Marks)
(c) Write a shell program that outputs all odd integers up to the command line parameter starting from 1. (5 Marks)
PART-II: DBMS Lab
PART-II: MCS-043
Question 1:
A Database System is to be created for maintaining Inventory of items in a store. The database system is expected to maintain stock of various items available in the store. The items are organised into several categories. Each item has an item code, name, selling price and a batch number. A batch number is related to the expiry date of the item, supplier code of the supplier who supplied that item and the cost price of that item. The system also maintains the list of suppliers. System records the daily sales of the items. In case the stock of an item falls below a specified amount called reorder level for that category, a report/ purchase order is generated for the purchase of the item.
Perform the following activities for the description as given above.
(a) Design the database with suitable integrity constraints and create the database with appropriate data using a commercial DBMS. Make suitable assumptions, if any. (3Marks)
(b) Write the following queries using SQL: (2 Marks)
(i) Find the list of the items that may expire in next ten days.
(ii) List the supplier who has supplier an item named “Pen” at the lowest price in the last one year.
(iii) Find the list of suppliers who have not supplied any item in the last one year.
(iv) Print the category wise list of items sorted in the order of item names.
(c) Assume two views for the tables designed in part (a). The first view is for the store manager who is only allowed to enter new data in all the tables, however, once he/she enters the data he/she is not allowed to modify it. The second view is for the salesperson who can READ the item details and sales price for all the items and create a bill of sale. Create the two views and one user of the each view. Give the suitable access rights to the views/users (4 Marks)
(d) Write a procedure that creates the average cost price of all the items. (4 Marks)
(e) Create a transaction of sales of several items to a customer. You need not record the details about the customer. (3Marks)
(f) Perform the following activities: (4 Marks)
(i) Create a trigger that prints the reorder list and quantity to be reordered on weekly basis.
(ii) Create a trigger that automatically prints the stock status at the end of each day.
