Premium Essay

Rm Avakjll

In:

Submitted By aravind668
Words 18417
Pages 74
Fundamentals of Database Systems Laboratory Manual1

Rajshekhar Sunderraman Georgia State University

August 2010

1

To accompany Elmasri and Navathe, Fundamentals of Database Systems, 6th Edition, Addison-Wesley, 2010.

2

Preface
This laboratory manual accompanies the popular database textbook Elmasri and Navathe, Fundamentals of Database Systems, 6th Edition, Addison-Wesley, 2010. It provides supplemental materials to enhance the practical coverage of concepts in an introductory database systems course. The material presented in this laboratory manual complement many of the chapters of the Elmasri/Navathe text typically covered in most introductory database systems courses. Chapter Mappings The laboratory manual consists of 8 chapters and the following table shows the mapping to the chapters in the Elmasri/Navathe textbook: Laboratory Manual Chapter Elmasri/Navathe 6th Edition Chapter(s) Chapter 1 Chapter 2 Chapter 3 Chapter 4 Chapter 5 Chapter 6 Chapter 7 Chapter 8 Chapters 7, 8, and 9 Chapters 3, 6, and 26 Chapters 4, 5, and 13 Chapters 4, 5, and 14 Chapters 15 and 16 Chapter 11 Chapter 12 Chapters 13 and 14

Chapter 1 presents ERWin, a popular data modeling software that allows database designers to represent Entity-Relationship diagrams and automatically generate relational SQL code to create the database in one of several commercial relational database management systems such as Oracle or Microsoft SQLServer. The material presented in this chapter is tutorial in nature and covers the COMPANY database design of the Elmasri/Navathe text in detail. Chapter 2 presents three interpreters that can be used to execute queries in Relational Algebra, Domain Relational Calculus, and Datalog. These interpreters are part of a Java package that includes a rudimentary database engine capable of storing relations and able to perform basic relational

Similar Documents

Free Essay

Titanic

...Classical Film Forever--- Titanic “Every night in my dreams, I see you, I feel you that is how I know you go on. Far across the distance and spaces between us …….” Every time when I hear this song, it makes me think of the film --- Titanic, the most classical movie in 20th center. Titanic is not just a love story, it also connects with the big history disaster ---Titanic sink in the ocean. Titanic no doubt is a commercial as well as the future of the film and the development trend of trends. Her highest grossing and the excellent graphics technology make the film into the classic of classic. Leonardo Dicaprio plays Jack, Kate Jools plays Ross is an eternal remembrance of the people and yearning. Titanic was one of the highest grossing films which had made almost $2,000,000,000 in total. It had also picked up 11 academy awards including the best picture, best director and the best original song and so on. According to the Wikipedia, the file received steady attendance after opening in North America on Friday December, 19, 1997. By the end of that same week, theaters were begging to sell out (Wikipedia). The film earned $8,658,814 on the opening day. By March 1998, it was the first film to earn more than $1billion worldwide. The film stayed in theaters in North America for almost ten months. Titanic made double its domestic amount overseas, generating an interactional gross of $1,242,413,080 and accumulating a grand total of $1,843,201,268 worldwide...

Words: 1035 - Pages: 5

Free Essay

The Titanic

...Since 1912, when the Titanic sank on her inaugural voyage, there have been many theories behind the mystery of how this unsinkable ship ended up on the bottom of the Atlantic Ocean. Up until now, the theory has been that an iceberg tore open a 300-foot gash in the side of the 900 foot-long luxury liner. Even after 1985, when Robert D. Ballard founded the Titanic, the expeditions mainly focused on the beauty of the ship and not the damage it had sustained from the iceberg. Of course the Titanic is submerged in many feet of mud so searching for the damage has been impossible. Just Recently researchers were able to determine the damage to the ship by imaging the sunken liner with an acoustic device known as a sub-bottom profiler. They examined the ship’s starboard side, finding a series of six thin openings along the hull. This implied that the iron rivets along the plate seams probably popped open creating small gaps for the water to come in. Two wrought-iron rivets from the Titanic’s hull were recently hauled up for scientific analysis and were found to be riddled with unusually high concentrations of slag, making them brittle and prone to fracture. From the observation, researchers concluded that since these seams were roughly 20 feet below the waterline, there was an enormous amount of pressure from the seawater, which made it’s way into the compartments very quickly. Navel Architects and marine engineers claim the Titanic was moving at an estimated speed of 22 knots...

