Showing posts with label design. Show all posts
Showing posts with label design. Show all posts

Wednesday, 6 October 2021

Design in concrete and steel

UK assignment helper

 



Faculty of Science, Engineering and Computing

 

Postgraduate Modular Scheme

April/May Examinations 2020/2021

Level 7

MODULE:           CE7112 Design in concrete and steel

DURATION:       3 hours + 2 hours

 

General instructions

 

1.            This examination/assessment was designed to be completed within the duration specified on the front cover (3 hours).  However, Canvas will remain open for a further two hours to allow additional time for submission and any technical difficulties.  

 

2.            If you experience technical difficulties, eg. access and upload issues, or identify a potential error in a question please email the module leader T.Donchev@kingston.ac.uk who will be available throughout the exam.

 

3.            You must not collaborate with anyone on this exam/assessment, it should be wholly your own work.  Your work will be checked for evidence of plagiarism and/or collusion using Turnitin.

 

Submission Guidance

 

1.        You should submit your answers as a single Word, pdf or Excel document via Canvas.  Add your ID to the top of each page and indicate the questions you have answered on the first page of your document.

 

2.        If you include graphics in your answer, these should be embedded into the document (eg. a photograph of a hand-drawn graphic).  The source of any copied and pasted figures should be cited.

 

3.        Please make sure to save your work regularly and leave plenty of time to upload your work not later than ½ hour before the deadline.  Late submissions will not be marked.

 

Instructions to Candidates

 

                                   This paper contains Four questions

                                         Answer FOUR questions

                                         All questions carry equal marks

 

 

 

Candidates are reminded that the major steps in all arithmetical calculations are to be set out clearly.

 

Design Extracts will not be supplied as this is an open book examination.

 

Number of Pages: 1 – 4

 

 

 

1          Design the steel beam shown in Figure Q1 for Lateral Torsional Buckling (LTB) effects for sagging between points B and C assuming LTB restrains at the supports.  The loading generally consists of two types of Uniformly Distributed Load (UDL), acting between points A and B and points B and C correspondingly. The unfactored UDL for both parts is 25 kN/m permanent load and 20 kN/m variable load. The partial safety factors for both parts of the beam depend on the chosen loadcase. AB part of the beam is 4 m long and BC part is 1.5 m.

 

Perform the following design calculations based on EC3:

 

(a)       Choose an appropriate loadcase for maximum sagging moment to occur at the span AB and calculate the loads at Ultimate Limit State (ULS) using appropriate load factors.  Calculate the support reactions. Draw shear force and bending moment diagrams for the above mentioned loadcase indicating all significant values.                    

(6 marks)

 

(b)       Choose an appropriate S275 steel Universal Beam (UB) section which may be used to resist the LTB effects between points A and B. Check the classification of the section.

                                                                                          (5 marks)

 

 

(d)       Check the LTB effects between the supports at ULS assuming laterally restrained compression flange at the supports and at the end of the cantilever. The flanges are free to rotate in plan between the supports.

            Do the calculations only once and indicate do you need bigger or smaller section at the end.

(8 marks)

 

(c)        Check the deflections between A and B according to SLS loading and assuming non-brittle finish for the ceilings.

                                                                                                  (6 marks)

           

 

 

 

 



 

 

 

2     The simply supported frame ABC shown in Figure Q2 is made from steel S275. It is subjected to the following nominal loads: horizontal point load F at the support at point C with magnitude 35 kN as permanent load and 30 kN as variable load. In addition, uniformly distributed load w acting downwards is applied on the horizontal part BC of the frame with magnitude 80 kN/m as permanent load and 65 kN/m as variable load.

 

Assume that the column AB is supported by pinned supports top and bottom and loaded in compression and uniaxial bending. The height of the column is 4m. Check the adequacy of a UC 254x254x132 column for the load effects from simultaneous action of the indicated loading as design values in ULS.

 

Perform the following design calculations based on EC3:

 

(a)       Calculate the design values for bending and compression load effects at the top of the column AB assuming all loads applied simultaneously.                                                                                          (4 marks)

 

(b)       Check the resistance of the existing cross section of the column at point B to bending and compression.                          (6 marks)

 

(c)        Check the buckling resistance of the column BC about the major and the minor axes.                                                                        (5 marks)

 

