Dbms.pdf

A PROJECT PROGRESS REPORT ON “SOCIAL NETWORKING SITE” SUBMITTED IN PARTIAL FULLFILLMENT OF THE REQUIREMENT FOR THE AWARD OF THE DEGREE OF BACHELOR OF TECHNOLOGY IN COMPUTER SCIENCE AND ENGINEERING SUBMITTED BY

UNDER THE CONCERNED GUIDANCE OF

Mr.Nagendra Nath Dubey (ASSIST. PROFESSOR, COMPUTER SCIENCE AND ENGINEERING)

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING BENGAL COLLEGE OF ENGINEERING AND TECHNOLOGY DURGAPUR, WB

CERTIFICATE OF APPROVAL The project “SOCIAL NETWORKING SITE” submitted by student name UNDER THE CONCERNED GUIDANCE OF “Mr.Nagendra Nath Dubey”, is hereby approved as a creditable study of engineering subject to warrant its acceptance as a pre-requisite to obtain the degree for which it has been submitted. It is understood that by this approval the undersigned don’t necessarily endorser approve any statement made, opinion or conclusion drawn therein but approve the project only for the purpose for which it is submitted.

Mr.Nagendra Nath Dubey

Project Mentor (Assist. Professor)

Head Of Department Computer Science and Engineering

UNDERTAKING

We, DONA GHOSH (162038163) , ATUL KUMAR (162022112) Bachelor of Technology, 6th semester (Computer Science and Engineering), hereby declare that our project report, titled “SOCIAL NETWORKING SITE WITH HTML,CSS,PHP,SQL AND JAVASCRIPT” is our own contribution. The work or ideas of other people which are utilized in this report has been properly acknowledged and mentioned in the bibliography. We undertake total responsibility if any Trans of plagiarism is found at any later stage.

DONA GHOSH (162038163) ATUL KUMAR (162022112)

CONTENTS

1.ABSTRACT 2.INTRODUCTION 3.SYNOPSIS 4.OVERVIEW 5.SCOPE OF THE PROJECT 6.OBJECTIVE OF THE PROJECT 7.MODULES 8.CONCEPT &TECHNIQUES 9.SCREENS 10.ADVANTAGES & LIMITATIONS 11.COCLUSION 12.BIBLIOGRAPHY

ACKNOWLEDGEMENT First of all, we thank the almighty god who showered his immense blessings on us, which helped us in completing this project. Our sincere and warmest thanks to Head of the Department of Computer Science, Bengal College of Engineering and Technology, for his valuable and inspiring guidance and encouragement given throughout the period of this project. We feel indebted to project mentor Mr.Nagendra Nath Dubey (Assist. Professor), who is guiding our project with reviews, evaluations, guidance and suggestions offered throughout this project. We appreciate his immense patience. We also express our whole hearted thanks to our parents and friends for their encouragement to bring this project to a successful completion. Thank You………

ABSTRACT Social networking site is a HTML,CSS,JAVASCRIPT,PHP,SQL,JQUERY based project which allows people to communicate, share ideas, activities, events with in the network. This system focuses on online communication. This system allows the users to promote social responsibilities like traffic rules, public hygiene, aversion ect,.

Social Networking describes the phenomena found in, participatory and selfexpressive Web sites—such as YouTube, MySpace, Facebook— where members/participants expose, discuss, reveal, and expound on their personal lives, activities, hopes, dreams, and even fantasies for others to see and marvel upon. Online communities represent a growing class of marketplace communities where participants can provide and exchange information on products, services, or common interests. Brands are, or have been, the commercial enterprises’ approach to building social networks They have created brand cohorts through logos, colours, and clever icons All of these “brands,” and the imagery and mystics behind them, have really been nothing more than attempts by the marketer to create a social network that was accepted and that engaged people to purchase or continued to purchase products or services. Companies are increasingly using online communities to create value for the firm and their customers . Ensuring that brand activity is relevant to a social network’s core audience is crucial for advertisers wanting to tap into niche communities In this project we develop a framework that explores the process of how a firm’s online community enhances cons umers’ brand commitment Key Words: Brand Commitment; Online Communities; Online Communities Commitment; Social Networking;

