New

Learn smart - Learn online. Upto 88% off on courses for a limited time. View Courses

Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

loader
250 words

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Students Who Viewed This Also Studied

136 Pages
Costs Of Bookshelves At Woodworks

1-3b Cost Projections In the following example, a company wants to project its costs of producing products, given that material and labor costs are likely to increase through time. We build a simpl ...

Course

DS510

Subject

Database

University

Saudi Electronic University

Season

Spring

13 Pages
Transfer This Model Into Excel

PART - 1 Please go through Examples 1.2 ( at page 12) and 1.4 (Sam’s Bookstore at page 20) from our textbook and create Excel files as described in examples. Show all the work they implemente ...

Course

DS510

Subject

Database

University

Saudi Electronic University

Season

Spring

73 Pages
New Drugs, Niagra,

Fixed Cost 750 Variable Cost 8 Selling Price 18 Price after certain time 6 Estimated Demand 1500 Order Quantity 1520 NET PROFIT 14210 COSTS 12910 Fixed Cost 750 Variable ...

Course

DS510

Subject

Database

University

Saudi Electronic University

Season

Spring

6 Pages
Management

assignment.1.       Click on the “PCE_results en 2010-13” file and an Excel spreadsheet will open.2.       On the Excel spreadsh ...

Type

Programming

Subject

Database

IS1S466-Information Management, Assurance and Security

Question

Answered

Assessment Task: 

Using the given ERD, analyse the requirements and then: 

a.Produce the table definitions (in SQL) for the following tables:

1.Course Type

2.Allocated Student

3.Current Course

4.Allocation

5.Room

6.Trainer

Remember to define a primary key and foreign key(s) where necessary.

b.Populate your tables with sensible data. 

c.Write the SQL statements necessary to satisfy the following queries. Remember to use sensible headings where appropriate: 

1.Produce a list of currently running courses by course code then date order.

2.Produce a list of courses that have ‘Introduction’ as part of their title.

3.List the most expensive and the least expensive course that GBT provides. Use sensible headings.

4.Produce a list of the number of students on each of the currently allocated courses. (This should be calculated by the query NOT held as a piece of data)

5.Produce a list of the current courses between two dates. Make sure you choose dates that provide MEANINGFUL output from your data

6.Produce a list of the number of current courses of each type between two dates. Your output should be similar to:

Course CodeNumber of actual courses running

CIMW              2

CAMW             5

CIES               5   

CAES              5

7.Produce a list of the rooms (include type of room: e.g av facilities or not) and trainers (by name) allocated to each course for each week. 

8.Produce a list of students (include student name) currently allocated to an actual course (use your data to select an actual course – E.g CIMW starting on 

Learning Outcomes

1) To demonstrate a practical understanding of the design and implementation of information systems.

2) To demonstrate the ability to recognise any risks or safety aspects that may be involved in the operation of computing equipment within a given context.

IS1S466-Information Management, Assurance and Security

Answer in Detail

Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

12 More Pages to Come in This Document. Get access to the complete answer.

MyAssignmenthelp.com strives to deliver quality content to students of USA and deliver assignment writing services as per individual assignment assistance. We have built up a pool of 3800+ assignment experts who provide academic writing help in more than 100+ subjects. Our skilled and experienced assignment writers deliver custom-made assistances, and they offer need-based university assignment help to students as per their assignment demands.

More IS1S466 IS1S466-Information Management, Assurance and Security: Questions & Answers

Q
icon

We aren't endorsed by this University

Costs Of Bookshelves At Woodworks

1-3b Cost Projections In the following example, a company wants to project its costs of producing products, given that material and labor costs are likely to increase through time. We build a simple model and then use Excel’s charting capabilities to obtain a graphical image of projected cost ...

View Answer
Q
icon

We aren't endorsed by this University

Transfer This Model Into Excel

PART - 1 Please go through Examples 1.2 ( at page 12) and 1.4 (Sam’s Bookstore at page 20) from our textbook and create Excel files as described in examples. Show all the work they implemented and get familiar with some nice features of Excel. Each example will be 20 POINTS P a ge ...

View Answer
Q
icon

We aren't endorsed by this University

New Drugs, Niagra,

Fixed Cost 750 Variable Cost 8 Selling Price 18 Price after certain time 6 Estimated Demand 1500 Order Quantity 1520 NET PROFIT 14210 COSTS 12910 Fixed Cost 750 Variable Cost 12160 REVENUES 27120 Full price tshirts 27000 Discounted price tshirts 120 PROFIT 1 ...

View Answer
Q

Management

assignment.1.       Click on the “PCE_results en 2010-13” file and an Excel spreadsheet will open.2.       On the Excel spreadsheet, click on the Fiscal Year field down arrow, select 2010 only3.     &nbs ...

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

Choose Our Best Expert to Help You

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?