How to create a database on SQL Server management studio? A tutorial.

SQL stands for Structured Query Language. SQL is used to communicate with a database. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common relational database management systems that use SQL are Oracle, Sybase, Microsoft SQL Server, Access etc. Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system.

SQL code is divided into four main categories:

• Queries are performed using  SELECT statement, which is further divided into clauses, including SELECT, FROM, WHERE and ORDER BY.
• Data Manipulation Language (DML) is used to add, update ,select or delete data like SELECT,UPDATE,INSERTE, DELETE commands
• Data Definition Language (DDL) is used for managing tables and index structures. Examples of DDL statements include CREATE, ALTER, TRUNCATE and DROP.
• Data Control Language (DCL) is used to assign and revoke database rights and permissions. Its main statements are GRANT and REVOKE.

Here is a tutorial for how to create a database on sql server management studio

First you have to select server type which is database engine  and then you have to  type your computer name on server name . if you don’t know your pc name then go to mycomputer then right click on it and then select properties .if you give windows authentication then there is no need to type user name or password but if you select sql server authentication then you must have to type login or password after that click on connect button.

Right click on database and select new database

Give database name and then press ok button.

Your database is created.

Written by,

Rameeshah Shahid

ARMEZ - The Tech-Gaming Begins Now!

Experiencing ARMEZ

Do you want to experience combat shooting game in actual environment?

Do you want to stay physically active while enjoying a shooting game?

Do you want to pass leisure time purposefully instead of video gaming then getting headache?

Do you want a tech-upgrade of training gadgets and technologize real-time scenario?

Do you want to:

Be bold?

Be brave?

Banish the boredom?

ARMEZ is here for you.

“ARMEZ can provide précised training gadgets thus revolutionizing the training methods”, says Tahniat Hasan Khan.

ARMEZ's Products

ARMEZ - The tech-startup of NEDUET

It was the nick of time when the group of four girls who are behind this technological and striking project, were on a thoughtful path of choosing final year project (FYP). The very path was leading them to choose between just marks or brilliance. While taking care of marks, they took the brilliant path, no doubt. The path was toilsome indeed as they had to literally put their sleep, sweat, and seconds on the path but they were happy as they were using their engineering skills to shape a project that was meant more than a project to them. They took their entrepreneurial endeavors along with maintaining high grades and dived into the world of braininess to deliver one of the best FYP of NED. After all what’s the use of a project or degree or knowledge if the world is not getting benefit from it?

“It was the time when we were quite confused about the selection of an appropriate Final Year Project, when this idea was proposed by our mentor Dr. Khurram”, says Nimra Idrees Fazil.

Among hundreds of FYPs, this FYP was presented not just to get marks, not just to make a good report, not just to get a degree but also to achieve a shear, dynamic, eye-catching, and ambitious goal. The goal of using the engineering knowledge for the better of society and for the technology itself. The girls took the very FYP a step ahead and made it spectacular, obliging, and gratifying for others. The FYP has now morphed into a tech-startup which has emerged as ARMEZ in the technological realm. As they are now part of entrepreneurial environment; they realize that taking risks, dealing with uncertainties, and working outside of work hours is what one can expect. But they are more motivated than ever before and want to take ARMEZ to an elevated level where not only it is self-sustainable but also able to create jobs for others.

                             Sheena                                                            Ramla

Sheena is first position holder from Electronics Engg. Dept. NED. 

                                       Nimra                                                         Tahniat

Shaping ARMEZ – The challenges

This staggered project was intelligently brought into existence with continuous and strong-willed struggle & perseverance. The four girls were working in the lab focusing on the project while experiencing the dynamics of team work to achieve milestones as they were transforming a basic FYP into a well-defined product. They endured numerous challenges from hardware designing to mechanical fittings, from working whole day to work even during late hours after a tiring day, from brainstorming in the lab to visiting the market, from debugging software glitches to taking care of the hardware aesthetics, and working towards their goal outside of comfort zone while tackling the negativities of the society.

