Find the employees who draws the maximum salary

Assignment Help Database Management System

Reference no: EM132173140

Assignment 1

1. The Brief:

Consider the following requirements and design a database to support such an application

The organizer of international conferences based in Oman wants to StOre all the details of the workshops. a. conferences.

Mainly there are two types of events such as workshop or conference. Each &Lent has a name, starting date a. a duration, which mostly happens at one day and sometimes, may be more than One day.

The participants for each event have to be stored. The participant can attend one or mere of the events: Participant name, phone number, and email address have to be stored.

The venue of the event is identified by a unique room number and its capacity. FOr each workshop or the conference, the meeting roorn has to be allocated for the duration of the event.

You are free to add some more features to the database. In the design specification, you must explain and justify what features you have added to the database.

2. What you have to do?

You have to produce and submit the following THREE items:

1. An Entity-Attribute Diagram (see the diagram I as an example): This shows all entities in the above model, and for each entity, lists all attributes present along with the data type and size of each.

2. An Entity-Relationship Diagram (See the diagram as an example): This details the relationships between entities you have identified in Entity-Attribute Diagram (Entities in this section should be in outline forrn, with only the primary and foreign keys detailed in the entity)

3. A Design Specification that discusses and details:
- Database Design - Additional purposes that your database will address
- Referential Integrity - How is it maintained? (Primary, Foreign KeY, etC.)

Learning outcomes:

1) ANALYSE SITUATIONS AND/OR ENVIRONMENTS FOR THE APPLICATION OF DATABASE SOLUTIONS INCLUDING WEB CONNECTIVITY
2) CREATE, ALTER AND REMOVE RELATIONAL TABLES, INDEXES AND DATA USING AN APPROPRIATE DATABASE LANGUAGE.
3) EXPLAIN THE CENTRAL CONCEPTS OF DATABASE AND WEB DATABASE SYSTEMS, SECURITY ANDINTEGRITY.
CONSTRAINTS IN THE DESIGN OF DATABASES DUE TO ISSUES OF CONCURRENCY,
4) DESIGN AND JUSTIFY THE DESIGN OF DATABASE SYSTEM AND SELECT, JUSTIFY THE SELECTION AND EXPLOIT ANY ASSOCIATED UNDERPINNING TECHNOLOGIES, INCLUDING WEB BASED TECHNOLOGIES.

Assignment 2
- Students are required to work individually on their assignment.
- The assignment contributes SO marks to the overall assessment of the module.
- The assignment consists of two sections:
Section 1- contributes to 40 marks out of 100
Section 2 - contributes to 60 marks out of 100

