Unlock Accurate Database Answers and Make Way for Top Grades : Page - 13

Course Code   :  DBAS32100

Course Title   :  database management system

Ref style  :  APA

4/5 

Stored Procedure for Finding Number of Cars and Total Spend Amount by CustomersFor these questions you must use the tables created in your own schema, because you DO NOT have privileges to INSERT, UPDATE or DELETE values in SI schema. Write a stored procedure that can be used to find the number of cars and total amount of money a customer has spent on all cars they have bought. This procedure will be used in question 2, but it can be used in any...

TaskTask:Herbert owns and manages a bicycle shop called ‘TopBike’ which is undergoing significant expansion. Since you are a friend of his and run a professional systems consultancy, he has taken the precaution of commissioning a feasibility study from you at a cost of £1,000.Two years ago Herbert realized that, due to competition from massive out of town retailers such as Malfords, his business either had to expand or go under...

Identifying the Technology and Its FunctionalityFor this assignment, research cutting-edge technologies in the area of databases, data management, big data, business intelligence, cloud technology, etc. You should assume that you are presenting to the management group at your company, with the intention of having them adopt the technology for one of their products. If you do not currently work for an organization, you may develop a hypothetica...

Learning OutcomesThe learning outcomes that are assessed by this coursework are: 1.Select and analyse a problem domain (see project list in appendix) 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. Late submission of coursework policy: Late submissions will be processed ...

Course Code   :  IMAT5103

Course Title   :  database systems and design

Ref style  :  Harvard

4/5 

Question: 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. You must work individually for this assignment. There are two stages to the work you need to undertake: each stage is worth 50% of the assessment mark. Perform Stage 1 first, then ...

Identifying Stakeholders and Actors in the Online Enrolment SystemIn response to the issues raised in the ‘online university enrolment system’ case study provided, identify the functional and non-functional requirement for an online enrolment system and build and document a set of use cases for that system. Using the case-study, please write the answers for the following questions: Question 1. (a) Who are the stakeholders in this...

Business Case: Argosy BooksUsing the business case included in this assignment, complete the following requirements: 1.Draw the ERD of the database that could be used to support the operations of the business described in the case. The ERD should identify: Primary keys and Foreign keys; Entities and Attributes; Relationships and Cardinalities (e.g. one-to-one, one-to-many). Next to the ERD in your submission, list the assumptions made when desig...

Question: Information Requirements As previously mentioned, Delphi have a permanent staff of over 40 people.   Every member of staff has a role (for example, account manager, campaign manager, graphic designer, etc), a salary grade and a corresponding charge-out rate at which clients are charged.  Staff names should also be recorded together with the telephone number, fax number and email.  There are members of staff with ...

Question: In response to the issues raised in the ‘online university enrolment system’ case study provided, identify the functional and non-functional requirement for an online enrolment system and build and document a set of use cases for that system. Context Requirement analysis techniques and skills are of fundamental importance to a Business Analyst, who is often required to help business users in terms of identifying what th...

Question Purchasing assistants are responsible for finding and buying the required location space for adverts in the campaigns, referred to as ‘placements’.  This includes TV and radio time, newspaper and magazine space and negotiating with agencies who manage advertising hoarding space and leafleting campaigns.  Each placement is given a unique code within the campaign, e.g. for campaign C145, advert A18 might have three...

Information RequirementsAs previously mentioned, Delphi have a permanent staff of over 40 people. Every member of staff has a role (for example, account manager, campaign manager, graphic designer, etc), a salary grade and a corresponding charge-out rate at which clients are charged.  Staff names should also be recorded together with the telephone number, fax number and email.  There are members of staff with the same name therefor...

Campaign Contacts and Account ManagerEach client company is asked to nominate two members of staff to act as contacts for each campaign.  The information requested is the person’s name, position, email address and telephone number.  Delphi allocate an account manager to each client no matter how many campaigns the client is involved in.  The account manager is responsible for maintaining contact with the client after campa...

Question: Learning outcomes assessed within this piece of work as agreed at the programme level meeting On successful completion of this module students will be able to 1.Demonstrate a broad understanding of the knowledge base of systems analysis and design concepts, and their terminology and discourse, including awareness that areas of this knowledge base are open to ongoing debate and reformulation, thus fostering a socio-technical approac...

Learning OutcomesOn successful completion of this module students will be able to 1.Demonstrate a broad understanding of the knowledge base of systems analysis and design concepts, and their terminology and discourse, including awareness that areas of this knowledge base are open to ongoing debate and reformulation, thus fostering a socio-technical approach to the analysis and design of systems. 2.Identify and apply principles and concepts u...

Purchasing Assistants' Responsibilities in Ad CampaignsPurchasing assistants are responsible for finding and buying the required location space for adverts in the campaigns, referred to as ‘placements’.  This includes TV and radio time, newspaper and magazine space and negotiating with agencies who manage advertising hoarding space and leafleting campaigns.  Each placement is given a unique code within the campaign, e.g. ...