Graduate Essay Writers
Only the most qualified writers are selected to be a part of our research and editorial team, with each possessing specialized knowledge in specific subjects and a background in academic writing.
Get Similar Asssignment Answers, Essays & Custom Paper Writing Services
To hire a writer, fill the order form with details from your nursing assessment task brief—assignment instructions.
Posted: September 20th, 2023
Design a generalization-specialization hierarchy for a motor-vehicle sales
Q1] Design a generalization-specialization hierarchy for a motor-vehicle sales company. The company sells motorcycles which have an engine number and cost; cars which have a chassis number, an engine number, seating capacity and cost; trucks which have chassis number, an engine number and cost.
Q2] Map the following ER diagram to a relational database. Give the relation names and attributes in them. Also mention the primary key and foreign keys if any for each table.
Q3] Given the dependency diagram shown in the following figure, (the primary key attributes are underlined)
(i) Identify and discuss each of the indicated dependencies.
(ii) Create a database whose tables are at least in 3NF, showing dependency diagram for each table
Q4] The entity set EMPLOYEE is a generalization of the entity sets FULL_TIME_EMPLOYEE and PART_TIME_EMPLOYEE. The former is a generalization of the entity sets FACULTY with attributes degree and subject of interest and STAFF with attribute classification; the latter, is a generalization of the entity sets TEACHING with attribute stipend and CASUAL_FACULTY with attribute hour rate. STAFF inherits the attribute Salary of the entity set FULL_TIME_EMPLOYEE and the latter, in turn, inherits the attributes of EMPLOYEE. FULL_TIME_EMPLOYEE is a specialization of the entity set EMPLOYEE and is differentiated by the additional attribute Salary. Similarly, PART_TIME_EMPLOYEE is specialization differentiated by the presence of the attribute Type. Each employee must have attributes empno, name and hire_date.
(i) Draw an E-R diagram for the system.
(ii) Convert this E-R diagram to relational tables.
Q5] The tourism department wishes to computerize its data. The information consists of monuments of tourist interest, their location and history. Monuments are classified according to historical, religious and architecture importance. The list of facilities available at each sport is also available. These give (i) living accommodation in terms of hotels, their names, category and the number of rooms available and (ii) local transport facilities in terms of service provider name, tours with their tariff and timing. Arrive at an E-R diagram by identifying the entities, relationships, attributes, primary keys and cardinality
Why Seek Our Custom Writing Services
Every Student Wants Quality and That’s What We Deliver
Affordable Prices
Our prices strike the perfect balance between affordability and quality. We offer student-friendly rates that are competitive within the industry, without compromising on our high writing service standards.
100% Plagiarism-Free
No AI/chatgpt use. We write all our papers from scratch thus 0% similarity index. We scan every final draft before submitting it to a customer.
How it works
When you decide to place an order with Nursing Study Bay, here is what happens:
For Similar Answers, Custom Essay Writing & Assignment Help Services
Find an expert by filling an order form for your nursing paper. We write AI-plagiarism free essays and case study analysis. Anytime!