INTRODUCTION Social networking site is a well established web based final year project. This is developed to provide a website for people to communicate. people who wants to share their ideas and give their views for creating social awareness can use this application. Social networking site allows users to create profiles, share the information with friends. they can create the growing network information. Users once registered can establish their views about social responsibilities and made publicly as well. This site provides a common platform for people of Indian where they can perform many activities related social responsibilities. like voice out violations, injustice, inhumanity, corruption happening in their vicinity and provides online debate or discussion on certain topics of broad applicability. The site can provide various measures for fellow citizens to rate, control and monitor the social responsibility of individual. Social networking is a web based communication media, which allows users to have conversations, share information and create contents. There are numerous social media sites like blogs, social networking sites, instant messaging, photo-sharing sites, video-sharing sites and more. Billions and billions of people across the world use social networking sites to share and make connections on a personal level. As an introduction to social networking sites people use social media to communicate with friends, family and to learn new things which interests them and which is entertaining. Business houses use social media to have conversation with their target audience, get feedback from customers, promote, and elevate their brand. Professionals also use social media to increase their knowledge in their respective fields and build a network of professionals from similar industry. With new social networking sites being introduced every year, deciding which one is right for your business, professional use or personal use is an overwhelming affair. So it becomes imperative that you have to be aware which social media sites will fit into your requirements and communication strategy. Using too many social networking sites to convey your message could dilute the entire social media strategy and your entire planning and effort will be ineffective. The best strategy is to focus on those social media sites, which are relevant to you so that you can share your content with appropriate audience. While there are many social media sites in the web, an introduction to social networking sites like the ones listed below is very important. Facebook: This is a social networking site, which allows people to connect with network of friends, business houses and organizations. It is ideal site for companies to build up their overall brand awareness and post contents, videos, photos, event listing and links. LinkedIn: This is a business related social media platform mainly used for professional networking. It is an ideal site to post updates, job postings, academic programs, events and projects.

Twitter: This micro-blogging site allows users to post updates. Business houses and individuals looking to engage their followers at a high frequency rate should consider using Twitter.

SCOPE OF SOCIAL NETWORKING SITE

This is the age of contacts for interaction between people to people through social platforms in the web. The tremendous popularity of using the social media networking could never have been realized before. In fact, social media have become an important tool of marketing in true sense of customer orientation. The scope of social networking is widening, and today it offers a strong support to the companies in providing the much desired touch of concern. Future of social media networking brings exciting promises as expected from the experience of limited users from a few companies in the top bracket. This is the beginning of interweaving social media networking as a positive business process bringing two people together than merely two organizational entities. People can communicate their message to the suppliers or customers and also convey any difference of opinion over the social networks. The business community has started to take a keen interest in the enormous possibilities of reaching and serving the buyers in this emerging domain of marketing. Social media networking is a more practical approach for dealing with the consumers. It may be for improving the products listening to the customers’ views with critical appreciations. It may also help improving the ways of dealing with buyers using them as ears and the eye of the organizations. All the big companies are quite optimistic about the positive impact of Social media networking and gone into developing fully integrated processed with a holistic touch. Take the example of activities the companies like IBM, Microsoft and Google performs to strengthen their networking platforms via social networks like Twitter and Facebook. The bright future prospect of social networking is also proven with the fact that the technology is integrated in the mobile phones as well. Look at the devices designed with powers of interpersonal communication on a globalized outlook. These devices are now being created to with the perspective of global interaction and messaging across geographical boundaries. The concept is one, wherever on the earth; reach the common platform of the people for everybody’s benefit.

MODULES Login module Registration page Forgot password Profile module Overview Work and Education Contact details Family and relationships About me with profile image Events and Life events Write quotes on the profile With quote template Without quote tempalate Timeline profile Friend list Friend request Friend list New frind request Find friends Auto suggestion friends Categorywise friends list Chat and notification Chat notifications Chat module View friends online offline Message box New message Friend request notification New post notification Like notification Comments notification User wallpost Status update Compose message Upload photo Upload video View photos View text message View videos View photo album like option love feature Comment option Share ideas feature

Post Links Deactivate Account Delete Account Change Password Edit Profile Last Seen Hide Last Seen Show Last Seen Private Your Account like counts

