Material Package Management Systems

Question: If you can give me the answer of the any following queston,Give .? Q .1New City Studio Records company has decided to store information about musicians who perform on its albums (as well as other company data) in a database. The company has wisely chosen to hire you as a database designer. •Each musician that records at the company has an SSN, a name, an address, and a phone number. Poorly paid musicians often share the same address, and no address has more than one phone. •Each instrument used in songs recorded at the studio has a unique identification number, a name(e.g., guitar, synthesizer,, flute) and a musical key (e.g., C, B-flat,E-flat). •Each album recorded on the Studio has a title, a copyright date, a format (e.g., CD or MC), and an album identifier. •Each song recorded at the Studio has a title and an author. •Each musician may play several instruments, and a given instrument may be played by several musicians. •Each album has a number of songs on it, but no song may appear on more than one album. •Each song is performed by one or more musicians, and a musician may perform a number of songs. •Each album has exactly one musician who acts as its producer. A musician may produce several albums, of course. Q. 2 Consider the following Relations: Student(rollno: integer, sname: string, major: string, level: string, age: integer) Class(cname: siring, meets at: string, room: string, fid: integer) Enrolled(rollno.- integer, cname: string) Faculty(fid: integer, fname: string, deptid: integer) The meaning of these relations is straightforward; for example, Enrolled has one record per student-class pair such that the student is enrolled in the class. Write the following queries in SQL. No duplicates should be printed in any of the answers. 1.Find the names of all Juniors (level = JR) who are enrolled in a class taught by Mr.Kushal. 2.Find the age of the oldest student who is either a History major or enrolled in a course taught by Ms.Indira. 3.Find the names of all classes that either meet in room R128 or have five or more students enrolled. 4.Find the names of all students who are enrolled in two classes that meet at the same time. 5.Find the names of faculty members who teach in every room in which some class is taught. (5 Marks) Q. 3Produce an E-R diagram, which documents the entities and relationships involved in the Loan Management System module of any Nationalized Bank. Create a relational schema to hold the necessary information. Identify the tables, perform normalization to the tables and fully implement the code with necessary validations using MS-Access / FOXPRO / DBASE or any other similar package. Provide necessary documentation and coding for the project. Q4 Design a multimedia package that helps in teaching: “Control Statements in C Programming�. You must follow the standard methodology for development of multimedia. You must fill up various templates required for the development of Multimedia. (Refer Unit 4 of your CS-66 course material) Present a prototype of your design using MS-Office tools. Your multimedia package should include at least 10 slides having suitable graphics, simple animation and few audio clips. (Audio clips need not be recorded professionally but can be recorded using built in microphone of simple multimedia computer. Make assumptions wherever necessary. Q5 Construct an E-R diagram for attendance maintenance system for BCA. Create 1st Normal Form tables from the ER diagram. Identify all the functional dependencies and normalize your table design to 3rd Normal Form. Make and state suitable assumptions, if any. Q5 Construct an E-R diagram for attendance maintenance system for BCA. Create 1st Normal Form tables from the ER diagram. Identify all the functional dependencies and normalize your table design to 3rd Normal Form. Make and state suitable assumptions, if any.Q6

Answer: Don't post your homework. No body is interested to work on your behalf. Do it yourself. ______________________________ www.opensourcenuts.com

Question: Why do Jollibee & Mc Donalds keep using disposable materials when waste disposal is a big problem in Manila? Waste management is a big problem ever since in Metro Manila. Some cities even dump their wastes on nearby provinces. Styrofoam, plastic cups and other familiar packaging from these fast food chains have dominated the rivers and not so 'sytemized' sewerage systems in MM. Some fast food chains serve food on plates and uses glasses but these famous fast food chains do not, and they have a big share of garbage from MM everyday and counting.

Answer: My guess is that there are no environmental regulations in place, and using styrofoam is cheaper. You can show your disapproval with your dollars by refusing to eat there. Maybe tell your local media to do an expose to draw public attention to the matter.

Question: Is this text OK in english? This report describes the standardization of information and physical flows of a raw material store. This standardization makes the processes reliable in order to avoid mismanagement, but also reduce the time associated with storage. A study on supply methods can also reduce the stock level. The changes are necessary to achieve the ultimate goal of implementing a bar code system. This report also studying the implementation of an ERP software. It also imposes a standardization of packaging and proper management of products not listed. This report is published in order to investigate the phenomena which resulting in a shift of lines during their impression process on the paper. The study shows the correlation between the various mechanical defects involving impression problems on the finished product. Studies conducted during the project are classified in different theme such as mechanic, mechanical vibration or electrical engineering.

Answer: Don't listen to George. The reason none of us understand it is because we're not engineers, but it's pretty much fine in terms of English. This report is published in order to investigate the phenomena --> The aim of this report is to investigate the phenomena [Your version is technically correct but this sounds more proper for academic and technical reports.] the phenomena which resulting --> the phenomena which result in during their impression process on paper --> during process of impression on paper, during the process of impressing them on paper, during the process of paper impression classified in different theme --> classified in different themes [Also, theme isn't really the correct word here. Maybe you should say "classified under different categories/headings"] Otherwise, it's fine. Hope this helps!