“The first challenge we came across was to achieve a desired range which we managed to accomplish after numerous efforts”, says Nimra Idrees Fazil.

How the ARMEZ’s amazing four feel now?

ARMEZ has already launched its debut project in Arena. The girls feel even more driven towards delivering further projects as they want ARMEZ to thrive in terms of technology and expand in terms of clients. With success comes responsibility; the responsibility of carrying the success with good hopes for the future while being an exemplary start-up that juniors in the lab and in NED can follow in terms of strenuous and dedicated hard work.    

“We have achieved amazingly well in short period of time. Yet we know, there is a long way to go”, says Ramla Kaleem Shah.

“We will go in all directions, through all difficulties in order to make it self-sustainable”, says Sheena. 

ARMEZ’s message

Nothing should stop you from striving towards your dreams like societal thinking that how weak you are, peer-pressure, the university you study in, or the country you live in. There is only one thing that hinders you from triumphing; YOU. Try finding the guts within YOU, get the idea, plan it, then do it. Who is stopping YOU?

“Think positively, work hard, take risks and be patient as success takes time", says Dr. Khurram, Founder & Director, ARMEZ.

“Pakistan needs job creators”, says Sheena.

“Do not be afraid of failure”, says Ramla Kaleem Shah.

“Do not lose hope and keep struggling for the best. Pakistan needs such people and it’s high time to serve our country”, says Tahniat Hasan Khan.

ARMEZ’s specialties

Playing with ARMEZ’s gadgets can assist you to:

è Stay physically active & healthy

è Be socially interactive

è Stay mindful & strategic during un-predicated situations

è Boost endurance & self-confidence

è Responsive to sudden & un-expected moments

è Develop team work capability

è Strengthen decision making power

è Stay sane while administering positivity

è React positively while alarming and terrifying incidents (God-forbid)

è Learn how to be stress free & stay happy!   

 Feel the Thrill with ARMEZ.

Amazed with ARMEZ,

Engr. Ayesha Alam Khurram

Munching Mood – Eat healthy food

Even though when we have had a main meal, there are times when cravings develop between meals. When there are cravings and it is not the time of meal, usually we can much whatever we get hands on. It is better to have fewer calories munching food handy at home and outside of home as well. Here are few suggestions for a healthy munch. Munching on these not only takes mind off the unhealthy munching stuff like sweets and other fattening stuff but also helps achieve a healthy and smart body. 

Nuts & Dry fruits

Nuts like almonds, walnuts, pistachios, peanuts, and cashews are good munching options. They do not have many calories and can be taken whenever stomach asks for a top-up. Nuts can be carried along when we are outside of home as well. Nuts are savory and make you feel fuller till the next meal. Nuts even help in a healthy weight loss.    

Raisins, dates (fresh or dry), figs, and apricots not only tackle your sweet tooth but also keep you away from a big bar of chocolate or 2 scoops of ice cream. These are rich in vitamins. They improve your health conditions and help in weight loss.

Fruits & Vegetables

The new research says that you do not need to count calories or starve for weight loss. This is the era of healthy weight loss and not just weight loss. Apples, citrus fruits like oranges, melons, berries, and even bananas can be munched without having pressure of what am I eating?

Fresh veggies like cucumber, carrot, beet, radish, and lettuce can be turned into a salad at home or even munched; on as is where is basis when outside of home. Then you won’t have to stop at a fries shop or bakery.    

Milk & Yogurt

Milk and yogurt should be part of daily intake as both contain calcium and vitamin D. They not only make keep bones strong but also help slowing down the ageing process. Next time you crave for a fizz & chips, get milk with little amount of cereal or yogurt with fruits or nuts. 

Most people do not consider milk and yogurt as part of daily diet, but these are very important as calcium is not only important for bones, but it is important for teeth as well. Strong bones keep away many problems like osteoporosis, bone density reduction, fragile bones, fractures in the case of sudden shock, tooth fall at early age, and pain in the bones.  