DESIGN OF SOCIAL NETWORKING SITE E-R DIAGRAM

RELATIONAL DIAGRAM

CONCLUSION By creating this website for college, it is aimed to strengthen the communication among users and make campus life more lively and exciting by combining academics and cultural activities. This social media platform will become an asset for the campus and can be used for various productive purposes. This social networking site can be further expanded to all the engineering colleges in the city whereby all engineering students and faculties would be able to connect and share their knowledge with each other. Also efforts can be taken to incorporate links to various journals which students and teachers can use to publish their papers and also get an access to other research papers. An android application can be developed as well which would enable users to access this social media through their mobile devices.

BIBLIOGRAPHY Web refrences:

www.google.com www.stackoverflow.com www.github.com www.youtube.com www.w3schools.com https://csstricks.com/forums/topic/custom-html5playpause-button/ https://usefulangle.com/post/100/javascrip t https://www.sitepoint.com/community/t/i nsert-link-via-textarea/10787/10 http://php.net/manual/en/function.time.ph p

ADVANTAGES AND LIMITATIONS Advantages of social networking site The business benefits of effective social media use include:   

  





Brand awareness - Compelling and relevant content will grab the attention of potential customers and increase brand visibility. See branding: the basics. Brand reputation - You can respond instantly to industry developments and be seen as ‘thought leader’ or expert in your field. This can improve how your business is seen by your audience. See public relations (PR). Cost effective - It can be much cheaper than traditional advertising and promotional activities. The costs of maintaining a social media presence are minimal. If you choose to invest in paid advertising, you can spend as much or as little as your budget allows. Website traffic - Social content can boost traffic to your website. This can lead to increased online conversions such as sales and leads. Evaluation - It is easy to measure how much website traffic you receive from social media. You can set up tracking to determine how many sales are generated by paid social advertising. Customer interaction - You can deliver improved customer service and respond effectively to feedback. Positive feedback is public and can be persuasive to other potential customers. Negative feedback highlights areas where you can improve. Target audience - Customers can find you through the social media platforms they use most. You can choose to maintain a presence on particular platforms that are in line with your target audience. For example, if you are targeting young people you could reach them through Snapchat. If you are seeking business customers, LinkedIn may be the best channel. See social media platforms. Brand loyalty - You can build relationships with your customers through social media. This can help increase loyalty and advocacy.

Limitations of social networking site Some of the downsides of using social media include: 





Resources - You will need to commit resources to managing your social media presence, responding to feedback and producing new content. This can include hiring and training staff, investing in paid advertising and paying for the costs of creating video or image content. Evaluation - While it is easy to quantify the return-on-investment in terms of online sales generated by social media advertising – there are some less tangible benefits. It can be hard to measure and place a monetary value on the brand awareness and reputation that social media can bring. It’s difficult to know how social media effects sales in-store. Ineffective use - Social media can be used ineffectively. For example, using social media to push for sales without engaging with customers, or failing to respond to negative feedback - may damage your reputation.

SCREENS Signup

Home

Profile

Settings

SYNOPSIS AND OBJECTIVE The Project entitled "Social Networkin Site" is a web-based application Software developed in HTML, CSS,Php,Sql,Jquey,Ajax and JAVASCRIPT using them as front end & back end on Pentium machine. The main aim of " Social Networkin Site " is to make connections with friends, family,

classmates, customers and clients. Social networking can occur for social purposes, business purposes or both through sites such as Facebook, Twitter, LinkedIn, Classmates.com and Yelp. Social networking is also a significant target area for marketers seeking to engage users. The primary features of the project entitled "Social Networking Site" are –

# 1. Free web space Each member is provided free web space to publish content. # 2. Free web address Each member gets a unique web address that becomes the identity of that individual or business. The members can then use their web address or url to promote themselves or their business. # 3. Build Profile Members are provided web space to build their profiles. The profiles serve a dual purpose: one, they allow friends or contacts to identify members from their profiles; and two, the data entered by the members is used by Social Networking Sites to connect with other members who have a similar background. # 4. Upload content The Social Networking Sites allow members to upload text messages, photographs, audio and video files free of cost. All posts are arranged in descending order with the last post coming first. Further, all content is published in real time, and becomes visible instantly. # 5. Build conversations Content posted by members can be browsed and commented upon by all members who form part of the community. Content can also be tagged from third party sites on subjects that interest the group. # 6. Chat client Most Social Networking Sites have chat clients and members who can chat with each other in real time. # 7. E-mail Members can send e-mails to each other. The Social Networking Sites also send e-mail alerts whenever a member is tagged in a third party post. This enables members to learn when a fellow member has connected to them.

