Part 1: SQL/Database work Scenario Development of a relational database system for a food producing company FoodRU is a Leicester-based food producing company….

StudyAcer homework Experts at a Glance, Save Time and Excel

Writer avatar

Rating: 5/5    Reviews 482

Success rate 100%

Completed projects: 783

Hello, I am Prof Writers, I am a bold, accurate, and experienced tutor committed to providing clients with high quality, original, and timely work. As a writer, proficiency in several disciplines in academic writing is necessary, and that is why I prioritize on delivering quality and appropriate work. Be assured that I will always follow the lai...

Writer avatar

Rating: 4.9/5    Reviews 373

Success rate 98%

Completed projects: 592

Hello, I am a full-time professional freelance writer with over 6 years experience in academic writing. I have a PhD in Strategic Management and have done several projects in business management, marketing and other subjects. This experience has helped me reinforce my ability to work in various fields and handle simple and complex topics. I am a...

Writer avatar

Rating: 5/5    Reviews 1326

Success rate 97%

Completed projects: 1976

Hello :) My name is Dr.Success, I've started on my path as a professional writer mostly by writing essays. However, in the years since then, I've written various other academic papers, from research works to book reviews. From Sydney to New York, there are hundreds of students all over the world that are happy with the services I've provided the...

Writer avatar

Rating: 5/5    Reviews 371

Success rate 97%

Completed projects: 1173

Hi there! Im MarvellousTutor, your perfect author with huge writing experience in English, Art and Business. What? Need assignment on another subject? No worries: I can deal with anything! If you're dreaming of the reliable, responsible and always-on-time writer, here I am! I manage my time greatly, thus, your deadline is highly important for me...

Writer avatar

Rating: 4.7/5    Reviews 891

Success rate 100%

Completed projects: 1136

Hello there! My name is Prof Stephen. I have been a full-time freelance researcher and writer for a period of over 6 years. I have successfully completed over 1000 projects and assignments. I have had a good professional relationship with my clients who always come back for more quality papers since I highly value quality, professionalism, and i...

Writer avatar

Rating: 4.9/5    Reviews 244

Success rate 96%

Completed projects: 479

I'm ProfTzKelly, talented wordsmith, grammar afficionado, and writing machine. I'm written everything from outlines to screenplays and book reviews to advanced research papers. All you have to do to be well on your way to a great grade is chat with me! I'm experienced in all major styles, including APA, MLA, Chicago, Harvard, and Vancouver. You ...

Writer avatar

Rating: 5/5    Reviews 465

Success rate 99%

Completed projects: 852

Hey! My name is ProfAcer, and my goal is to help you to get through a tough period of your life. I've been a student, and I know that the amount of work some professors expect you to do can be unfair and overwhelming. And that's without even accounting for the job you probably have an active social life each student should have. There is no sham...

Writer avatar

Rating: 4.9/5    Reviews 412

Success rate 97%

Completed projects: 719

In academic writing, quality, originality, and deadlines are vital, and these are my primary offerings to all my clients. I have two years of experience as a full-time academic writer, with over 300 finance, economics, marketing, business, and general papers written from scratch. Since joining this site, I have also tackled sociology, healthcare...

Writer avatar

Rating: 4.8/5    Reviews 319

Success rate 96%

Completed projects: 584

Hello! People call me ThinkTank, and I've been earning money as an academic writer for years. With a lot of works under my belt, you can bet that I've dealt with dozens of various topics and different forms of papers, including essays, research papers, and even dissertations. I like the challenge that comes with this job. I first fell in love wi...

Part 1: SQL/Database work Scenario Development of a relational database system for a food producing company FoodRU is a Leicester-based food producing company….

