...DATABASE ASSIGNEMENT ONLINE STORE DATABSE TABLE NAME * STUDENT/CUSTOMER * ENROLLMENT * COURSES * CATEGORY * ORDERS * ORDER DETAILS * PAYMENT * PRODUCT * SHIPPERS * SUPPLIER/COMPANY TABLES ATTRIBUTES STUDENT/CUSTOMER STUDENT table contain attribute such as: * STUDENT ID-PRIMARY KEY * FIRST NAME * LAST NAME * ADDRESS * POSTAL CODE * CITY * STATE * COUNTRY * PHONE * EMAIL * PASSWORD * CREDIT CARD * CREDIT CARD TYPE ID * BILLING ADDRESS * SHIP ADDRESS * DATE ENTERED ENROLLMENT ENROLLMENT table contain attribute such as: * STU ID-PRIMARY KEY * COURSE ID-PRIMARY KEY * SEMESTER-PRIMARY KEY * INTAKE COURSES COURSE table contain attribute such as: * COURSE ID-PRIMARY KEY * COURSE NAME * FACULTY CATEGORY CATEGORY table contain attribute such as: * CATEGORY ID-PRIMARY KEY * CATEGORY NAME * DESCRIPTION * PICTURE * ACTIVE ORDERS ORDERS table contain attribute such as: * ORDER ID * STUDENT ID * PAYMENT ID * SHIPPER ID * ORDER NUMBER * ORDER DATE * SHIPDATE * REQUIRED DATE * SALE TAX * TIME STAMP * TRANSACTION STATUS * FULFILED * DELETED * PAID * PAYMENT DATE ORDER DETAILS ORDERDATAILS table contain attribute such as: * ORDER IDs-PRIMARY KEY * PRODUCT IDs * ORDER NUMBER * PRICE * QUANTITY * DISCOUNT * TOTAL * IDSKU *...
Words: 289 - Pages: 2
.... Introduction top next gema actions are enough for everyday usage but occasionally you may need more power to define a complex transformation. You might, also, want to use the superior matching capabilities of gema to drive your program. GeL is a Lua 5 library that: allows the execution of Lua function (and hence of a C function) in a gema action provides the powerful text matching mechanisms offered by gema as a set of Lua functions it has been tested with Lua 5.0.2. Refer to the detailed documentation to build gel togheter with gema, . 1.1 Status GeL is not as mature as gema or Lua, please report any bugs you may find using SourceForge bug tracking subsystem (you don't need to log in as a SourceForge user) or sending an e-mail to Remo Dentato. 1.2 Licence GeL is released under the same licence of Gema. No specific reference needs to be made to GeL as long as the due reference to Gema and Lua have been made. 2. Usage prev top next 2.1 Gema like Gel may be used exactly as if it was gema, any valid gema script should work when executed by gel: gel [gemaopts] [-f rules.gema] [-l script.lua] [infile [outfile]] . The only differences are: The @lua{} function is available to execute lua scripts in actions Text enclosed between "![" and "!]" is considered lua code and is immediately executed Rules specfied with '-f' are loaded, the lua script specified with '-l' is executed (possibily defining lua function...
Words: 1294 - Pages: 6
...experience. My seminar topic was about examining the imagery that appeared in the play Hamlet. A skill I developed was using technological equipment to present a presentation.Each group had to pick a topic that was in their interest to research online for information. The requirements started with presenting the information in front of the class informing the audience what imagery means and discuss using concrete examples from the play. This presentation gave me the opportunity to work with PowerPoint and Excel and then to present my information. I believe that in order to communicate effectively with the audience you have to have a well prepared presentation that will capture their attention so that you can present your ideas clearly. A skill that I had trouble was to be able to work as a team. The imagery seminar was a great opportunity for me to develop my team work skills because we were put in to pairs to complete the seminar. Each member in the group had specific responsibilities to the team in order for the seminar to be successful. Being in the group to work on the seminar was a great experience for me because I was able to see where my strong and weak points are in group work. I found that it was easier for me to communicate my ideas with Rachna than to the whole class. A big part of group work is good communication between Rachna and I. Communication is also a big part of my learning experience because I will need to be able to get my ideas out by communicating well...
Words: 585 - Pages: 3
...Inequalities Thomas Cunningham MAT221: Introduction to Algebra (GSO13360) Instructor: Justin Hazel Inequalities In this assignment I will be showing you how you can find out how to use Inequalities to find out how much you may or may not be overweight. You can use my equations and the examples of my work to find out exactly what category you might fall in. In this equation we are asked to use our own height to find out exactly if I might have a longer life span than the usual person. Before we start remember that W=my weight, and then H=my height. W=178.2 and then H=67 In this first compound inequality, I had to take the equivalent inequality and replace it with the BMI formula. My height and weight has been added in to replace the current H^. The next steps for this compound inequality I had to multiply all the terms by the denominator. There was some cancellation done towards the first phase of the problem. I then all three terms where divided by 703 to isolate W. People’s height of 67 might be different life span of those whom might weigh between 108lbs and 128lbs. 17<BMI<=22 17<703W/67^<22 17<703W/4489<22 17(4489) <703W<22(4489) 76313<703W<8978 76313/703<8978/703 108<W<128 In order to solve this second inequality, what I need to do is solve for W and place the values of W. The very first thing that happens is I multiply all the terms by H^ in order to take out...
Words: 542 - Pages: 3
...to be successful in terms of assistance in these particular areas. Matrix organizations are kinds of structures that a categorized flexible and responsive and are characterized by employees having more than one supervisor and in order for them to perform at their highest level of productivity, they must have some area of expertise that is disciplined. The project team happens to become a creation of several highly imaginatively intelligent groups of people that are formed to collaborate with each other and strive at creating more diverse ideas, or putting a different take on some of the many already formed ideas and the opinions of those more diverse ideas. The collegial model works flawlessly when each member is able to be independent, but equally share management responsibilities or work out a specific rotation that meets each individuals peer or colleagues needs. The need or want for freedom or independence in the aforementioned paragraph has little merit when they must come together to satisfy matters that affect the entire group....
Words: 270 - Pages: 2
...the initial stage of a team. In this part a team gets formed and the members of the team get through the icebreaking process. Forming is a stage in which group members try to assess ground rules applying to a task and to group interaction (Bartol et al., 2005, p.476). In the first tutorial of organisation and management, all the team members were unfamiliar and unknown to each other. There was diversity because students of many nations and cultures came together. Everyone was confused about what to do. There was no one who wanted to be the first spokesperson. In this situation team members were all divided into some little groups to complete the first tutorial task. As every team member were unknown to each other, one of the team members spoke out and discussed the tutorial task. After that everyone started to contribute and gave ideas, with that the group was working very effectively. Members completed the task and then submitted it to their tutor. In the first tutorial the team members were totally unclear about the team goals. Individuals did not know what their role in the team is. Some students were really nervous as they were not able to cope up with the other team members. It was a negative site of the team, as the team was not able to work effectively. After selecting the team leader the team was divided into sub-groups like- Marketing, Public Relation, Finance and IT. All the students...
Words: 252 - Pages: 2
...Lab 5.1 The Condition | True or False | attAverage >= verizonAverage | True | tmobileAverage == 868 | True | verizonAverage < sprintAverage | False | sprintAverage != attAverage | True | Lab 5.2 The Condition | Expected Output | If tmobileAverage > 800 AND verizonAverage> 800 ThenDisplay “Both have average downloadrates over 800”ElseDisplay “One or both of the averagesare less”End If | Both average download Rates over 800 | If sprintAverage == 800 ThenDisplay “Sprints download rate is 800”End If | No display | If attAverage >= 1300 OR tmobileAverage>=900Display “Select either carrier”End If | Select either carrier | Lab 5.3 Main Module() //Declare variables on the next 3 lines Declare Integer testScore = 0 Declare String category = “ “ Declare String interview = “ “ //Make Module calls and pass necessary variables on the next 4 lines Call getScore(testScore) Call employCat(testScore, category) Call interviewPoss(testScore, interview) Call displayInfo(testScore, category, interview) End Main Module getScore(Integer Ref testScore) //Ask user to test score Display “Please enter test score” Input testScore End Module Module employCat(Integer testScore, String ref category) //Determine what employment category they are in based on their test score //Similar to if the score is less than 60, then category is “No” //Otherwise, if score is less than 70, then category is “Maybe” //…and so on if testScore => 85 then Set...
Words: 288 - Pages: 2
...PDC Dull Grading System Inner 1 Outer 2 Dull Char 3 Location 4 Bearing Seals 5 Gauge 6 Other Dull Char 7 Reason Pulled 8 1: Inner Cutting Structure 2: Outer Cutting Structure 3: Primary Dull Characteristic 4: Location of Primary Characteristic 5: Bearing Seals (XXX for PDC. Only used for roller cone) 6: Amount Under Gauge 7: Other / Secondary Dull Characteristic 8: Reason Bit Was Pulled Inner & Outer Cutting Structure • • Rating for both inner and outer cutting structure is given in a scale of 1 to 8. A rating of 1 states that 1/8 of the cutter’s diamond table has been worn. A rating of 8 would mean that there is no effective diamond table left. An average rating for both the inner and outer cutting structure is entered for the first 2 positions of the dull grading code. • Inner & Outer Cutting Structure Outer Inner The inner cutting structure consists of the inner 2/3 of the bit diameter whereas the outer consists of the final 1/3. A general rule of thumb is the inner number represents the cutters inside the nose and the outer represents those outside. Inner & Outer Cutting Structure Rating: Wear 8 7 6 5 4 3 2 1 When dull grading pure wear, the 1 through 8 rating system can be followed exactly. However, in many cases, a wear flat less than 1/8 of the diamond table can be called a 1. Inner & Outer Cutting Structure Chipping Spalling Delam 2 3 8 When dull grading cutters with characteristics other than pure wear, take into...
Words: 857 - Pages: 4
...1. Introduction - What are the major issues and problems facing Chabot? Background – current situation – future plan - challenges confronted – problems need to be solved Chabot is facing a lot of issues and problems in the wallpaper industry. As the number of wallpaper manufacturers is highly decreasing over last years the competition among remaining companies becomes fiercer. Some manufacturers face difficulties supplying large and powerful retailers. So does Chabot as a privately owned, small company selling products with short life cycles and highly valued at a reasonable price. Due to fashion orientated product industry and broad range of product preferences other types of wall covering are favored by consumers as well. To keep up with competitors Chabot is providing new items every 4 month but speeds up obsolete wallpapers as well. When wallpaper pattern and designs become obsolete, markdowns are necessary to help get rid of old inventory. Problems with inventory turnover lead to mark downs which decrease profits. Caused by inaccurate demand forecasting Chabot has to deal with a high amount of obsolete inventory and a resulting low turnover rate. Since customers base their decisions on style and appeal of the design as well as on in stock availability retailer want low inventory and expect quick order fulfillment. But Chabot cannot keep up with demand and causing a low level of customer service due to long production runs and lack of flexibility in manufacturing process...
Words: 427 - Pages: 2
...2: Unwrapping ISLLC Standard 1 This week’s assignment was very interesting. I had not participated in an unwrapping activity since a workshop I attended in 2004. At the beginning of the exercise I was worried about being a part of an online team. I was especially wary of using the online group forum for coordinating the completion of the group project. I am, by nature, a worrier, but I should not have been stressed. The team quickly responded to my original message, we exchanged numbers, divided the assignment into manageable pieces, and one teammate volunteered to put the assignment together. At first, I was confused with the requirements, but after receiving guidance from the professor, I understood the expectations. Once the parameters of the assignment were agreed upon and set, everyone has met the established deadlines. I view this exercise as basic-training for when I am charged with larger projects as an administrator and I fully expect that the personality conflicts and obstacles to the effective completion of the assignments will be repeated in future projects. The leadership skills acquired as a part of the cooperative learning group will translate and be useful in my future role as an administrator. For the future, I need to trust the established protocols for completing scheduled tasks. Although I am quick to take on leadership responsibilities, I need to resist the urge to reinvent the wheel. I need to acknowledge that in a long-standing...
Words: 282 - Pages: 2
...Program Description: This program will calculate all of the useable area (in square feet) in a house. This specific house contains four rooms, all of which are rectangular in shape. Analysis: My goal in creating this program is that it successfully calculates the useable square footage in a house that contains four rooms. The values which are required to perform the calculations will be the length of room 1 times the width of room 1(in feet). This will give the area of room one, which will in turn become the useable area for this particular room. The same length times width (L x W) formula will then be used for all subsequent rooms. After the area for all four rooms has been found, the sum of the area of each room will be the final output for useable square feet. The output values are as follows: * L1: The length for room 1 * W1: The width for room 1 * L2: The length for room 2 * W2: The width for room 2 * L3: The length for room 3 * W3: The width for room 3 * L4: The length for room 4 * W4: The width for room 4 * T1: Total square feet for room 1 * T2: Total square feet for room 2 * T3: Total square feet for room 3 * T4: Total square feet for room 4 * Total_SqFt: Total useable square footage in the house Test Plan: Test Case # | Input | Expected Output | 1 | Room 1 - Length:20 Width:14Room 2: - Length:16 Width:12Room 3: - Length:22 Width:16Room 4: - Length:12 Width:10 | Square Feet: 944 | 2 | Room 1 -...
Words: 653 - Pages: 3
...Group Assignment 1 Visit the study group section and introduce yourself; also provide your schedule for keeping in touch. Discuss how to approach completing project 1 based on the social media for which your team will be the class leader. Every study group member should sign up for a social medium, connect with his or her study group, and start to communicate. Social Media Assignments * Study Group 1: Facebook * Study Group 2: Farmville * Study Group 3: Twitter * Study Group 4: YouTube * Study Group 5: FourSquare * Study Group 6: Pinterest ● The study group will be the leaders in connecting the class on the selected medium, using the applicable weekly conference and start-off communications using these techniques. ● The study group will write a three- to five-page paper on the contribution the selected social medium has made to e-marketing, providing recommendations on ways this contribution can be increased. ● Use ideas from study and class group discussions, modules 1-4, our textbook, and Internet research sources to help justify your assessment and recommendations. ● Use your instructor as a consultant during your project. The paper should consist of a contribution of a minimum of one typed page per study group member, including citations, along with a group-developed executive summary and comprehensive reference section at the end with at least 6 total references. As an example, with a four-person study group, the paper should be a minimum of...
Words: 706 - Pages: 3
...difference with the matrix organization, which is a big disadvantage, is that there are two bosses instead of one. There is a functional boss and a divisional boss (Bateman & Snell, 2011.) With having two bosses it uses what is called a Unity-of-Command principle which is a structure where the employees report to one boss who reports to one boss and so on until it gets to upper management (Bateman & Snell, 2011.) This is where the disadvantage of the matrix organization is, by having too many people in the line while information is being relayed it can lead to misinterpretation by the time it reaches upper management which is why the two boss part of the matrix organization is such a big disadvantage. Functional organizations group employees by the skills that are needed to complete certain jobs. The functional organization is a structure that is best in a stable environment (Bateman & Snell, 2011.) The company is not a stable environment there needs to be a lot of flexibility in the company in order to meet the demands of the numerous customers that we deal with on a weekly basis. Also the functional...
Words: 966 - Pages: 4
...If a business wants to determine the optimale replenishment lot size, the use of the Economic Production Lot Model can be used. This model is a variation of the EOQ Model. This model procides the most optimied approach of ordering as it considers, demand, available production, ordering cost, set up costs, and holding costs in order to develop the inventory to be ordered to maintain a minimum annual cost (Rendoer 2012). Company B Details Holding Rate: 6% HR: Holding Rate Demand Units Per Year: 15,470,000 D: Demand Expected Production: 910,000 EP: Expected Production Production Cost Per Unit: $400.00 UPC: Unit Production Cost Inventory Cost Per Unit: $200.00 ICPU: Inventory Cost Per Unit *Holding Cost: $12.00 HC: Holding Cost * The holding cost is the per unit cost of inventory multiplied by the holding cost rate $200(.06) = $12.00 Process Description: The optimal lot size per order is equal to the square root of the equation of the annual demand (D). It is multiplied by 2, then multiplied by the production set up cost (UPC). Which is then divided by the holding cost (HC). Then demand (D) divided by epected production (EP), then subtracted by 1. The end result of the equation provides the optimal lot size order. The Equation: You must follow the mathmatical order of operations; simplify and solve - numerator divided by the demoniator...
Words: 256 - Pages: 2
...continental divisions. * Eurasia & Africa Group * Europe Group * Latin America Group * North America Group * Pacific Group Each Continental division has vice presidents that control sub-divisions based on regions or countries. This structure is efficient for Coca-Cola since it is a very large company. * How do they operate? Coca-Cola is as an ethnocentric MNC because its domestic operations are very similar to its international operations. Regardless of the country or region, Coca-Cola operates the same way and sells the same brand and type of soft drink. The company has tight control over its operations from head office. * Does the organization have divisional managers? There are divisional managers, head of each regional division. Functional managers are head of human resources, innovation and development, marketing and public affairs. The knowledge gained from doing this will give the organization a better understanding of its bottling partners. * Specialization and Coordination: * Multi visional structure allows divisional managers to handle daily operations while operating managers are free to follow long term planning. * A multidivisional matrix structure may be better suited for the coca-cola company. This would increase coordination between corporate and at all levels to create a solution to a problem. * Organizational Design * Two operating groups: bottling investment and corporate. Divided by different...
Words: 424 - Pages: 2