Roasted dry peas & Saunf

Sometimes we are full, have munched as well but still craving. Fennel seeds i.e. saunf and roasted dry peas can be used for that purpose. Keep it at home, in office or in bag. They have long shelf life and keep you satisfied. Saunf is good for oral hygiene and eye sight. Roasted dry peas are a crunchy option for a healthy munch.     

So next time when you feel starved, have junk cravings, or feel a sweet tooth; munch on these savory & crunchy goodies for foodies that are packed with nutrition & natural goodness for everyone.  

Munching tips by,

Engr. Ayesha Alam Khurram

The 3 Color Lake - A kids' story

Once there was a girl. She liked to do power full things like hiking, wall climbing, running, and horse riding. But she didn’t use to like swimming or diving because she was afraid of water. One day she was on a hiking trip. She was hiking for hours and then she was near the peak of a small mountain. As she watched down the mountain to see how high she is, suddenly her ring got off her finger and dropped down. The ring that she was wearing was the birthday gift from her mom so it was a special ring. She tried to hold it but it was too late and the ring dropped deep down into a 3 color lake. The lake was blue, green, and red.

The 3 color lake

The girl started coming down the mountain, as she wanted to get her ring. It took hours before she could reach the lake in which her ring was dropped. When she reached the lake, she saw that the lake was of 3 colors, means there were three parts of the lake. One part was blue, other was green and the third was red. She came near the blue part first and saw that the water was very fresh and clean that is why that part was blue. She called out for someone as she didn’t know swimming so she could not go herself inside the lake. From the blue part of the lake, a dolphin whose name was Machlee took out her head. The girl asked Machlee if it could help her finding her ring. Machlee was nice so it went back into the lake but after sometime it came out and told the girl that there is no ring in her blue part of the lake.

Machlee, the dolphin

Then the girl went to the green part of the lake and saw that there were too many weeds and plants that is why that part was green. She called out for someone, then a hippopotamus named Floria came out. Floria was also nice so it searched for the girl’s ring but couldn’t find it. Then the girl asked Machlee & Floria to find her ring in the red part but they told that the red part belongs to a crocodile named Dile and it was very mean so they couldn’t go to red part. The girl went to red part of the lake and saw that there were many red rocks in that part that is why that part was red. She called out for someone for help but no one came out and the girl understood that Dile must be mean that is why it was not coming to help her. 

                                              Floria, the hippopotamus                                              Image

Then the girl didn’t cry as she was a brave girl. But she thought that if she had learnt swimming she could have gone in the red part of the lake to get her ring herself and she didn’t have to ask anyone to help her to find her ring. Only if she knew swimming. So she thought and thought that what to do? She couldn’t let her ring go so easily because it was a birthday present after all. But she was stuck. Dile was not coming out to help her and she couldn’t go into the lake herself as she was afraid of water. 

                                        Dile, the crocodile                                                   Image

What the girl will do next?

Will she find her ring?

Will Dile help her?

Stay tuned for the next episode…     

Story by,

Engr. Ayesha Alam Khurram

 

3 Discoveries of 2016

SKIES!

The universe out there is gigantic and unbound by the intelligence of human species. NASA has always been discovering new galaxies, stars, black holes, interactive waves, and planets etc. As soon as the humans understood the mechanism of our solar system, we have imagined similar solar systems with some species living close by. As close as few hundred light years perhaps. Exoplanets are being discovered and looked into for the very curiosity. Exoplanet are those planets that are planet like but do not belong to our solar system. An exoplanet named HD 131399Ab which originally might be 16 million years old is discovered in 2016. It is a part of the constellation Centaurus which itself is more than 300 light years from our solar system. The mechanism that distinct this exoplanet from other planets and exoplanets is that 3 stars can be seen from this planet i.e. this exoplanet has 3 suns. So guess what? This explanet sees three dawns and three dusks. We humans can discover such nature’s phenomena and wonder how it is like to get triple experience of sun in a day. Meanwhile we should also ponder upon the purpose of our very own sun and ponder as well on the rising of the sun from the west!        

