1:17 PM Keep in mind that some students have joined more than one intramural tea

Question

1:17 PM Keep in mind that some students have joined more than one intramural team in different sports. When John needs to schedule games or tournaments, he uses a large wall calendar to record the name of the sport, the names of the teams, and the time of day and venue where the event will occur. When the event is team s name on the same calendar Once a good database is designed and implemented, John can envision plenty of information he can glean from the system. For example, John often has wanted a list of all students who have not had a medical exam. You suggest that a query will answer that question. In addition, the team captains constantly ask for arn updated list of their team members and their phone numbers. This list often must be printed immediately before a game because students join and quit intramural teams frequently. You suggest that a parameter query could be effective in this situation; the captain could enter his teante color and get a current listing of team members. John is curious to know how long each game lasts, because he has received some comments about long games. He would also like to know how many students are on each team. Again, you realize that the answers to both questions could be captured by queries. John would also like to be able to add students to teams and remove them from teams. You tell John that a form and subform could be used for additions, and that a delete query would be appropriate to remove a student from a team. Finally, you suggest creating a report that displays the amount of time each referee has worked in intramural games. John can use this information to thank the refs by giving them awards, gifts, or pay In this assignment you will design your database tables using a word-processing program. Pay close attention to the tables logic and structure. Do not start developing your Access code in Assignment 2 before getting feedback from your instructor on Assignment 1. Keep in mind that you will need to examine the requirements in Assignment 2 to design your fields and tables properly. It is good programming practice to look at the required outputs before beginning your design. When designing the database, observe the following guidelines: First, determine the tables you will need by listing the name of each table and the fields it should contain. Avoid data redundancy. Do not create a field if it can be created by acalculated field in a query You will need a transaction table. Although no money is changing hands in this system, events are occurring, and they are considered transactions. Avoid duplicating data. Consider using a logical field to note whether each student has had a medical exam. Document your tables using the table feature of your word processor. Your tables should resemble the format shown in Figure 3-1 You must mark the appropriate key field(s) by entering an asterisk (*) next to the field name. Keep in mind that some tables might need a compound primary key to uniquely identify a record within a table. 1 Print the database design. Data Type (text, numeric, currency, etc) your design approved before begihning Assignment 2 otherwise, you may need to redo Assignment 2.

Explanation / Answer

public abstract class ActionObject { protected Map mMapOriginAttribute = new ConcurrentHashMap(); protected Map mMapAttribute = new ConcurrentHashMap(); protected Map mMapEnvironment; protected IRapidView mRapidView = null; protected String mActionTag; protected Object retObj = null; public ActionObject(Element element, Map mapEnv){ mMapEnvironment = mapEnv; initAttribute(element); } public boolean callRun(){ boolean bRet; RapidParserObject obj; translateAttribute(); bRet = run(); obj = getParser(); if( retObj != null && obj != null ){ try { obj.getBinder().update(getActionName() + "_run_ret", new Var(retObj)); } catch (Throwable throwable) { throwable.printStackTrace(); } } return bRet; } public void setRapidView(IRapidView rapidView){ mRapidView = rapidView; } public String getActionName(){ return mActionTag.toLowerCase(); } private void initAttribute(Element element){ if( element == null ){ return; } NamedNodeMap mapAttrs = element.getAttributes(); mMapOriginAttribute.clear(); for( int i = 0; i

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.