Words: 423 - Pages: 2

Free Essay

Titanic Essay

...My name is Elizabeth. I am 25 now and it has been 10 years since the horrendous night when the Titanic sunk. I stepped out of my car to a sunny spring day. The sky was a clear crystal blue and there were no clouds to be seen. I looked ahead and there it was, ‘the Ship of Dreams’- as they called it. I always heard that it was big but I wasn’t expecting it to be that big! All I could hear were little children screaming with excitement: and all I could see were the thousands of people saying (what they didn’t yet know) their last goodbyes. I walked slowly and anxiously to the ship. A sudden chill of anticipation washed over me as I became just a few steps away from entering the ship. I was going to New York to visit my older sister who was soon to be married. The next thing I heard was my mother calling for me to hurry up onto the ship. I didn’t realise that I had stopped half way up the stairs daydreaming, and was holding up all the contented passengers. I was inside now and I couldn’t believe my eyes. It was incredible, like something I’ve never seen before! Everything was so clean and tidy. I could even see my own reflection in the floor! I looked up and it seemed as if there was no ending to the ceiling. The bellboy escorted us up to our deluxe suite, shortly along with our luggage. The room was astounding, far beyond anything I’d ever expected. My four-poster bed sat in the middle of my room with the bathroom and living room on each side. As my mother turned...

Words: 1990 - Pages: 8

Premium Essay

Titanic Persuasive Essay

...enjoyable for a very short period of time, it was not unsinkable. On April 15, 1912 the RMS titanic sunk to the bottom of the atlantic ocean. Many people drowned, froze to death, and suffered. It was a very devastating time. They went out thinking they were going to have a great time, but ended up dying.. One reason the titanic sank is because of an iceberg. They ship was headed in the same direction as the iceberg, and no one knew until it was to late. They told the captain but he refused to turn the boat around, and said that they could just try to miss it. Some say the ship sunk because of the steel plates splitting when it hit the...

Words: 987 - Pages: 4

Premium Essay

The Devil In The White City Summary

...Erik Larson’s books The Devil in the White City, In the Garden of Beasts, and Dead Wake, are all about major events of history. The Devil in the White City is about the Chicago World’s Fair, Dead Wake is about events leading up to the sinking of the Lusitania, and In the Garden of Beasts is about Berlin in a Germany that was approaching World War II. Each of these topics is interesting enough to begin with, but with Erik Larson’s style of writing, they are even more enjoyable to read about. Each of the books focuses on a few people who were alive during the event that Larson is describing, and follows them throughout that event. Larson’s stories are more relatable, and interesting to read rather than a summary of an event because they not only tell what happened in history, but how it affected people. The Devil in the White City focuses on the Chicago World’s Fair, and focused mainly on a two people that were influential to the fair. The reader learned of the story of Daniel Burnham, an extremely talented Chicago architect who was tasked with building the World’s Fair. As the story progresses, the leader learns of his struggles and all of the effort that went into planning and building the fair. The other person that the reader learns about is H. H. Holmes. He came to Chicago just a few years before the fair, and using his cunning skills and charm to deceive people. He eventually opens up his own hotel to lure people into a trap so that he can murder them. Both of these people...

Words: 700 - Pages: 3

Premium Essay

Titanic

