IST 412 Medical Marijuana Registry Database Design

IST 412-001 (Sissom) Spring 2021  

Part One: Medical Marijuana Registry Database Design

Many states have created a Medical Marijuana Registry' that allows a patient to link with a provider to obtain marijuana for medical purposes. You have been asked to design a database for a portion of this operation. The facts given below are the result of many user interviews and should be used to design the database. A copy of registry for a particular patient is as follows:

Be sure to complete the design considering the following facts:

  • Show only primary key/unique identifiers (no foreign key type relationships in drawings), remember that Visual Paradigm will place foreign keys automatically.
  • Many states can have Medical Marijuana Registries but not all states will.
  • A Medical Marijuana Registry will belong to only 1 state.
  • Each individual registry will contain only 1 provider and only 1 patient.
  • Show the attributes in the Registry above, and perhaps you can identify others (in Illinois), and surrogate keys (if needed).
  • Draw the relationships (ID dependent and non-ID dependent) between entities (using Visual Paradigm).
  • Enter the correct minimum and maximum cardinality using the crow’s feet design
  • If a relationship has a M:M relationship, then break it down using an associative/bridge entity.

Complete the following requirements:

  • Draw a rough ERD (Conceptual Data Model) between the following given entities using the facts stated above. Be sure to show the maximum and minimum cardinality.

Place your solution into Visual Paradigm and copy-and-paste into this document or place the .vpp directly into the drop box.

If you sketch a solution and would like to scan and upload that portion as well, please feel free to do so (optional).

Part Two: Pirate University

Pirate University provides educational classes to students.  You have been asked to design a database showing the entities and their relationships to facilitate this operation.  The facts given below are the result of many user interviews and should be used to design the database.  Be sure to complete the following:

  • You are to determine the entities and fields needed for this database.
  • Use surrogate keys as needed.
  • Draw the relationships between each entity using the crow’s foot design.
    • If any relationship has a many-to-many cardinality then you are to create an intersection table between the two.
  • Do not worry about including foreign keys (Visual Paradigm will auto-generate).
  • Use Visual Paradigm to complete this assignment.

Pirate University facts you should use to design the database are:

  • The university can have many departments, but a department will belong to only 1 university
  • A professor will teach in only one department, but a department can have many professors.
  • A student will belong to only one department, but a department can have many students.
  • A department will provide many courses, but a course will be taught by only one department.
  • A professor can teach many courses and a course can be taught by many professors.

A student can take many courses and a course can be taken by many students.

Complete the ERD using the facts stated above. Be sure to break down all many to many relationships.


Upload Document Document Unser Evaluion Get Money Into Your Wallet

Cite This work.

To export a reference to this article please select a referencing stye below.

Assignment Hippo (2022) . Retrive from

"." Assignment Hippo ,2022,

Assignment Hippo (2022) . Available from:

[Accessed 15/08/2022].

Assignment Hippo . ''(Assignment Hippo,2022) accessed 15/08/2022.

Want latest solution of this assignment

Want to order fresh copy of the Sample Template Answers? online or do you need the old solutions for Sample Template, contact our customer support or talk to us to get the answers of it.

Submit Your Assignment Here

AssignmentHippo Features

On Time Delivery

Our motto is deliver assignment on Time. Our Expert writers deliver quality assignments to the students.

Plagiarism Free Work

Get reliable and unique assignments by using our 100% plagiarism-free.

24 X 7 Live Help

Get connected 24*7 with our Live Chat support executives to receive instant solutions for your assignment.

Services For All Subjects

Get Help with all the subjects like: Programming, Accounting, Finance, Engineering, Law and Marketing.

Best Price Guarantee

Get premium service at a pocket-friendly rate at AssignmentHippo


  • Assignment Writing Guide
  • Essay Writing Guide
  • Dissertation Writing Guide
  • Research Paper Writing Guide


  • Accounts
  • Computer Science
  • Economics
  • Engineering

Client Review

I was struggling so hard to complete my marketing assignment on brand development when I decided to finally reach to the experts of this portal. They certainly deliver perfect consistency and the desired format. The content prepared by the experts of this platform was simply amazing. I definitely owe my grades to them.

Tap to Chat
Get instant assignment help