Show attributes and include relationship and connectivity

Assignment Help Database Management System
Reference no: EM13682019

Question 1:

Design an ER diagram for a Wacky University student database.

1.  List Entities
2.  List Attributes
3.  List Relationships and cardinalities
4.  Draw ER Diagram

Show all attributes and include relationship and connectivity. Convert all M:N relationships into entities. You are to use Crow's Foot notation showing all attributes for each entity and naming each relationship. Do not show M:N relationship, convert it into 1:M&N:1 relationship

The business rules for the ER model are as follows.

1.            A university has many departments. Each department employs one or more lecturers (at least one), and each lecturer may work in many departments.

2.            A lecturer teaches exactly one subject, and a subject is taught by at least one lecturer.

3.            Each lecturer will only have one title i.e. Lecturer A, Lecturer B, Senior Lecturer, Associate Professor, Professor.

4.            Students may study 0 subjects or only 1 subject, and a subject must have at least one student enrolled in it for the subject to run. Students will receive a Grade for the subject they are enrolled in.

5.            Each student must have one or more academic advisors. An academic advisor is a lecturer. An advisor may advise zero or many students.

6.            A lecturer may only supervise a maximum of one other lecturer. However a lecturer may be supervised by zero or many lecturers.

Attributes that need to be included in your ERD are: DepartNo, DepartName, LectNo, LectName,LectAddress, LectPhoneNo, LectTitle, SubCode, grade, SubName, StudNo, StudName, StudAddress, StudDOB

Question 2

1.            Write Business rules to create ERD as given in Question 1.

2.            List Entities, Attributes and Relationships

3.            Design an ER diagram for the problem scenario given below.4.   Convert your ERD into the relational data model (RDM) using the guidelines from as follows.

Table_Name( attribute_1, attribute_2, attribute_3, ..... ,attribute_x) Primary Key ( attribute_1, attribute_2)

Foreign Key attribute_4 References Table_Name_2 (repeat for each foreign key)

Alternate Key (attribute_5, attribute_6) (repeat for each alternate key) Additionally primary keys should be underlined.

Qantas Airlines has asked you to create a database for their airline operations i.e. its flight and airplane history. Hopefully they are in a position to pay your database design fee.

Reference no: EM13682019

Questions Cloud

Valuation of accounts receivables : Valuation of Accounts Receivables
Accounting for revenue on an accrual basis means : 1. Accounting for revenue on an accrual basis means that no entry of revenue is made until the cash is actually received.
Determine the muzzle speed of the pellet : A spring in a toy gun has a spring constant of 9.05 N/m and can be compressed 16 centimeter beyond the equilibrium position. Determine the muzzle speed of the pellet
Evaluate what the amplitude of the motion : The position of a 0.30 kilogram object attached to a spring is described by the following equation: x = (0.23 m)cos(0.4t), Evaluate what the amplitude of the motion
Show attributes and include relationship and connectivity : Show all attributes and include relationship and connectivity. Convert all M:N relationships into entities. You are to use Crow's Foot notation showing all attributes for each entity and naming each relationship. Do not show M:N relationship, convert..
Using the direct method : A building with a book value of $54,000 is sold for $63,000 cash. Using the direct method, how should the transaction be shown on the statement of cash flows?
Determine the largest resultant amplitude that can occur : A wave of amplitude 0.25 meter interferes with a second wave of amplitude 0.13 meter traveling in the similar direction. Determine the largest resultant amplitude that can occur
Find the amplitude at a point on the string : A series of pulses of amplitude 0.22 meter is sent down a string that is attached to a post at one end. Find the amplitude at a point on the string where two pulses are crossing, if the string is rigidly attached to the post
Determine with what frequency do the waves hit the boat : Ocean waves are traveling to the east at 4.9 meter per second with a distance of 21 meter between crests. Find with what frequency do the waves hit the front of a boat when the boat is moving westward at 1.2 m/s

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

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!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd