Reference no: EM131009298
Assessment Information -
Overview
You are required to complete TWO assessments - Assessment 1 (Project) and Assessment 2 (Worksheets). You must successfully complete both the assessments to be deemed competent in this course.
As part of Assessment 1 (project), you are required to implement a fully-functional database with suitable data based on a design provided to you using both graphical tools (Stage 1) in MS Access / MS SQL Server and SQL statements (Stage 2) in MS SQL Server.
As part of Assessment 2 (worksheets), you are required to design and build a database based on a given case study. Also enter appropriate data in the database. Further, you also have to answer questions on server concepts.
The details with timelines for the above two assessments are shown below:
• The Assessment 1 (Project) is submitted in two stages.
o Stage 1 is an individual submission.
o Stage 2 is a team (2 or 3 students) submission.
• Assessment 2 (Worksheets) is submitted in two parts.
o (2a) : Database modelling - Individual - in class assessment
o (2b) : Server concepts.- Team (2 or 3 students) - take home submission
Context / Purpose: Assessment 1(Project)
Govinda pty limited is a car garage centre in Melbourne. They operate from many centres in Melbourne.
The business stores all their operational data (customer's details, car repairs, employee details, salaries, payment.....) in a fairly complex database called "Govinda".
You are working as an IT specialist in the organisation. In your current role, based on your manager's request, you are required to enter, extract and manipulate data in Govinda by designing & executing SQL queries.
ASSESSMENT 1 (Project) Stage 1 - Individual submission -
Student will develop skills in
• reading data using SQL SELECT statement to match client requirements.
• trouble shooting SQL syntax errors
• problem solving.
• planning and organisational skills to analyse and organise data.
• programming.
Instruction
• Build the above (MS Access Relationships ) model of Govinda in MS Access / MS SQL Server
o Carefully choose appropriate data type for each attribute.
o Choose PK & FK shown in the above snapshot.
• Populate tables with appropriate data, about 10 records in each table.
Design SQL Queries:
1. Design a query to display details of customers from "Albert Park". Sort data according to the alphabetical order of customer's last name.
2. Write a query to show details of EmployeeNo, FirstName, Office phone and address where first name starts with letter "P".
3. Add a field called gender to Customer table. Enter data for this field. Design a query to find out details of CustomerNo, first name, last name who have paid amount more than the average amount paid by all male customers.
4. The Garage centre is interested in knowing details of Toyota cars of type "sedan" which have come for more than three times for servicing. Design a query to display the requested details.
5. At least one more query will be given at the time of assessment for Stage 1 and the student needs to answer this question under TEST conditions during class time.
|
Performance measures for each supply chain driver
: Your presentation will ask for a decision on a major change in the supply chain operation that affects at least three (3) supply chain drivers and at least three (3) performance measures for each supply chain driver
|
|
Which interval has which level
: Three confidence intervals for the mean shear strength (in ksi) of anchor bolts of a certain type are com- puted, all from the same sample. The intervals are (4.01, 6.02), (4.20, 5.83), and (3.57, 6.46). The levels of the intervals are 90%, 95%, a..
|
|
What proportion of sample measurements were satisfactory
: A measurement is considered to be satisfactory if it is within 5 ppm of the true concentration. Of the 50 measurements, 37 were satisfactory. What proportion of the sample measurements were satisfactory?
|
|
Supermarket recorded two categorical variables
: 1. A study of purchases at a 24-hour supermarket recorded two categorical variables: the time of the purchase (8 a.m to 8 p.m vs. late night) and whether the purchase was made by someone with children present. Would you expect these variables to b..
|
|
Design a query to display details of customers
: Design a query to display details of customers from "Albert Park". Sort data according to the alphabetical order of customer's last name and write a query to show details of EmployeeNo.
|
|
Customer used the coupon in the store
: A chain of stores suspects that coupons will increase sales to customers in its frequent shopper program. To test this theory, the chain mails some customers coupons and does not send these coupons to others.
|
|
Identify and describe in detail different age cohort group
: Identify and describe in detail the different age cohort groups. For each describe cohort group, describe typical spending habits
|
|
Market shares of several companies
: The following table compares market shares of several companies in the computer industry as reported by Gartner, an industry monitor. The table gives the number of computer systems shipped during each quarter, in thousands.
|
|
Find a tolerance interval for the resistance
: In a sample of 20 bolts, the average breaking torque was 89.7 J with a standard deviation of 8.2 J. Assume that the breaking torques are normally distributed. Find a 99% prediction interval for the breaking torque of a single bolt.
|