(d)        Check lateral torsional buckling and combined buckling effects                                                                                                      (10 marks)

 

                                        



 

3      A grade S275 steel beam 406x178x74 UB carries permanent loads and variable loads from two secondary beams as shown in Figure Q3. The beam is laterally restrained at the supports and the secondary beams. Design mineral fibre box protection to give 90min fire performance if the thermal properties of the proposed thermal insulation are as follows:

 

 

 


Figure Q3 All distances are in mm

 

a)    Determine the design bending resistance of the beam at 20ºC temperature and compare with the design load at room temperature.

(7 marks)

 

b)    Determine the critical temperature for the section. As a first iteration assume the critical temperature to be 550ºC. During the heating the variable action is to be considered as a quasi-permanent value where .

 

           (12 marks)

 

c)    Calculate the required minimum thickness of the protection to satisfy the required 90min of fire performance for the critical temperature.

 

 

 (6 marks)

 

 

 

 

 

 

 

 

 

Continued…

4.            A 3-spans continuous beam with a fixed end is shown in Figure Q4a.  The beam carries two uniformly distributed loads and a point load.  The cross section of the beam is made up of a UB strengthened with a plate on the base of the UB as shown in Figure Q4b.  The yield stress of steel is 275N/mm2.

 

(a)          Determine the full plastic moment of resistance Mp of the section.

(5 marks)

 

(b)          Using Plastic Analysis method, investigate all possible collapse mechanisms and determine the actual collapse load and the corresponding collapse mechanism.

(10 marks)

 

(c)          For the collapse load in (b), draw the bending moment diagram showing all significant values.

(10 marks)

            


 

END OF EXAMINATION PAPER

Saturday, 18 September 2021

Database design and Implementation

UK assignment helper

 Faculty of Computing, Engineering and Media (CEM) – Resit Course work Specification 2020/21

 

Module name:

Database Systems and Design

Module code:

IMAT5103

Title of the Assignment:

Database design and Implementation (EER Modelling and SQL)

This coursework item is:

Summative

This summative coursework will be marked anonymously

Yes

 

The learning outcomes that are assessed by this coursework are:

1.    Select and comprehensively analyse a problem domain so as to identify data requirements in businesses

2.    Design and implement a database system for the identified requirements using database modelling techniques and appropriate data description and manipulation languages

This coursework is:

Individual

This coursework constitutes 70 % to the overall module mark.

Date Set:

1st November, 2020

Date & Time Due:

14th January, 2021, @ 12:00pm (midday)

 

Your mark and feedback will be available to you on:

If for any reason this is not forthcoming by the due date your module leader will let you know why and when it can be expected. The Head of Studies (headofstudies-tec@dmu.ac.uk ) should be informed of any issues relating to the return of marked coursework and feedback.

 

10th February, 2021

 

When completed you are required to submit your summative coursework to:

  1. Blackboard shell via TurnitIn;

 

 

Late submission of coursework policy: Late submissions will be processed in accordance with current University regulations which state:

The time period during which a student may submit a piece of work late without authorisation and have the work capped at 40% [50% at PG level] if passed is 14 calendar days. Work submitted unauthorised more than 14 calendar days after the original submission date will receive a mark of 0%.  These regulations apply to a student’s first attempt at coursework. Work submitted late without authorisation which constitutes reassessment of a previously failed piece of coursework will always receive a mark of 0%.”

 

 

Academic Offences and Bad Academic Practices:

These include plagiarism, cheating, collusion, copying work and reuse of your own work, poor referencing or the passing off of somebody else's ideas as your own. If you are in any doubt about what constitutes an academic offence or bad academic practice you must check with your tutor. Further information and details of how DSU can support you, if needed, is available at:

http://www.dmu.ac.uk/dmu-students/the-student-gateway/academic-support-office/academic-offences.aspx and

http://www.dmu.ac.uk/dmu-students/the-student-gateway/academic-support-office/bad-academic-practice.aspx

 

Tasks to be undertaken:

You are tasked to develop a database design (both conceptual and logical) for an appropriate business situation of your choice, and then implement and subsequently query an ORACLE database that is derived from your database design.

 

 

Task 1: Selection of the case upon which the database design and implementation is to be based

 