Image

OCEANS!

The ocean and the waters conceal miraculous marvels with in them. The ocean is entirely another universe for humans to explore. The more it is explored, the more it reveals its sensations. The dwellers of the water world are carrying on their duties whether or not being discovered. Ghost octopus is the oceanic discovery of 2016. It was found near Hawaii at the bottom of the sea at about 4,000 meters depth. The point is: whether documented or not, discovered or not, it is there for long & long and carrying on the task perfectly that is assigned to it by the nature. A moment of wonderment! 

   Image

HUMANS!

Digestive system is studied and researched for decades; even centuries. Doctors/medical researchers seem to know what the cause of an upset stomach is. Do they know or do they know? In the digestive system there is a contiguous organ which was first spoken of in 1858 and got its name in 1878 as mesentery. But it was not professionally given recognition. Professor Coffey has recently researched and discovered mesentery in 2016 as an organ which links intestinal blood and other fluids with other body parts. This latest anatomical discovery is promised to clarify medical students and researchers as they structurally understand the human body. This organ was already there from ever before since mankind knows his anatomy? How the doctors were effectively prescribing medicines for diseases such as inflammatory diseases that are related to bowel movement? Another point to note is that, the organ is there, study is there, technology is there for long but still there are new discoveries. Who knows by the next century the human anatomy will transform into which shape and order?       

Image

From the human body to the ocean and to the universe there is a lot to be explored, a lot to be pondered, and a lot to understand. Are we up for it? 

Awestruck by natue;

Engr. Ayesha Alam Khurram

Refernces

http://www.thelancet.com/journals/langas/article/PIIS2468-1253(16)30026-7/fulltext

https://www.nasa.gov/feature/goddard/2016/newly-discovered-planet-has-3-suns

http://news.nationalgeographic.com/2016/03/160304-ghost-octopus-science-animals-oceans/

Follow a legacy? Or can you proclaim your own legacy?

Every now and then I hear the word legacy. Her legacy. His legacy. Sometimes I hear from amateurs or a group of people who call their work as a legacy. Or I hear that those amateurs are calling a series of entertainment events as a legacy. Other times I hear a celebrity proclaiming about the legacy that is being created by the one. Well, I ask the question to myself that do they even know what it is meant to be a legacy?

What is a legacy?

A well-trodden path that is entwined by continuous chain of followers who are totally dedicated to follow and carry-on the very path. A legacy is a heavy burden for the one who is proclaiming to have created one’s own legacy. The legacy left behind must be blue-printed in such a manner that its followers must not have any difficulty and confusion when following it. They legacy is something that the followers have no doubt about the initiator of that legacy; physically, emotionally, judgmentally, psychologically, timely, and spiritually. 

What is not a legacy?

A legacy is not that a person has set certain rules and steps for oneself then achieves glamour, fame, likes, and shares. A legacy is not meant to be kept to oneself such that no one knows how that person has achieved a so called materialized success. A legacy cannot be created every now and then. It has to be long timed, well planned and certain. The ones who are proclaiming to have created legacy don’t even know whether they will be followed or not. On the clear note, a legacy is not just something that is liked or shared or followed by millions and has no depth. A single person might be on the correct path following a true legacy and millions can be astray. Can’t they be?

A lasting legacy?

Legacy cannot be developed each year, or even each millennium. It might not be developed even when one strives for decades or for generations. It is something that gets developed by clear to everyone and virtuous practices and is transferred from heart to heart or genetically. Legacy comes down from the past and is not bound by time or genetics. Although there can be genetic connections between the ones who bear the same legacy but it is not a necessary feature to carry on the legacy. One may be a part of a legacy and might not know it consciously. A legacy lasts when one consciously, sub-consciously or even unconsciously follows a path and tries to establish it clearly for the later generations to follow. Remember that even millions might be following a single legacy but everyone has the right and guts to live it with their own twists and twirls. 