1. A report (Soft EA Hard copy) section 1 & 2
2. Report should include the Entity Attribute Diagram (EAD), Entity Relationship Diagram (ERD, and database specification for section 1 and SQL codes, print screens of SQL codes a. c web forms for the section 2.Database and Web Database Systems

1. The Brief:
Using Oracle DBMS you are to implement the design outlined below, in which, following your submission of the required Structured Query Lauguage (SQL), script files as lusted below, you are to demonstrate your database in the presence of the module tutor. Please note that your database must be usable in the PC Labs of Gulf College.

Note: This assignment demonstrates your ability to implement and improve a database, from a given design. You are therefore required to implement the design as show

In Diagrams.

For higher marks, this design should be enhanced by the appropriate use of domains, access control mechanisms, additional tables for extra functionality etc. However, note that any amended structural design should still meet the specification outlined above. If you choose to add additional tables, you must supply a revised Entity-Relationship diagram

2. What you have to do,

You have to produce, submit and demonstrate the following THREE SQL tasks:

(i) A script to create tables and all other structural components (domains, access control)

(ii) A script to populate the database with appropriate sample data which will allow the testing of your database

(iii) A collection of individual SQL query scripts to execute a minimum of the following queries:

a. You have to store the salary details such as basic salary with data 2000.500. Do the necessary modifications in the initial design given and provide the screenshots and output.

b. List me employees with their co., name, qualification and total salary whose nationality is "Omani".

c. List the total number of employees working in each designation.(Hint: Use the "group by" clause]

d. Find the employees who draws the maximum salary. Display the employee details along with the nationality.

e. List the employee names. date of birth, date of joining, number of days attended in the month of January 2019.

(iv) Create two appropriate web forms to access the data. This should be done using Active Server

Pages(ASP/ASP.NET) technologies, not oracle web forms.

Attachment:- Database_Assignment.zip

Reference no: EM132173140

Questions Cloud

Emerging online piece of strategy for all of these firms : Discuss the emerging online piece of strategy for all of these firms as well as for WalMart and Target.

What can we say about the costs of financial distress : What can we say about costs of financial distress if predictions of trade-off theory are consistent with case of Mechanical Precisions and Stable Furniture

Describe how the crisis impacted other businesses : Provide examples of lessons managers need to keep in mind in the post-2008 business environment.

Is device independence important to the file manager : Is device independence important to the File Manager? Explain why or why not. Files can be formatted with fixed length fields or variable length fields.

Find the employees who draws the maximum salary : CE00318 - Database and Web Database Systems - Find the employees who draws the maximum salary. Display the employee details along with the nationality

Why should resources be a concern in a global strategy : Why should resources be a concern in a global strategy? What resources may be a concern in the country you selected?

Describe technology products that are affected by regulation : Examine and describe in your own words possible conflicts between government regulation for cybersecurity and technology innovation.

What is its productivity in widgets per dollar : Making 900 widgets takes eight hours of machine time at a cost of $200 per hour. What is it's productivity in widgets per dollar?

What evidence can you provide in support of your choice : What evidence can you provide in support of your choice? What evidence might somebody else, who does not agree with you.

Reviews

len2173140

11/21/2018 10:39:14 PM

All criteria in the previous bands have been achieved and: • Referential Integrity has been correctly implemented for all tables. • At least 3 sensible additional queries have been provided. All criteria in the previous bands have been achieved and: • Implementation is of an excellent standard. • Triggers have been used appropriately and with partial justification provided as comments in the script file • Procedures have been used and with partial justification provided as comments in the script file • Some of the additional queries perform cornplex database calculations (including outer joins, multiple inner joins, searching for records with null values) • Additional (relevant and non-superfluous) tables have been added to the database with a good justification as to their purpose (included as a comment in the source file)

len2173140

11/21/2018 10:39:02 PM

All criteria in the previous bands have been achieved and: • Executes all three mandatory queries correctly. • Referential Integrity has been mostly implernented. • Test data is sensible and appropriate, and sufficient in quantity to allow for testing of the database. • At least one additional (simple) query has been provided. • All additional queries have a sensible description of purpose (as an accornpanying text file, or clear comment in source code).

len2173140

11/21/2018 10:38:54 PM

All criteria in the previous bands have been achieved and: • Executes 2 of the mandatory queries correctly. • Database population script inserts several rows of relevant test data into all tables • Referential integrity has been attempted. • Implemented database corresponds with (or exceeds) given E-R diagram with no structural errors

len2173140

11/21/2018 10:38:40 PM

AII criteria in the previous bands have been achieved and: • The database has been demonstrated during the workshops, or as arranged in advance with the tutors. • Database population script inserts sorne test data into all tables. • All three of the mandatory queries have been attempted and submitted. • Executes at least 1 of the mandatory queries correctly. Implemented database corresponds with (or exceeds) gwen E-R diagfar, with at mOSt taWY minor structural errors

len2173140

11/21/2018 10:38:32 PM

Note: These criteria are provisional and may be subject to alteration: • Script files submitted in the required format. • Database creation script creates a new database • Database creation script creates all tables (though not necessarily with correct column specifications) • Database population script inserts data into at least 4 tables. • At least 1 of the mandatory queries has been attempted and submitted. • Work shows reasonable academic referencing, including a bibliography where regulr.l.

len2173140

11/21/2018 10:37:50 PM

All criteria in the previous bands have been achieved and: • Primary keys have been defined for most of the entities. • Correct Foreign keys have been defined where approPnate in most of the entities. • The entity-relationship diagram shows most relationships resulting frorn identified primary and foreign keys. • Design document lists at least 3 other (potential) purposes of the database. • All Robustness in the construction of the database has been listed. • Work shows reasonable academic referencing, including a bibliography where required.

len2173140

11/21/2018 10:37:37 PM

• Entity-Attribute diagram, Entity-Relationship diagram and design document submitted in the required format. • At least 4 relevant entities identified (and shown in both EohtY-Ati..te a"d diagram). • For each entity, some attributes have been identified and specified. All criteria in the previous bands have been achieved and: • Primary keys have been defined for some entities. • For each entity the main attributes have been identified and specified. • The entlt,relationship diagram shows most relationships resulting from idened prima, and foreign keys. • Design docurnent lists at least 2 other (potential) purposes of the database.

len2173140

11/21/2018 10:37:21 PM

Assignments must be submitted by the due date. The only circumstance in which assignments can be submitted late Is if an extenuating circumstances form is submitted at the same time. In these circumstances work may be submitted up to 2 weeks late only. If the extenuating circumstances are upheld, the assignment will be graded; otherwise, a 0 will be awarded.

len2173140

11/21/2018 10:37:14 PM

You should hand in one copy of your assignment/project by the time and date mentioned above to the appropriate 'hand-in location' at Gulf College. Fill in the front cover (stapled together with your assignment). MAKE SURE that you fill in all the relevant details on this form. An acknowledgement will be given to you upon receiving your assignment. This is your receipt, keep it. You can submit work by post, but you must send it recorded delivery, it must be postmarked two days before the deadline date and a copy must be kept by you in case it is lost in the post. Faxed assignments will not be accepted.

Write a Review

Required(*) Message

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

User Account

All Pages