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…

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…

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…

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…

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…

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…

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…

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…

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…

  Define the following;axis, lines, intercepts, equilibrium positions The post Macroeconomics. first appeared on COMPLIANT PAPERS.