Question: Looking for a "good" job - in the Houston Texas area as Executive Administrative Assistant....Good Company SUMMARY A high-energy team player who is a results-oriented administrative professional with comprehensive expertise in office management, event planning, telecommunications travel arrangements, corporate correspondence and reports. Serves as an effective liaison between all levels of an organization, ensuring the safety of confidential materials. Maintains the integrity of company policies and procedures by anticipating issues and preventing problems. EXPERIENCE DELOITTE & TOUCHE, LLP – Houston, Texas Administrative Assistant – 2007 Responsible for administrative functions for three Partners and staff of Auditors. Created invoices and tracking- DPS System, weekly and life to date reports (Excel). Coordinated domestic and international travel arrangements, acquired visas and passports as needed, arranged meetings, dinners and etc. to meet with clients (domestic and international). Weekly time reports and expense reports for Partners. ANADARKO PETROLEUM, The Woodlands, Texas Senior Administrative Assistant, 2001-2006 Performed daily administrative functions for the Marketing and Minerals Department, including the vice-president. Processed departmental invoices (SAP). Created Excel reports to track contract history for oilandgas abstracts. Designed presentations with PowerPoint. Developed department’s website using DreamWeaver. Coordinated domestic and international travel arrangements and daily calendars. Filed for visas and passports. • Collaborated with college recruitment team to interview students, filter resumes, prepared welcome packages, liaison with schools and the student internship. • Coordinated team-building events, award dinners, and department functions. • Composed confidentiality reports letters as well as served as liaison to upper management. NEUROBEHAVIORAL HEALTHCARE SYSTEMS, LTD, Conroe, Texas Executive Assistant, Vocational Counselor, 1992-1999 Facilitated transition from hospital setting to building long-term residential program, including residential, transitional, and vocational rehabilitation services for individuals with brain injury and neurological impairment. Worked one-on-one with clients. Supervised three assistants. Established daily routines for clients based on individual needs. Organized weekly outings in community. Attended weekly medical rounds with medical team. Participated in family meetings. Tracked behavioral programs. Developed cottage industry vocational program and designed business classes. ADDITIONAL WORK EXPERIENCE •LAWRENCE INDUSTRIES/DAILY OIL TOOLS, Conroe, Texas Executive Secretary, 1989-1992 •EXPERIENCE ENRON, Houston, Texas, Administrative Assistant III, 1987-1989 •HYDRIL, Houston, Texas, Office Executive Assistant, 1980-1987 •BAKER OIL TOOLS, Houston, Texas, Administrative Assistant COMPUTER SKILLS Microsoft Word, Excel, PowerPoint, Quicken, Money, SAP, Outlook, DreamwWeaver and DPS Personal Enjoys water sports, golf and jewelry design. Volunteers in the community and performs charity work. (Houston Livestock Show & Rodeo, Jimmy Buffet –Parrot Head, Jr. Achievement and Habitat) EDUCATION Presently working on Business Degree.

Answer: Resume looks great . I'd hire you. Good Luck in your job search!