Do Not Copy. Order Custom, Original Paper.
Part 1: SQL/Database work Scenario Development of a relational database system for a food producing company FoodRU is a Leicester-based food producing company. The company wants to keep details regarding both past and present employees and their assignment to shifts over time. At present, there are three defined shift patterns; the morning shift starts at 6am and finishes at 2pm, the day shift starts at 9am and finishes at 5pm, and the evening shift starts at 4pm and finishes at 12am (midnight). However, management have already indicated that they may need to add further shift patterns in the future (e.g., by adding a night shift to the existing ones so that the company can meet a high user demand for their foods). They therefore require shift details to be stored within a separate Shift table, with attributes that allow the storage of a shift name with its associated start and finish times (use the 24 hour clock for these times). Past and present employee details are to be kept in the same Employee table, and the details to be kept are the employee’s unique 6 digit reference number, the first name, surname and any other names (if there are any) of the employee, the employee’s gender, contact address and contact telephone, the date on which the employee started his/her employment at the company and the date on which the employee finished his/her employment at the company (should s/he be a past employee). Details regarding staff assignments to shifts include the date that an employee was allocated to work a particular shift, and the date that s/he was taken off the shift (if not still assigned to it). Employees can be assigned to different shifts over time and even to the same shift over different time periods, although they cannot be assigned to more than one shift at any one time. A new employee may not yet be assigned to a shift. Tasks: 1. Provide the table specifications for the THREE tables that are required by FoodRU to store employee, shift and assignment details. That is, for each of the three tables, you should provide, in a suitable presentation format, the name of the table and a specification of each its attributes to include: • Attribute name • Attribute brief description as to its meaning • a description of the attribute’s data type/integrity (e.g., date field, character field of length 20, number field <= 10, etc. – you can use the Oracle data types within these descriptions if you want to) • An indication as to whether the attribute is a primary key attribute and/or foreign key attribute • An indication as to whether the attribute can or cannot take null values Make sure your design specifies the appropriate links between the three tables. Remember to write down any additional integrity you need to enforce either at a specific table level or across two or more tables, if this is required. Also, remember to write down any justifications for the data types/integrity or for any other design features that you have introduced, and/or any assumptions that you have made at any time during your design. 2. Create the THREE tables you have designed in Question 1. above, and populate the tables with some example data (at least 5 employees (some past and some current), appropriate shift details, and at least one shift allocation for most (but not all) of the employees). For the Employee table ONLY, provide a series of tests and their results so that you can be confident that the table was set up properly. This involves testing any entity integrity, referential integrity and other data validation constraints using appropriate SQL statements. Print out the test and its results, and annotate to specify the intention of each test. 3. Create and justify THREE queries that you think FoodRU would like to use. Make sure that your queries, in total, show you are able to use the following facilities in Oracle SQL*Plus: o Selection of particular table columns o Selection of particular table rows o Inner Join of at least 2 tables o Use of a sorting/ordering facility o Use of DISTINCT o A condition using “[removed]”, IS NULL, IS NOT NULL, or similar. None of your queries should output an empty table! You are required to submit: • The completed table specifications for the required three tables. These should be written using an appropriate text editor. • All the CREATE TABLE and INSERT INTO Oracle SQL*Plus statements used to create the three tables and to populate them with suitable data, together with a printout of each of the Oracle tables (i.e., the extension of each table) that you have created and populated. • The series of tests, and their results and annotations, for the Employee table ONLY. • A printout of the three queries you devised, showing both the SQL code 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 FoodRU. Marking Criteria Generic explanation of criteria: In order to achieve an A grade, the work must be excellent in almost all respects, only very minor limitations. In order to achieve a B grade, the work should show strength in most respects, but perhaps has limitations in one or two areas. A good piece of work nevertheless. In order to achieve a C grade, the work should be of a satisfactory standard, showing strength in some areas, but perhaps let down by either poor presentation, poor practical work, or poor written explanations where required. In order to achieve a D grade, the work should be of a satisfactory standard but may have significant shortcomings in some areas. Nevertheless shows at least a basic understanding of the concepts and a basic practical ability. A E grade will be given to work that is just unsatisfactory. An F grade will be given where the work contains serious errors/limitations.   The following grid gives more guidance re: marking of specific tasks: TASK [removed]70% Table specifications Poor or no attempt Basic understanding displayed Fair understanding displayed Good Understanding displayed Excellent understanding displayed – full and appropriate table specifications in correct format Creation of tables with integrity rules implemented Inappropriate tables, poor attempt at implementing defined integrity rules Some tables and associated integrity rules created correctly Satisfactory but with some significant errors/ limitations As for A but with some minor errors/ limitations All tables created correctly, including foreign keys. Appropriate implementation of integrity rules Testing of Employee table creation Poor or no attempt Basic testing evident Fair testing evident Good testing evident Excellent, well thought out and complete series of tests and associated results Development of three queries as described above, with reasons for choice of query Little or no evidence of successful/ appropriate query development Some evidence of sensible choice and implementation of queries Satisfactory but with some significant errors/ limitations As for A but with some minor errors/ limitations. Excellent choice and implementation of queries, demonstrating appropriate use of all required querying facilities. OVERALL MARK: ANY OVERALL COMMENTS: Part 2: Haskell work Consider the following Haskell program. module Main where import Data.Char (isPunctuation,toLower) import Data.List (nub,sort) strip :: [Char] -> [Char] strip cs = [ c | c [removed] [Char] lower cs = [ toLower c | c <- cs ] prog = unlines . nub . sort . words . lower . strip main = interact prog You have been asked to give a lecture explaining in detail what this program does and how it works. You should produce a PowerPoint presentation containing about 20 slides in which you provide a full explanation (with examples) of the program and how it works. You may assume that your audience consists of first year functional programming students who have a reasonable working knowledge of Haskell. However, you should ensure that each aspect of the program (including programming language features, standard functions, etc.) is fully explained so that everyone has a chance to understand the lecture fully. You should ensure that your slides appear professional. Take care with general layout and avoid spelling mistakes. You should hand in a printed copy of your PowerPoint presentation by the deadline and you should also upload your slides to Blackboard.   The following grid gives more guidance re: marking of specific tasks: TASK [removed]70% Quantity of work (i.e. how many slides and what is on them) Poor or no attempt Bare minimum explanation Covers most of the main points Covers all the main points Covers all the main points and provides extra, appropriate and relevant, supporting information Quality of explanation (i.e. the depth of the understanding demonstrated and conveyed) Inadequate or superficial explanation Reasonable explanation of the some of the main concepts Good explanation of most of the main concepts Very good explanation of most of the main concepts Outstanding explanation that covers all of the main concepts and also includes some of the subtler points in the code Quality of slides (i.e. how do they look; how is the information presented?, is it a coherent lecture?) Confusing, badly structured, inconsistent, poor English, etc. Consistent presentable, Good set of slides: well structured Very good set of slides: well structured and presented Outstanding set of slides: thoroughly consistent, well laid out, good quality English, etc.

Need help with writing Part 1: SQL/Database work Scenario Development of a relational database system for a food producing company FoodRU is a Leicester-based food producing company….?

Get help

  • StudyAcer

  • Trustpilot

  • Sitejabber


Please fill in the Order, to get Instant Homework Help

Attach files for the writers' reference