# 8. Create Pages Members are allowed to create pages where they can post articles or photographs related to a theme. The pages can also be used to promote businesses.

OBJECTIVES 1. Develop Brand Awareness Creating brand awareness shortens the sales process, increases market share, and positions a brand as a leader in its sector. It’s necessary to perform an internal audit to evaluate brand positioning strategies and to understand the impact of marketing actions on brand image. Brand differentiation can develop from a number of actions such as the creation of original content, personalized promotions aimed at the target audience, prospect profiling, product development based on social insights, and communication strategies adapted for sociodemographics of interest. Here are some KPIs to help track and report on the success of this objective: 

Mentions: the number of times the brand comes up in social media conversation and the number of times these conversations are shared.



Impressions: the number of potential views that a message has.



Reach: the number of people who have received viewed a publication.



Social Sessions: the number of site visits, blog post views, etc.



Share of Voice: volume of mentions received by a brand versus volume of mentions received by all relevant competing brands.

A graphic representing the number of brand mentions over time, via Digimind Social.

2. Increase Size of Social Communities and Accurately Target Audiences The relevant KPIs here are: 

Community Performance: the number of fans, followers, or subscribers broken down by social media channel.



Community Progression: the follower growth rate by social media channel.



Share of Community Voices: number of followers compared to those of competitors.



Share of Voice by Channel: the community size of each social media platform as a percentage of the total number of social followers across all platforms.



Social Visits: visitors coming to social media accounts coming from the brand’s website or blog.

The growth of subscribers over time by social media platform, via Digimind Social.

3. Strengthen Engagement Strategies to Increase Customer Loyalty The primary objective here is to create a long-lasting relationship between the target audience and the brand. It’s necessary to engage with social media followers who have a certain level of credibility or influence among the target audience. For example, if your target audience is football fans, an NFL player would have social influence among this demographic. The influencer doesn’t necessarily need to be massively influential on a global level – sometimes a smaller, very active community is more effective than a larger, more passive community. Effective social media strategies should integrate influencers with a committed following and brand ambassadors with high levels of engagement. The KPIs for this objective are:



Interaction Performance: the number of interactions (likes, retweets, shares, etc.) and number of comments.



Evolution of the Interactions: the growth rate of interactions.



Publication Performance: the number of messages generating an amount of interaction greater than a predefined threshold.



Influencer Population: the number of influencers and brand ambassadors as a percentage of the community size.

A breakdown of sentiment associated with key industry terms, via Digimind Social.

4. Monitor Customer Feedback In order to improve customer experience, it’s necessary to capture consumer opinions regarding relevant products and measure consumer satisfaction and evolution over time. The following KPIs should be measured for this objective: 

Brand Perception: the sentiment associated with the brand and its products, especially in comparison to competitors.



Evolution of Perception: the percentage of positive versus negative sentiment over time.



Reputation Score: the sentiments associated with the brand weighted against the community size of each review.



Response Performance: the response rate to social media interactions.



Resolution Performance: the number of customer tickets resolved over a given time period.

Share of social interactions by social platform, via Digimind Social.

5. Convert Social Followers into Qualified Leads and New Business Towards the end of marketing campaigns, brand content should have generated social media followers and interactions with prospective customers. The associated KPIs here are: 

Number of Leads from Social Media: the share of marketing leads originating from social media which are turned into qualified commercial leads and integrated into the CRM platform.



Lead Growth from Social Media: the growth rate of conversions from social leads to sales leads.

BENGAL COLLEGE OF ENGINEERING AND TECHNOLOGY

COMPUTER SCIENCE AND ENGINEERING

Social Networking Site DATABASE MANAGEMENT SYSTEM

DONA GHOSH (162038163) ATUL KUMAR (162022112)