Question: Will you please put these into paragraphs for me? I need these job experience's put into single paragraphs but I am horrible at doing this. They are... Copiers, Printers, Fax Used copy machine to make copies of order forms, packaging slips, and other paperwork. Used printers to print order forms for management and myself. Used fax machine to fax discrepensies documents and other paperwork to corporate. Physical Production Climbing up and down ladder with boxes. Stacking boxes on pallet, shrink wrapping, labeling, moving for storage. Stocking shelves with merchandise. Using conveyer to move product from upstairs to downstairs. Using cart to pick product to place on shelves in store. Unloading # boxes on UPS trailer in under 60 minutes. Sorting # boxes out of UPS trailer onto conveyer belt. Accuratly loading # boxes onto UPS package truck. Picked cabinetes and desks weighing up to 200 pounds. Shipping/Receiving Received product from shipping service and signed for it. Checked packing slip against order copy to ensure no discrepensies. Called companys about any discrepensies and fixed. Kept filling cabinet of all order copies. Signed all paperwork nessesary for warehouse. Split orders and shipped to other stores. Shipped excess discrepensies back to companies. Shipped wrong product back to companies. Inventory Management Made an inventory system that tracked all product inside of warehouse. Used LRT scanner to keep track of product count inside of warehouse. Kept track of packages loaded on package truck incase of change in delivery. Heavy Equipment Used industrial sized mowers to mow grass. Used moterized carts with hydraulic beds to transport materials. Used riding bunker raker to rake sand bunkers on golf course. Used forklift, squeeze forklift, and pallet truck to pick products. Used forklift, squeeze forklift, and pallet truck to load and unload trailers. Drove tractor at Antique Powerland festivle. Customer Service Deal with any problems that customers had with order. Returned money to customers if needed. Used phone to answer questions by customers. Checked customers orders and told them when order would arrive. Called customers to let them know if there were any problems with order. Assembley Assembled cardboard displays that held products. Assembled meteal and plastic racks that held products. Assembled wooden racks to hold products. Assembled cardboard Other Equipment Used pallet jack to to move pallets onto sales floor and to storage location. Used handtruck to move product throughout warehouse and store. Used shrinkwrap to shrinkwrap pallets for stability. Used weedeater, hedger, edger, chainsaw, and blower. Used rake, shovel, machette, and tamp. I need all of the tasks in there, nothing can be left out. Will you please help me out?

Answer: Your format will be just fine. Just make sure the category heading (Copiers, Printers, Faxes; Physical Production; Shipping Receiving, etc.) are in bold. Then make use of bullets to arrange them properly. For example: Copiers, Printers, Fax • Used copy machine to make copies of order forms, packaging slips, and other paperwork. • Used printers to print order forms for management and myself. • Used fax machine to fax discrepensies documents and other paperwork to corporate.

Question: Can write about their thoughts on how information and communications could be improved within this factory? I work for an old established engineering company which has just been sold to new owners. The new owners are concerned that the drawing office has limited CAD facilities and there is no integration with the CAM software being used by the manufacturing engineers to produce programs for the CNC machines which are cutting metal. Scrap rates in the workshop are high because CNC programs are unproven and technicians have to make numerous corrections. Within the business there are limited IT facilities and much communication is still through paper-based systems. The company’s main product line is high pressure pipe couplings for use in the aerospace, instrumentation and oil industries. The parts are machined in large quantities in a range of standard sizes using stainless steel bought in as bar stock. As raw material is used, staff manually update stock levels and reorder as required. Each week the company processes about 500 metres each of 30 mm, 40 mm, 50 mm and 60 mm hexagonal diameter bar to make approximately 35,000 couplings. The company also offers the facility to produce ‘specials’ if requested by a customer. These are manufactured in the fast response cell, and can be turned around within 36 hours of the first contact from the customer. Fast response orders are taken over the phone and confirmed by email. A drawing of the part is sent by the customer as an attachment to the email. Once the order is completed, the couplings are packaged, bar coded and despatched using a special delivery service. One problem that has been identified by the management is that when customers phone in to check on the progress of their orders — whether they be standard or fast response — there is no up-to-date information available. thanks for any help

Answer: The company needs a complete revamp of their ICT Infrastructure, the complete working system from beginning to end and delivery can be done through the network by scanning their requirements and sending to your business and by the aid of multi function network printers give the original plans, the CAD and CAM facilities needs upgrading to the CNC machines which in turn can be fully connected to the PCs which will have all the admin record available and if more that one site can be connected through the WAN or if single sited LAN - I am a marketing executive for a Global ICT company