Who are true legacy followers?

Whoever follows a legacy, the one carries on with his/her own style but mainly follow the actual legacy. They are the ones who spend entire lives in publicizing the very legacy via words and styles. They try to encompass as many followers into the fold of that legacy as they can. They try to live up to that legacy and when they die, the legacy is already taken by many to carry it on.

A legacy that is set on a true path lasts. No matter how many people reject it but if it’s true, those who own it, who struggle to follow it, and who propagate it don’t get distracted from their true sense. A true legacy doesn’t need to be spoken of it as a legacy. Whether or not one declares it as a legacy, it remains in the hearts and styles of generations after generations.       

Thoughts on legacy,

Engr. Ayesha Alam Khurram

How digitization is beneficial?

Introduction

In today’s digital era, everyone in a seriatim fashion is embracing the technology to shape the career, to improve social interactions, to analyze problems, to preserve the moments, and to digitize their profile. In other words people are digitizing their lives. The process in which an analog data or information or geographic feature on a map that is not readable by computer is converted into computer readable format and represented digitally is called digitization.   

Benefits of Digitization

Once the data or map or any information is digitized its access can be increased, it can be distributed on massive scale, it can be preserved for long, it can be integrated into software, it can be analyzed in a technological way, and the intentional goals through that data can be achieved efficiently. Digital data on a simple click can be utilized, shared, updated, integrated, multiplied, copied, published, and saved. This is the reason why digital data is less likely to get stolen or get damaged for good and never to be seen again.   

Digitizing environment

It is the environment where we dwell. As we know more about the environment, we can benefit ourselves and the environment itself. Digitizing of floods can save lives. Digital flood maps provide the information to the government and to the public and make them a bit relax while making decision about new building or infrastructure or while flood proofing existing ones. Flood maps can be cost effectively used during planning and implementation of mitigation measures at flood prone localities. Digital flood maps can provide access of flood related information to land developers and managers, property owners, infrastructure planners, policy makers, and risk assessment teams.        

Similarly, digital soil map can be used for planning of crop production, understanding of ecosystem and climate change, surveying of site for construction, soil data management, integration of soil characteristics into other environmental parameters, assessment of soil degradation and vulnerability, and using soil data in forestry and agriculture. 

Digitizing healthcare

Digitizing healthcare can have enormous benefits to the doctors, care takers, patients, hospitals, and rehabilitation centers. The doctors can have access to medical condition of a patient, results of medical tests, medicine that the patient is on, allergies information, and does and don’ts with the patient. The patient won’t have to undergo similar examination repeatedly, won’t have to take same tests every now and then, and won’t have to explain same case many times, will be less tensed, and will get fast action to a particular health condition. Both parties i.e. healthcare seeker and healthcare provider will save time, money, efforts, and will enjoy peace of mind at least in the terms of accessible and assessable information. Digital data of health care will provide opportunities of better medical decisions, will be a database for real-time medical research, and will not be used against medical laws due to its openness and real-time availability.

Digitizing academics

Digital libraries have information stored and that information is accessible over a server or over the internet. The user can get the desired material without being physically present in the library and can access library 24/7 round the year. The library management can relocate, add or remove a particular material any time. The library information can be conserved and turned into various copies to lessen the fear of losing that information. There is no physical limitation to store more information after the library has set up and running. Wear and tear of books and shelves don’t affect the availability of a particular material.          

Conclusion

At this pace of fast growing digital era, there is high need to digitize offices, shops, work places, art and craft facilities, cooking and recipes, finance departments, healthcare system, planning and management firms, and academics and research etc. Digital maturity in every department requires a digital mindset, management that is equipped with digital know-how, agile techniques for analysis and decision making, and digital skilled resources and workforce.    

Digitately written by,

Engr. Ayesha Alam Khurram