UML Library Book Borrow Ststem Complete solved

Midterm questions
Create a set of detail use case descriptions and draw a use-case diagram for a university library borrowing system (do not worry about catalogue searching, etc.). The system will record the books owned by the library and will record who has borrowed which books. Before someone can borrow a book, he or she must show a valid ID card, which is checked against the student database maintained by the registrar's office (for student borrowers), the faculty/staff database maintained by the personnel office (for faculty/staff borrowers), or against the library's own guest data base (for individuals issued a guest card by the library) to ensure that it is still valid. The system must also check to ensure that the borrower does not have any overdue books or unpaid fines before he or she can borrow another book. Every Monday, the library prints and mails postcards to those people with over due books. If a book is overdue by more than two weeks, a fine will be imposed and a librarian will telephone the borrower to remind him or her to return the book(s). Sometimes books are lost or are returned in damaged condition. The manager must then remove them from the database and will sometimes impose a fine on the borrower.? Please make sure to use the use case description template available on the web site and the guidelines discussed in class.

Need Solution Email me: 

Topsolutions8@gmail.com

Read More...

Parson's Lights manufactures natural lighting fixtures sold

Parson’s Lights manufactures natural lighting fixtures sold throughout North America. The users in the Manufacturing and Inventory Building are fully networked and use modern operating systems. The managers and accounting group use Windows 7. Users on the manufacturing floor are equipped with Red Hat Enterprise Linux Workstation, and the inventory users have computers running Mac OS X. There is a secure computer room in the Manufacturing and Inventory Building that houses five Windows Server 2008 R2 servers. All of the computer equipment is recently set up, because the company just reorganized and gave these users a large budget to fully network the building and upgrade operating systems.

In one paragraph for each question, complete the questions below using complete sentences

In the past, the building was only equipped with one Windows Server 2003. Now that they have five Windows Server 2008 R2 servers, the IT support group is considering whether or not to install Active Directory. What advantages does Active Directory offer for managing user accounts?

The old Windows Server 2003 was set up so that all resources were managed through a confusing array of local groups. As one example, the managers’ user accounts were in one local group which was given full control access to all folders and files, printers, and other resources. What general suggestions do you have for creating a different way to manage user accounts and groups on the new Windows Server 2008 R2 servers?

Need Solution email me:

topsolutions8@gmail.com

Read More...

network administrator

You are the network administrator for a group of 24 groundwater hydrologists who work in two adjacent buildings. Their company works with new housing construction all over the United States to determine if there is enough local ground water to support new housing developments. Each hydrologist has his or her own computer workstation. Two use computers running Linux, three use Macintosh OS X Snow Leopard computers, and the rest use computers running Windows Vista or Windows 7. These hydrologists work with a variety of software, including word-processing, research databases, spreadsheets, mapping software, and mathematical calculation software. The buildings in which the hydrologists work are not networked, but the company plans to network each building and connect both networks. The company also decided to purchase a Windows Server 2008 R2 server for all of the hydrologists to access. The server will be in a secure computer room in one of the buildings. Also, the company plans to connect to an Internet service provider so that each hydrologist can easily access the Internet. Explain how you would handle the following immediate concerns:

In one paragraph for each question, complete the questions below using complete sentences

What equipment must be purchased for each hydrologist’s computer to be connected to the network? How would you configure the equipment, such as configuring protocols?

What are the advantages of implementing a server in terms of the new networking environment for this company?

Need Solution email me:

topsolutions8@gmail.com

Read More...

Lab4 JSmith

STEP 1
Download the Lab4_Database.accdb database from Doc Sharing.
Rename the Lab4_FormsReports.accdb database with a name containing Lab4_, your first initial, and your last name as the file name (e.g., Lab4_JSmith.accdb).
STEP 2
Back to top
Run Access 2010, either via Citrix or from Visio 2010 installed on your workstation.
Open the database you renamed in Step 1.
See the tutorials above for instructions on how to perform the following steps in Access 2010.
STEP 3
Reports
Create a report for each of the following requirements. Reports may be created using the wizard or an SQL query. Reports should follow the formatting guidelines given in the next step. Reports should be named as indicated below (e.g., Report1, Report2, etc.).