Question: Can someone critique my resume? OBJECTIVE: To obtain a position as an Executive Assistant utilizing my executive support, project management, and computer expertise. Executive Assistant LAMARIES New York, NY •Provide support to CEO • Responsible for company-wide communications. •Prepare and manage CEO’s travel both domestic and international. •Manage CEO’s multiple households •Manage CEO’s personal expenses • Work with management to track and update various materials as needed •Answer high volume Multi-line phone system •Organize charity events •Distribute messages when appropriate •Act as a gatekeeper and develop sense of filtering calls •Order office supplies •Receive, sign and distribute packages as well as daily mail delivery •Meet and Greet high level clients while extending excellent customer service •Schedule meetings, conferences and appointments when necessary •Assist in typing memos, letters and email correspondence •Assist in Administrative duties/projects

Answer: Very thorough in regards to this particular job. You may actually want to condense it a bit- you don't want to lose the readers interest. Are you including other positions on your resume? I actually do resume edits very frequently. Feel free to email it to me (janiekatt@yahoo.com) if you want more specific edit recommendations. Good luck!

Question: What career am I best suited for? I don't want work with nonprofits or as a paralegal anymore. What career am I best suited for with my current education and work experience? And, how do I pursue a career in the industry you recommend? I'm interested in government/politics, journalism, lobbying, higher education, research, advertising, and music. I'd like a job with growth potential in an large organization with good management infrastructure (no more small companies or operations). This is my truncated resume: Director of Programs—Chamber of Commerce Develop and coordinate programs to support and improve local business. Design and draft marketing materials to publicize Chamber programs using MS Publisher, Constant Contact, and Adobe Contribute. Foster partnerships with schools, government officials, businesses, and community organizations to attain the specified goals related to each program. Legal Coordinator—The Willett Law Firm, P.A. Developed an action plan with the NC State Bar to wind-down John G. McCormick’s law practice. Assisted clients with filing grievances with the NC State Bar and finding alternate legal counsel. Legal Assistant/Paralegal—John G. McCormick, P.A. Organized and managed the firm’s accounts payable and receivable using QuickBooks and Timeshlips software. Assisted personal representatives with estate planning and settlement. Performed title and lien searches and helped to prepare closing packages for real estate transactions. High School Social Studies Teacher Taught Economic, Legal & Political Systems, which is an overview of stock market investing and micro- and macroeconomics concepts, civics, law, and a comparative study of historical and modern political and economic systems in foreign countries. Y2K Readiness Project Administrator –Quintiles, Inc. Communicated with project managers to track compliance and contingency planning. Managed and tracked project data using MS Excel. Legal Assistant–Rucci, Burnham, Carta & Edelberg, L.L.P., Helped defense prepare for a criminal trial in Puerto Rico discovery for a client charged with violating Savings and Loans regulations. Employee Assistance Program Intern–United States Tobacco Co. Education: Juris Doctorate, Campbell University Norman A. Wiggins School of Law, Two years completed Summer Program, Handong International Law School, South Korea Master of Arts in Teaching, Univ. of North Carolina, Chapel Hill, NC Bachelor of Science in History, Appalachian State Univ., Boone, NC NC State Bar Certified Paralegal Relevant Coursework: History of the World Since 1945 Germany Since 1917 U.S. Foreign Policy U.S. Intellectual Tradition Constitutional Law Islamic History Asian History Latin American History Latin American Politics American and National Government Political Parties and PACs Law & Ethics of Communications Theory & Practice of Persuasion History of American Public Education Microeconomic Theory Race, Poverty & Politics Globalization Comparative Law & Culture (U.S. v. Asian Traditions) International Business Transactions Constitutional Law Entertainment Law Education Law Contracts Torts Civil & Criminal Procedure Criminal Law

Answer: try to get into government relations department of a large (jumbo) firm?