You need to identify a suitable scenario and ensure that your business situation is suitably complex to provide you with at least four strong entities, and at least one specialisation: generalisation structure, Once researched and identified, a written scenario needs to be produced that (a) provides relevant background information on the organisation (e.g., its purpose, its principal operations/structure, its products/services, its target markets, etc.), and (b) provides an overview of what operations a database would need to support

Task 2: Provide a conceptual database design for your scenario

 

Provide a conceptual database design for your scenario. The EER Diagram needs to show any weak and strong entities, the primary keys for strong entities, and any relationships between entities (including any generalisation: specialisation structures). For each entity, there should be an associated written list of all the attributes that the entity possesses which are not written on the EER Diagram. Any assumptions made during conceptual database design (i.e., anything that you assume that is not written in your scenario) should be listed.

 

 

Task 3: Create the tables using Oracle DBMS

 

From your conceptual database design, derive a corresponding set of well-normalised tables.  Remember to indicate all primary and foreign key fields for each of the tables using suitable and consistent notation. All key and any non-key attributes should be listed within each table. Create the tables using Oracle DBMS. You need to create all the tables that you identified within your logical database design. Populate your Oracle tables with some fictitious yet appropriate test data (about FIVE records per large table and TEN records per small table (or as many rows as is relevant) should be enough).

 

Task 4: SQL Query writing

 

Define and run the following queries and justify as to why the query would be useful to your case study organisation:

 

·         Selection of particular table columns

·         Use of count and/or another similar mathematical expression

·         Use of a sorting/ordering facility

·         A condition using “<”, “>”, LIKE etc.

·         A condition using IN, NOT NULL, or similar.

·         A sub-query

 

 

 

 

Deliverables to be submitted for assessment:

 

The results of the above Tasks need to be submitted, i.e.:

• Your case scenario, EER Diagram, and the whole conceptual database design.

• The logical database design that follows from your conceptual database design.

• A print out of each of the tables (i.e., the extension of each table) that you have created in ORACLE and the SQL code required to create them (including the code for the integrity rules).

• A print out of each of the queries you devised, showing both the SQL query statement and the query result. You should provide a brief explanation of what you expect each query to achieve and why you think this query is relevant to your case scenario.

ONE electronic copy containing all of the above aspects must be submitted for summative assessment via Blackboard’s TurnitIn. You are permitted to attach a small amount of additional and appropriate evidence to support one or more of your claims, should this be necessary.

Sometime after submission, you may be asked to attend a viva lasting for up to 15 minutes with one or more tutors. You may be selected for a viva for a variety of reasons; for instance, to verify that the work you have submitted is understood/written by you, to clarify aspects of the work to aid marking or just because you were randomly selected. Your mark may go up or down as a result of a viva.  Failure to attend a viva, if you have been asked to do so, may result in you obtaining zero marks for the entire assessment.  

 

 

 

 

 

How the work will be marked:

 

In order to achieve a 70%+ (Distinction) grade, the work must be excellent in almost all respects, only very minor limitations.

In order to achieve a 60-69% (Merit) grade, the work should show strength in most respects. Whilst there may have some limitations in one or two areas, it is still a very good piece of work.

In order to achieve a 50-59% (Pass) grade, the work should be of a satisfactory standard, showing strength in some areas, but typically let down by some other aspects.

A 0-49% (Fail) grade will be given where the work contains serious errors/limitations. (0% is used either when nothing is correct or no attempt is made.)

 

Please refer to the criteria marking grid bellow for the details of the assessment of the work.

 

Module leader/tutor name:

Eirini Kalaitzopoulou

Contact details:

erini.kalaitzopoulou@dmu.ac.uk,

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Scenario, Conceptual and Logical Database Design & Oracle SQL implementation/querying

 

Criteria

0 to 49 %

50 to 59 %

60 to 69 %

70 to 100 %

Scenario – content appropriate and sufficient

20%                 

 

 

 

 

 

EERD – content quality, contains minimum standard of complexity and matches scenario

20%

 

 

 

 

 

Assumptions complete and appropriate to scenario

10%

 

 

 

 

Associated attribute lists appropriate and complete

10%

 

 

 

 

 

Tables – quantity correct and in appropriate format, with primary/foreign keys indicated and appropriate. Well normalised tables, with all appropriate non-key attributes.

20%

 

 

 

 

Development of the required syntactically correct queries; that together cover the required SQL SELECT statement elements as defined, with reason(s) for each query choice.

20%

 

 

 

 

Overall Grade