...Titanic Summary Rose is an American girl on her way back home on the maiden voyage of the ship HMS Titanic. the largest and fastest ship to be built at that time. She's heading back to the states with her mother and rich fiancé' Cal. We first see Rose running to the front of the ship frantically. She climbs to the railing and contemplates jumping and slips and a passenger named jack stops her from falling off the ship. Her screams brings people running and they assume that Jack has caused her some harm but she states she almost fell and he helped her. Cal doesn't like the fact that Jack touched his fiancé. Jack is inviting to have dinner at the captain's table. Soon he and Rose go down to the steerage quarters to dance and drink. Jack is a steerage passenger who won his ticket in a card game minutes before the ship sailed.  Rose fall in love and she decides to leave Cal for Jack. Cal and his ego cannot believe she would rather be poor and with jack than to be rich and marry him and he smacks her but it is after the point that the iceberg has hit the ship.  after many things in between Rose gets on one of the last boats leaving the ship but jumps back on the ship to die with Jack and those who are still on the ship. We see jack die and before doing so he tells her that she will not die there but in her bed an old lady. A few boats return and Rose gets rescued but doesn't let Cal and her mother know she survived and uses jack's last name of Dawson when they dock in NY.  ...

Words: 492 - Pages: 2

Premium Essay

Titanic

...When people think of the sinking of the Titanic, they will most likely think of the great Hollywood blockbuster movie that was more a love story then a historical movie with documentation of what happened on that cold night of April 14, 1912. Historians like to tell people what happened from the facts that are given to them, and eye witness accounts of what had happened on the ship the night it plunged to its deep dark grave. Everyone knows that the ship sank and that it is gone, but what they don't know is what had happened while people were being loaded into the lifeboats and what was occurring after the ship went down. Men played a big role in all of this; some were looked upon as cowards and others as heroes. There are different view points of what the roles of men were. Not only during the night the Titanic went down, but also the roles they played in society in 1912. For everyone who survived the sinking, should be thankful and happy because more then half the people on the ship that night passed away. The male survivors however had to justify how they survived, because the rule of the sea was women and children got on the life boats first. The men aboard the Titanic had responsibilities after the ship collided with an iceberg. They were looked at as if they knew they weren't going to live, but they had to save the women and children who were aboard the Titanic. As for the men who just wanted to save their own lives and didn't care about anyone else, these men were...

Words: 363 - Pages: 2

Free Essay

Titanic

...Titanic After years of construction and work, the Titanic was finally ready for her maiden voyage. The beginning of her voyage was to take place on the morning of April 10, of 1912 at approximately 10:00am. The first of the Titanic’s passengers began to board the ship. Most of these passengers were British residents who had journeyed to the Titanic by means of transportation rather than a boat or train. People rich or poor were scattered all over Southampton's bay, attempting to find their walkway. After the second and third class passengers boarded, the first class passengers were to be escorted to their cabins. Approximately at 12:00pm Titanic was ready to set sail. After Titanic sets out into the open sea, her water displacement caused connected ropes of the New York, which was a small ship, to break. This caused the stern of the New York to swing towards Titanic’s mighty bow. Titanic official's quickly prevented a catastrophic collision. After hours of being delayed the Titanic finally sets sail into the open sea headed towards Cherbourg, France. The Titanic lowered her anchor when arriving to Cherbourg, France. The Titanic reached Cherbourg, France at about 5:30 p.m. of the same day. When they anchored in Cherbourg more passengers boarded the Titanic. At approximately 8:10 p.m. Titanic raised her anchor and sailed towards Queenstown, Ireland. She arrived at Queenstown at around 11:30 a.m. of the next morning to pick up more passengers and 1,385...

Words: 1933 - Pages: 8

Premium Essay

Rose Dewitt Bukateer

