Assignment 5

This is the link to view the feedback of people about Amul – As a brand.

http://creator.zoho.com/rohanbatra/marketing-research-amul/view/1/

Assignment 3

This is the link..

http://db.zoho.com:80/ZDBDataSheetView.cc?DBID=17039000000003018

1) select * from department, employee where employee.dept=department.dept_ID and department.location=’New Delhi’

2) select “employee id”, “employee name”, salary from employee where salary>5000

3) select * from department, employee where employee.dept=department.dept_ID and department.location=’New Delhi’

4) select “employee id”, “employee name”, designation, “dept_name”, location from department, employee where employee.dept=department.dept_ID and department.location=’New Delhi’

<iframe height=’350′ width=’350′ name=’ZohoDBFrame’  frameborder=’0′ scrolling=’no’ src=’http://db.zoho.com:80/ZDBDataSheetView.cc?OBJID=17039000000003220&STANDALONE=true’> </iframe>

Res – Jhs

http://www.wikimapia.org/#lat=25.467469&lon=78.612317&z=18&l=0&m=a&v=2

3rd Normal Form

Un-Normalized Form

Roll No.

Name

Address

E-Mail ID

Ph. No

Late Outstanding  Fine

Book Title

Book Author

Book ISBN No.

Bok Price

Library Cat No.

Quality of The Copy

Date of Issue

Date of Return

                                            Normalized Form 

Roll No.	PK
Name
Email  ID
Address
Phone No.
Late Fine Outstanding

Book ISBN	PK
Library Catalogue No.	FK
Book Title
Book Author
Book Price

                                           

Library Catalogue No.	PK
Roll No.	FK
Quality of The Copy
Issue Date
Return Date

  

System Architecture

Rajesh: What is System Architecture?

Me: System Architecture is a formal description of a system, or a detailed plan of the     system at component level to guide its implementation, or we can say that it is the design or set of relations between the parts of a system.

Rajesh: Are there different kind of architecture?

Me: Ya.. There are mainly 4 types of System Architecture.

1.      Single Tier Integrated Architecture.

2.      Tier Two Client Service Architecture.

3.      Tier Three Architecture.

4.      Multi Tier Architecture. 

Rajesh: What are these tiers?

Me: In single tire architecture, data & application are different which may be on the same system separately.  In tier two architecture, data is hosted at a different system or the application is on another system. This could be connected on LAN using TCP / IP protocols. With this type of architecture, processing burden on the server machine is less even when there are too many users. In case of tire three architecture, data & business application is hosted at different servers and the user is accessing data from a different system. In case of multi tier architecture – Data Layer, Business Application & Web Server are three different entities on different physical machines and the user access the data with the help of a application through a browser.             These multi level architecture further can be consolidated and the data layer can be on one separate entity and application and the web server can be separate entity or all three i:e; data layer, application and the web server are been located on a single physical machine. 

 But there are some issues with these kind of architecture.

1.      With this type of architecture duplication of data is possible.

2.      With multiple location data inconsistency can happen.

Rajesh: Then how can the issues be taken care off?

Me: These can be solved by using RDBMS, in which if u make entry at place it automatically changes the other linked data base. Which helps in maintaining the consistency of data. The other way to solve these issue is to implement ERP, which breaks the silos and help to integrate data. For example: if a sales happen which needs to be posted in Sales division, Finance division & HR division. so all this posting will happen automatically because all the departments are integrated.              

 By implementing ERP we can create a separate data warehouse which will have required data which can be used for a particular purpose such as analysis of sales figures etc.            

All these can be linked to each other through WAN or Internet. But in case of internet there are some security issues so for that we have to have firewalls to protect the data from hackers. 

Rajesh: Thanks for the help and making me aware about these things   

Hello world!

Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging!