Homework assignment website: The Somerton High School PTO is creating a website that will allow students to quickly look up their homework assignments. The database supporting this website will keep track of departments, teachers, classes, and assignments. Each department has a name such as “math,” “science,” or “English,” and each teacher is a member of … Read more
Law office: You are trying to automate the records for your uncle’s law firm. Multiple attorneys work for the firm, and for each of them you want to store their first name, middle name, last name, date hired, hourly billing rate, and date promoted to partner (blank if the attorney is not a partner). For … Read more
Alumni office: The alumni office of Enormous State University (ESU) wants to keep track of alumni and their charitable gifts to the university. For each alumnus, you want to store a first name, middle name, last name, address information (street address, city, state, and zip code), a home phone number, a mobile phone number, and … Read more
Law office: You are trying to automate the records for your uncle’s law firm. Multiple attorneys work for the firm, and for each of them you want to store their first name, middle name, last name, date hired, hourly billing rate, and date promoted to partner (blank if the attorney is not a partner). For … Read more
Tour operator: You manage a tour company that operates tours of local historical and natural attractions. You have several dozen different tour packages, each with a name (such as “Exploring Native Ruins” or “Bird‐ Watching Hike”), a scheduled duration in minutes, a per‐guest price, and a maximum number of guests. You also have a staff … Read more
Compatibility of auto parts: Zip Guys, Inc., runs a large network of auto part stores. Each part they offer for sale is identified by an SKU code assigned by Zip Guys. For each part, they want to store the part manufacturer name, a manufacturer’s part number, a unit price, and the associated part type; each … Read more
EcoBus Corporation: EcoBus Corporation makes hybrid natural‐ gas‐fueled buses for various clients, including city, state, and county transit authorities. This database is concerned with the ordering of buses. EcoBus currently has dozens of basic bus models, each of which has a unique model number, along with a length, width, height, basic gross weight, and list … Read more
People and student clubs at a university: Every person affiliated with Giant State University (GSU), be they a student, faculty member, or staff member, has a university ID card with a unique ID number. For every affiliated person, the university database stores a family name and given name, the person’s gender, a postal address consisting … Read more
Catering menu and orders: You operate a commercial catering business serving conferences and other similar events. For each dish on your menu, you want to store a name, description, and number of calories per serving. You do not charge customers by the individual dish, but by menu package (in the market niche you serve, your … Read more
Define the following;axis, lines, intercepts, equilibrium positions The post Macroeconomics. first appeared on COMPLIANT PAPERS.