...Rose Dewitt Bukater I remember the time I set sailed on the SSR Titanic. Remembering the famous, huge ship brought back memories of a young lady who had determination to save someone. She touched my life, and I still remember them always. The young woman’s name was Rose Dewitt Bukater. She and I were the same age. We were 17 and going on a voyage. She told me a lot about herself. Her father died, and that left rose and her mother (Ruth) with nothing. Her sad story was similar to mine. She was born in Philadelphia, Pennsylvania in 1895. She was first class, along with her fiancé Caledon Hockley, and mother Ruth Dewitt Bukater. She and I became close on the Titanic voyage. She told me all about her fiancé she really never loved. Rose never seemed happy when he came around. At times she told me her life was nothing more than marrying a guy she doesn’t even love. I tried giving her advice. She found Jack at a time she was about to give up all hope. They quickly fell in love and became a couple. The time the ship was sinking, she would not leave Jack’s side. I tried urging her to come along, but she did not want to go unless Jack was with her. Those words touched me that I stayed and helped her get Jack to safety. Sadly, he died and she lived to be 101. She died in 1997. What I will remember most about Rose is she was determined and had a kind heart. One of Rose’s greatest accomplishments, I think, was finally being happy, loving, and really wanting to marry Jack. I will always remember...

Words: 295 - Pages: 2

Free Essay

Vocabulary

...A. VOCABULARY 1. Detrimental (adj.) - Something that causes damage, harm, or loss; injurious Now a day, eating in fast food restaurants is advantageous because of its easy access, but on the other hand it becomes more detrimental to our health. 2. Assasin (n.) - One who murders by surprise attack, especially one who carries out a plot to kill a prominent person Raizo is a disillusioned assassin looking for retribution against his former boss. 3. Vehement (adj.) - Characterized by forcefulness of expression or intensity of emotion or conviction She suddenly became very vehement and agitated, jumping around and shouting without any specific reason at all. 4. Maroon (v) - To abandon or isolate with little hope of ready rescue or escape Five couples were marooned in their caravans when the river Avon broke its banks. 5. Shoddy - Something done or made carelessly or badly; of poor quality or craft I’m normally quick to complain about shoddy service in restaurants or even in shopping malls. B. FIGURES OF SPEECH 1. Metonymy - The substitution of one word for another object or idea, which it suggests. Substituting the name of an attribute or feature for the name of the thing itself. The mention of the word suggests the other. ✓ In falling in love, keep your feet on the ground. ✓ The pen is mightier than the sword. 2. Anthimeria - The substitution of one part of speech for another; for instance, an adverb for a noun or a...

Words: 505 - Pages: 3

Premium Essay

Season on the Brink

...The first half of the book was very interesting and at times a thriller to find out what Knight would do next. In chapter one it starts off as a normal day at Indiana University, rainy and cold. Knight didn’t want to go through another season like he did before and he was going to do whatever it takes to make sure that it would never happen again. He just got done coaching maybe the best Olympic team in history to a losing season with IU. This chapter pretty much talks about what Knight was going to do to prevent the season from going under to the interdiction of the players and how Knights practices were. This chapter like its title describes Knights ever so close ballet with the brink of going under again. Chapter two is about his coming to coach the Olympic team to the end of that and the reactions Knight got through his outburst as a coach. From just screaming at officials and players, to tossing a chair in the middle of a game that nearly cost him his career this chapter is mainly about the rise and fall of Knight before the season to come. Chapter three starts off right before the off season is about to start with the team practicing to fix what happened the year before and although Knight would never admit it that season changed him for the rest of his career. Also in this chapter the team goes on a trip to play exhibition games overseas. Chapter four starts off on October 15 and this is the most important day for college basketball because now the coaches can be on the...

Words: 648 - Pages: 3

Free Essay

Tatanic

...The Aftermath of the Titanic Ifiok O Ekong November 5, 2012 Abstract The “unsinkable” mother of all ships was a massive palace with intentions to stay afloat for days even in a worst case scenario. She was almost 900 feet long and almost 11 stories high, but in less than four hours, years of investment came to an end. Clearly an investigation to mitigate future disaster unfolded and the results were mind blowing. ”In the construction of the Titanic no limit of cost circumscribed their endeavor, and when this vessel took its place at the head of the line every modern improvement in shipbuilding was supposed to have been realized; so confident were they that both owner and builder were eager to go upon the trial trip; no sufficient tests were made of boilers or bulkheads or gearing or equipment, and no life-saving or signal devices were reviewed; officers and crew were strangers to one another and passengers to both; neither was familiar with the vessel or its implements or tools; no drill or station practice or helpful discipline disturbed the tranquility of that voyage, and when the crisis came a state of absolute unpreparedness stupefied both passengers and crew, and in their despair the ship went down, carrying as needless a sacrifice of noble women and brave men as ever clustered about the Judgment Seat in any single moment of passing time”. (Smith. 1912). Recommendation from the investigation panel was suggested, with stringent declaration. According to Senator Raynor...

