4.3t Relationship Sets
Description
4.3t Relationship Sets
for each of the following questions, draw a data model showing a relationship between entities, a relationship set of the relationship, and attributes of the relationship set.
Your teacher will provide instructions on how to submit your homework – either with paper submission or electronic file upload.
Possible options include:
1. Hand drawn solutions – can be a paper submission or scanned and uploaded as a pdf file.
2. Computer based drawing tool – can be a printed submission, or saved as a pdf file or as jpg images and inserted into a Word Document – and uploaded.
2.1 A powerful and free diagramming tool that runs in a browser is available at Lucid Chart: Saves the data in Lucid Chart Cloud. https://www.lucidchart.com/ Links to an external site.
2.2 A popular Chrome App Plug-In drawing tool called Gliffy – (Requires Chrome) Can save data on local drive. https://chrome.google.com/webstore/detail/gliffy-diagrams/bhmicilclplefnflapjmnngmkkkkpfad?hl=enLinks to an external site.
2.3 Some teachers prefer Microsoft Visio. You can get a trial version here: Not web based. All work and data saved locally. https://products.office.com/en-us/visio/visio-professional-free-trial-flowchart-software
EdiStudents take classes and get grades in those classes.
1. Students take classes and get grades in those classes.
2. Sections of courses are offered at specified times and in specified rooms and buildings.
3. Each school term can be represented as a season (Fall, Winter, Spring, Summer) and a year begins and ends on specified dates.
4. Each day, employees work some number of hours.
5. People subscribe to magazines and their subscriptions have beginning and ending dates
.6. Pilots have a certain number of hours of training on each type of aircraft.
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."