Database Design - 2nd Edition covers database systems and database design concepts. New to this edition are SQL info, additional examples, key terms and review exercises at the end of each chapter.

Students discover how engineers can use biomimicry to enhance their designs. They learn how careful observation of nature becoming a nature detective, so to speak can lead to new innovations and products. In this activity, students reverse engineer a flower to glean design ideas for new products.

Students use their creative skills to determine a way to safely mail raw (dry, uncooked) spaghetti using only the provided materials. To test the packing designs, the spaghetti is mailed through the postal system and evaluated after delivery.

Students practice the initial steps involved in an engineering design challenge. They begin by reviewing the steps of the engineering design loop and discussing the client need for the project. Next, they identify a relevant context, define the problem within their design teams, and examine the project's requirements and constraints. (Note: Conduct this activity in the context of a design project that students are working on, which could be a challenge determined by the teacher, brainstormed with the class, or the example project challenge provided [to design a prosthetic arm that can perform a mechanical function].)

Through Internet research, patent research, standards and codes research, user interviews (if possible) and other techniques (idea web, reverse engineering), students further develop the context for their design challenge. In subsequent activities, the design teams use this body of knowledge about the problem to generate product design ideas. (Note: Conduct this activity in the context of a design project that students are working on, which could be a challenge determined by the teacher, brainstormed with the class, or the example project challenge provided [to design a prosthetic arm that can perform a mechanical function]. This activity is Step 2 in a series of six that guide students through the engineering design loop.)

Brainstorming is a team creativity activity that helps generate a large number of potential solutions to a problem. In this activity, students participate in a group brainstorming activity to generate possible solutions to their engineering design challenge. Students learn brainstorming guidelines and practice within their teams to create a poster of ideas. The posters are used in a large group critiquing activity that ultimately helps student teams create a design project outline. (Note: Conduct this activity in the context of a design project that students are working on; this activity is Step 3 in a series of six that guide students through the engineering design loop.)

Engineering analysis distinguishes true engineering design from "tinkering." In this activity, students are guided through an example engineering analysis scenario for a scooter. Then they perform a similar analysis on the design solutions they brainstormed in the previous activity in this unit. At activity conclusion, students should be able to defend one most-promising possible solution to their design challenge. (Note: Conduct this activity in the context of a design project that students are working on; this activity is Step 4 in a series of six that guide students through the engineering design loop.)

Students learn about the manufacturing phase of the engineering design process. They start by building prototypes, which is a special type of model used to test new design ideas. Students gain experience using a variety of simple building materials, such as foam core board, balsa wood, cardstock and hot glue. They present their prototypes to the class for user testing and create prototype iterations based on feedback. (Note: Conduct this activity in the context of a design project that students are working on; this activity is Step 5 in a series of six that guide students through the engineering design loop.)

As students learn more about the manufacturing process, they use the final prototypes created in the previous activity to evaluate, design and manufacture final products. Teams work with more advanced materials and tools, such as plywood, Plexiglas, metals, epoxies, welding materials and machining tools. (Note: Conduct this activity in the context of a design project that students are working on; this activity is Step 6 in a series of six that guide students through the engineering design loop.)

Student teams design and create LEGO® structures to house and protect temperature sensors. They leave their structures in undisturbed locations for a week, and regularly check and chart the temperatures. This activity engages students in the design and analysis aspects of engineering.

Engineer and cartoonist Rube Goldberg is famous for his crazy machines that accomplish everyday tasks in overly complicated ways. Students use their new understanding of types of simple machines to design and build their own Rube Goldberg machines that perform simple tasks in no less than 10 steps.

Students are given a biomedical engineering challenge, which they solve while following the steps of the engineering design process. In a design lab environment, student groups design, create and test prototype devices that help people using crutches carry things, such as books and school supplies. The assistive devices must meet a list of constraints, including a device weight limit and minimum load capacity. Students use various hand and power tools to fabricate the devices. They test the practicality of their designs by loading them with objects and then using the modified crutches in the school hallways and classrooms.

After a discussion about what a parachute is and how it works, students create parachutes using different materials that they think will work best. They test their designs, and then contribute to a class discussion (and possible journal writing) to report which paper materials worked best.

Students design and build a model city powered by the sun! They learn about the benefits of solar power, and how architectural and building engineers integrate photovoltaic panels into the design of buildings.

Student teams use their knowledge about ancient Egypt to design playgrounds for Egyptian children. This involves brainstorming ideas on paper, building models with LEGO® bricks or other materials, and explaining their ideas to the class in five-minute presentations.

In this two-part activity, students design and build Rube Goldberg machines. This open-ended challenge employs the engineering design process and may have a pre-determined purpose, such as rolling a marble into a cup from a distance, or let students decide the purposes.

Students learn about the types of possible loads, how to calculate ultimate load combinations, and investigate the different sizes for the beams (girders) and columns (piers) of simple bridge design. Students learn the steps that engineers use to design bridges: understanding the problem, determining the potential bridge loads, calculating the highest possible load, and calculating the amount of material needed to resist the loads.

Students are introduced to engineering, specifically to biomedical engineering and the engineering design process, through a short lecture and an associated hands-on activity in which they design their own medical devices for retrieving foreign bodies from the ear canal. Through the lesson, they learn the basics of ear anatomy and how ear infections occur and are treated. Besides antibiotic treatment, the most common treatment for chronic ear infections is the insertion of ear tubes to drain fluid from the middle ear space to relieve pressure on the ear drum. Medical devices for this procedure, a very common children's surgery, are limited, sometimes resulting in unnecessary complications from a simple procedure. Thus, biomedical engineers must think creatively to develop new solutions (that is, new and improved medical devices/instruments) for inserting ear tubes into the ear drum. The class learns the engineering design process from this ear tube example of a medical device design problem. In the associated activity, students explore biomedical engineering on their own by designing prototype medical devices to solve another ear problem commonly experienced by children: the lodging of a foreign body (such as a pebble, bead or popcorn kernel) in the ear canal. The activity concludes by teams sharing and verbally analyzing their devices.

Students learn the engineering design process by following the steps, from problem identification to designing a device and evaluating its efficacy and areas for improvement. A quick story at the beginning of the activity sets up the challenge: A small child put a pebble in his ear and we don't know how to get it out! Acting as biomedical engineers, students are asked to design a device to remove it. Each student pair is provided with a model ear canal and a variety of classroom materials. A worksheet guides the design process as students create devices and attempt to extract pebbles from the ear canal.

Student teams create laparoscopic surgical robots designed to reduce the invasiveness of diagnosing endometriosis and investigate how the disease forms and spreads. Using a synthetic abdominal cavity simulator, students test and iterate their remotely controlled, camera-toting prototype devices, which must fit through small incisions, inspect the organs and tissue for disease, obtain biopsies, and monitor via ongoing wireless image-taking. Note: This activity is the core design project for a semester-long, three-credit high school engineering course. Refer to the associated curricular unit for preparatory lessons and activities.