Words: 1489 - Pages: 6

Free Essay

Pride Comes Before a Fall

...LIST 2 : QNS 4 The source of the phrase "pride comes before the fall" is the Bible, specifically Proverbs 16:18, which reads, "Pride goes before destruction, a haughty spirit before a fall" in the New International Version. Some Bible scholars understand this verse to mean that God will discipline pride by causing or allowing events to produce humility in a person, while others simply note that pride produces carelessness that can lead to serious errors. Whichever belief a person holds, someone who says "pride comes before the fall" usually means it as a warning that someone thinks too highly of himself or herself, and that the person in question will soon experience negative consequences because of this overconfidence. History is full of examples when this adage has played out. Several famous battles are said to have ended in defeat because military leaders' overconfidence caused them attempt foolhardy attacks. Business leaders have made unethical and illegal decisions, thinking they will not be caught, only to lose their jobs or land in prison. In these cases and countless others, pride went before destruction and a haughty spirit before a fall. Once when I was younger I came across this book entitled “Aesop’s Fables” and there was one that was titled, “The Fighting Cocks and the Eagle”. The story goes like this: Two game cocks were fighting fiercely to be king of the farmyard. One finally gained advantage and the other surrendered. The losing Cock slunk away and hid...

Words: 1072 - Pages: 5

Premium Essay

Who Is To Blame The Titanic

...RMS Titanic, some of you may know what this is some of you may not. The Titanic was the most famous ship to ever sail, mainly because it sank. In the early morning of April 15th 1912 the Titanic hit an iceberg during it´s maiden voyage. In about two and a half hours she sunk in the Atlantic Ocean at a depth of around 12,500 feet deep, killing 1,500 people. Only an estimate of 712 survived. On September 20th, 1911 the Olympic, the Titanic's sister ship, had a very serious collision with the HMS Hawke just off the coast of the Isle of Wight. This collision had caused a lot of problems for the White Star Line as it meant the Olympic was out of service until ruinously expensive repairs were made. This meant that the Titanic's maiden voyage was postponed, which lead to a loss of profit that they needed to make up. Is it possible that the owners of the ships switched them and sunk the "Titanic" purposely? The only people who...

Words: 386 - Pages: 2

Premium Essay

A Brief Summary Of Deborah Hopkinson's The Voices From The Disaster

... In the spring of 1912, the infamous Titanic accident had occurred and many people like, Deborah Hopkinson, wrote books about the event. Deborah Hopkinson wrote the Sibert Medal-winning book, The Voices from the Disaster, and it was very factual but some things could have been improved. The Voices of the Disaster could be better by going into more details, clarifying confusion, and explaining. Talking more about the suction pull and why the rescue symbol was changed would help intrigue readers. Deborah Hopkinson would have written an even better book if more details and explanations were included. If Deborah Hopkinson had explained more about certain events readers would be more interested. For example, when the passengers were in lifeboats they were talking about the suction pull, but she did not explain what it was. It turns out that the suction pull is actually a false theory. The theory is that when a boat sinks it will suck down anything nearby with it to fill the space where the boat once was. The reason behind something nearby sinking down after a ship is because the air trapped inside escapes in large bubbles. An object cannot float above bubbles, therefore it will sink, and there is no suction pull. Readers would enjoy this book better if they understood it more and adding details on things like the suction pull would offer that. Details are very important, especially when writing a book, so if Deborah Hopkinson included more details her book would stand out from the...

Words: 556 - Pages: 3