Report1: Show Instructor information (Instructor_ID, First_Name, Last_Name) grouped by Approved Course_No.
Report2: Show student information (Student_ID, First_Name, Last_Name, Status, Zip) grouped by Major.
Report3: Show student information (Student_ID, First_Name, Last_Name, Major) grouped by Zip code. Zip codes should be in increasing order.
Report4: Show student information (First_Name, Last_Name) grouped by Course Number and Course Name. Course Number should be in in increasing order.
Report5: Show student information (Student_ID, First_Name, Last_Name, Address, Zip) grouped by Status. Students should be in alphabetical order by Last_Name and;then First_Name.

STEP 4
Report Format
Reports should display two or more child rows for each parent row. For example, Report1 should display each Course_No with instructors who are approved to teach the course grouped under it. In this case, the parent row would be the Approved Course_No with Instructor listed as child rows underneath each parent row
There should be at least two child rows of data for each parent row. Add data to the tables in order to have reports show at least two child rows per parent.

STEP 5 Back to top
Form1: Create a form based on an SQL query.
Create and run an SQL query that displays Student Information (Student_ID, First_Name, Last_Name, Address, Zip).
Save the query in the database named Form1Query.
Create a form based on Form1Query. While Form1Query is selected, go to the Create menu and select Form to build the basic form.
Select the form and switch between the views (Forms, Layout, and Design) to change the properties or the form's appearance as desired.
Save the form in the database named Form1Query.

STEP 6
Form2: Create a form using the Form Wizard.

Invoke the Form Wizard as shown in the tutorials above.
Using the Form Wizard, create a form showing instructor information (Instructor_ID, First_Name, Last_Name, Office_No).
Switch between the views (Forms, Layout, and Design) to change the properties or the form's appearance as desired.
Save the form in the database named Form2Wizard.

STEP 7
Form3: Create a form using a master detail relationship. A master detail relationship is simply a 1:N relationship between two tables. Use subforms to format the form in a split data entry form as shown in Figure 1-9. You may use SQL queries or the wizard or both to create your form and subform.
Create a master form showing student information (Student_ID, First_Name, Last_Name, Address, Zip, Major, Status).
Create a detail Subform showing Student_ID, Class_ID, and Student_Grade.
For each student displayed, the student's classes and grades should be displayed in the detail form.
Switch between the views (Forms, Layout, and Design) to change the properties or the form's appearance.
Save the form in the database named Form3MaterDetail.

STEP 8
When you are done, save the file on your local hard drive and upload it to the Week 7 Course Project Dropbox. Your file should have the following filename format: Lab7_FirstInitialLastName.accdb

Need Solution email me:

topsolutions8@gmail.com

Read More...

Tamworth Truck manufactures

Question 1:

Tamworth Truck manufactures part YYY used in several of its truck models. 10,000 units are produced each year with production costs as follows:

Direct materials $ 45,000
Direct manufacturing labour 15,000
Variable support costs 35,000
Fixed support costs 25,000
Total costs $120,000

Tamworth Truck has the option of purchasing part YYY from an outside supplier at $11.20 per unit. If part YYY is outsourced, 40% of the fixed costs cannot be immediately converted to other uses (i.e. cannot be avoided).

a. Describe ‘avoidable’ costs. What amount of the YYY production costs is avoidable?

b. Should Tamworth Truck outsource YYY? Why or why not?

c. What other items should Tamworth Truck consider before outsourcing any of the parts it currently manufactures?



Question 2:

Tamworth Pet Corporation manufactures two models of grooming stations, a standard and a deluxe model. The following activity and cost information has been compiled:



Product Number of Setups Number of Components Direct Labour Hours
Standard 3 30 650
Deluxe 7 50 150

Overhead Costs $20,000 $60,000



Required:

Assume a traditional costing system applies the $80,000 of overhead costs based on direct labour hours.

a. What is the total amount of overhead costs assigned to the standard model?

b. What is the total amount of overhead costs assigned to the deluxe model?

AND,

Assume an activity-based costing system is used and that the number of setups and the number of components are identified as the activity-cost drivers for overhead.

c. What is the total amount of overhead costs assigned to the standard model?