Question: Would this help, to produce good software ? What if people avoid following the checklist ? Standard: Review Checklist Phases: Concept and Technology Development, System Development and Demonstration, and Production and Deployment Activities: Numerous Tasks: See Documentation Matrix Reference: DFAS System Life Cycle Effective Date: May 17, 2002 DEFENSE FINANCE AND ACCOUNTING SERVICE Review Checklist for Program Name Date of Issue and Status: Date checklist is acknowledged as acceptable (mm/dd/yyyy) and whether checklist is draft or approved. Also include version number. Issuing organization: Identify the organization issuing this checklist. REVIEW CHECKLIST 1. Purpose. The Review Checklist is used to ensure the reviews are conducted in an appropriate and successful manner. This checklist is used for all product reviews, including but not limited to System Requirements Review, Functional Requirements Review, Critical Design Review, peer reviews. 2. Scope. Identify extent of use of this checklist. 3. Project Name. Name of Project or Application 4. Date of Review. Date review actually took place 5. Type of Review. Identify review in which checklist applies 6. Duration of Review. Actual time elapsed during review 7. Release or System Change Request (SCR) Numbers. Release identifier or SCR numbers reviewed 8. Review Participants. Include full name and role in the review (i.e., review coordinator, moderator, software quality assurance (SQA) representative, etc). 9. Questions. Questions should be posed to require a “yes/no� response. “Yes/no� questions should be presented so that all “yes� answers indicate successful completion of a task and “no� a lack thereof. Sample Questions: GENERAL 1. Was written notification provided at least three (3) working days prior to the review? Y N 2. Was an agenda prepared? Y N 3. Were scheduled facilities adequate? Y N 4. Was a review package prepared? Y N 5. Were the participants notified of review materials location at least three (3) working days in advance? Y N 6. Was a review checklist prepared? Y N 7. Was the review agenda followed? Y N 8. Was the review checklist completed? Y N 9. Did the Recorder take minutes of the meeting? Y N 10. Did the Recorder distribute minutes of the meeting? Y N 11. Did the Review Coordinator summarize review findings? Y N 12. Were open/action items identified? Y N 13. Did the Recorder prepare the review report? Y N 14. Did the Recorder distribute the review report? Y N 15. Were the review metrics recorded in the metrics repository? Y N 16. Were open/action items tracked to resolution? Y N 17. Were Release Quality Findings/Recommendations: (List Release program trouble reports (PTRs) Action Items (Responsibility and Completion Date) discussed during PTR? Y N 18. Were Customer Support Findings/Recommendations: Action Items (Responsibility and Completion Date) discussed during PTR? Y N 19. Were Training Findings/Recommendations: Action Items (Responsibility and Completion Date) discussed during PTR? Y N 20. Were User Documentation Findings/Recommendations: Action Items (Responsibility and Completion Date) discussed during PTR? Y N 21. Were Overall Release Findings/Recommendations: Action Items (Responsibility and Completion Date) discussed during PTR? Y N FUNCTIONAL REQUIREMENTS 22. Have requirements in all categories (functional, regulatory, user interface, performance, interface, infrastructure, security, user training) been adequately defined, analyzed, and documented? Y N 23. Do the requirements, as documented, reflect appropriate functional mandates specified in the Federal Financial Management Regulations (FFMRs) and "A Guide to Federal Requirements for Financial Management Systems (commonly called the Blue Book)? Y N 24. Do the requirements, as documented, comply with the release plan? Y N 25. Are adequate security and information assurance requirements identified? Do they comply with the requirements of the DoD Information Technology Security Certification and Accreditation Process (DITSCAP)? Y N 26. Are risks identified and mitigation plans in place? Y N 27. Have requirements adequately been traced back to the System Requirements Specification (SRS)? Y N 28. Has sufficient attention been placed on the human factors? Y N 29. Does the design team feel the Software Requirements Description (SRD) is complete, consistent, and unambiguous enough to create a complete design? Y N 30. Does the test team feel the requirements contained in the SRD are unambiguous and testable? Y N 31. Is the application using DFAS standard data elements? Y N 32. Does the application's operational, systems, and technical architecture comply with those at the enterprise level? Y N 33. Have the Oracle Designer quality checking reports been run and have deficiencies been addressed? Y N 34. Are ther

Answer: Then the program or system won't work - simple :) And the bulk of the answers are obviously no :)