d. What is the total amount of overhead costs assigned to the deluxe model?

e. Explain the difference between the costs obtained from the traditional costing system and the ABC system. Which system provides a better estimate of costs? Why?



Question 3:

Tamworth Company has the following information:

Month Budgeted Sales
March $50,000
April 53,000
May 51,000
June 54,500
July 52,500

In addition, the gross profit rate is 40% and the desired inventory level is 30% of next month's cost of sales.

Required:

Prepare a purchases budget for April through June (one column for each month), giving ‘total figures’ for the quarter in the forth column.



Question 4:

Tamworth Cabinets is approached by Ms. Jenny Zhang, a new customer, to fulfil a large one-time-only special order for a product similar to one offered to regular customers. The following per unit data apply for sales to regular customers:

Direct materials $100
Direct labour 125
Variable manufacturing support 60
Fixed manufacturing support 75
Total manufacturing costs 360
mark-up (60%) 216
Targeted selling price $576

Tamworth Cabinets has excess capacity. Ms. Zhang wants the cabinets in cherry rather than oak, so direct material costs will increase by $30 per unit.

Required:

a. For Tamworth Cabinets, what is the minimum acceptable price of this one-time-only special order?

b. Other than price, what other items should Tamworth Cabinets consider before accepting this one-time-only special order?

c. How would the analysis differ if there was limited capacity?

Need Solution email me:

topsolutions8@gmail.com

Read More...

Python 3.3 spreadsheet program

Python v.3

Spreadsheet programs such as Microsoft Excel or Open Office Calc have an option to export data into CSV files. In this exercise, you will create a program that will read in a spreadsheet (in CSV format) and manipulate it. Provide the following capabilities:
-print data
-delete row or column
-insert row or column
Change a value in a cell
output the data in CSV format

Issues to consider:
-Use Python's csv module to read in a spreadsheet. Choose an appropriate data structure to store the data. Should you use lists, tuples, or dictionaries?
-Construct a driving loop in your program that will prompt for the operations specified previously. A useful interface is to allow choices to be specified with a single letter related to the operation--e.g., d for delete.

  Need Solution email me:

topsolutions8@gmail.com

Read More...

Uml

B. Create UML Use Case Diagrams that could be inserted into a Software Requirement Specification (SRS) document that captures all functional requirements for this application. Use the task description in part A to elicit the requirements. You will only be required to document the functional requirements and provide Use Case diagrams. You do not have to complete a complete SRS document.

1. Document the functional requirements with UML use case diagrams for each requirement. For eachfunctional requirement provide the following:

• Requirement number and title

• Description of the functionality

• Input

• Results of processing or output

• Error handling or recovering requirements outlined

• UML use case diagrams (It is very important that your UML use case diagrams are complete and proper UML 2.0 Modeling notation is used.)

C. Create UML Class and Sequence Diagrams that could be inserted into a Software Design Specification (SDS) document. (It is very important that your UML diagrams are complete and proper UML 2.0 Modeling notation is used. Your design must be an object-oriented design.) You will only be required to submit the class and sequence diagrams and not have to complete a SDS document.

1. Your UML Diagrams should include the following:

a. Comprehensive Class Diagrams: Show all classes and all relationships among all classes. These should include the following:

• Relationships: Your object oriented design will require you to diagram all class relationships using correct UML 2.0 Modeling notation which minimally includes:

- Inheritance

- Association Relationships

• Multiplicity: Note any multiplicity in the relationships (e.g., 1-1, 1-many, etc.) using correct UML 2.0 Modeling notation.

• Attributes: For each class, all attributes with types (e.g., int, double, etc.) and access control (e.g., private, public, protected) need to be noted using proper UML 2.0 Modeling notation.

• Methods: Methods with signatures and access control should be provided. All methods have to be indicated, including all constructors, setters, and getters.

• Abstract Classes and Interfaces: Any abstract classes and interfaces used in your design must be properly indicated using UML 2.0 Modeling notation.

b. Sequence Diagrams: Model the object interactions required for each functional scenario. For each Use Case provided in the functional requirements section, at least onesequence diagram should be provided to model the interaction between the objects inside the application.

  Need Solution email me:

topsolutions8@gmail.com

Read More...