ZuoTi.Pro
Question

I need a simple star schema design for a public defender's office. Dimensions would be Case,...

I need a simple star schema design for a public defender's office. Dimensions would be Case, Client, Attorney and Date, for starters with each case having start / finish dates and start / finish dates for each attorney's involvement.

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Fact: Publice Defender's Office
Public Defender's Office (CaseID, AttorneyID, ClientID, DateID, CaseType, RoomNumber)
Dimensions: Case, Client, Attorney, Date
Case (CaseID Primary Key, Name, Description, StartDate, FinishDate)
Attorney (AttorneyID Primary Key, LicenseNumber, FirstName, LastName, PhoneNumber, CaseInvolvement, StartDate, FinishDate)
Client (ClientID Primary Key, FirstName, LastName, PhoneNumebr, Address)
Date (DateID Primary Key, StartDate, FinishDate, Time)

0 0
Add a comment
Know the answer?
Add Answer to:
I need a simple star schema design for a public defender's office. Dimensions would be Case,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • SYSTEM ANALYSIS AND DESIGN CLASS ... ( HELP PLEASE I NEED THIS NOW......I WILL RATE!!!!) Chapter...

    SYSTEM ANALYSIS AND DESIGN CLASS ... ( HELP PLEASE I NEED THIS NOW......I WILL RATE!!!!) Chapter 8 Homework (DIAGRAMS NEEDED) PLEASE!!! Scenario: Sweetbriar College is redesigning their course registration system [CRS]. They plan for this system to be web-based, but first you need to model the main system behind the web interface. Here is a description of the interactions with the proposed CRS. Faculty enter courses into the system, assign section numbers, instructors, dates, times, and classrooms for individual instances...

  • As auditor of the Star Manufacturing Company, you have obtained a trial balance taken from the...

    As auditor of the Star Manufacturing Company, you have obtained a trial balance taken from the books of Star one month before year-end: Requirement Which accounts should be confirmed with outside sources? Briefly describe from whom they should be confirmed and the information that should be confirmed EB (Click the icon to view the trial balance.) There are no inventories consigned either in or out. All notes receivable are due from outsiders and held by Star. (To identily the information...

  • Hello I need to Convert the ER Diagram to a relational model. Analyze each table to...

    Hello I need to Convert the ER Diagram to a relational model. Analyze each table to make sure that they are in 3rd Normal Form. Write the level of normalization for each table and state in your report why it is an acceptable level of normalization. Physical Database Design: identify the data types of each columns (in each table). Gender Register Date Name Doctor ID Patient ID Room No Patient Salary qualification Consults Tel No DOB Staff Name Gender Staff...

  • I NEED HELP with this. please create a UML diagram. I need a simple code to...

    I NEED HELP with this. please create a UML diagram. I need a simple code to solve the problem.   The ADT Bag is a group of items, much like what you might have with a bag of groceries. In a software development cycle, specification, design, implementation, test/debug, and documentation are typical activities. The details are provided in the rest of the document. ADT Bag Specification: (Note: You should not change the names of the operations in your program. This should...

  • Hello, I am wondering what the source code for this problem would be. Thank you so...

    Hello, I am wondering what the source code for this problem would be. Thank you so much. You will write a java program using the Eclipse IDE. The program will allow a user to perform one of two options. The user can look up the dates for a given zodiac sign or enter a date and find what sign corresponds to that date. SIGN START DATE END DATE Aries 3/21 4/19 Taurus 4/20 5/20 Gemini 5/21 6/20 Cancer 6/21 7/22...

  • answer question 6 with simple explanation and simple mechanism Case Study Questions I. Cocaine (in the...

    answer question 6 with simple explanation and simple mechanism Case Study Questions I. Cocaine (in the form of cocaine hydrochloride) but not by smoking. However, the free this? une form of cocaine hydrochloride) is usually consumed by drinking, snorting, or injecting, by smoking. However, the free base form of cocaine is smoked. What is the likely reason for 2. The late comedian Richard Pryor performed a skit poking fun at himself for an caused an explosion and ignited himself attempting...

  • I Need UML Design for the following Java code: Colorable interface: public interface Colorable { //a...

    I Need UML Design for the following Java code: Colorable interface: public interface Colorable { //a void method named howToColor(). void howToColor(); } GeometricObject class: public class GeometricObject { } Sqaure class: public class Square extends GeometricObject implements Colorable{ //side variable of Square double side;    //Implementing howToColor() @Override public void howToColor() { System.out.println("Color all four sides."); }    //setter and getter methods for Square public void setSide(double side) { this.side = side; }    public double getSide() { return...

  • Need help writing beginner C# program, I will make sure to provide feedback to whoever can...

    Need help writing beginner C# program, I will make sure to provide feedback to whoever can help me figure it out! No public or global variables should be used. You need to consider passing arguments between the methods according to the ways described in the lecture. i.e. all variables should be declared inside the methods and passed to other methods by value/ref/out as needed Description: We want to design a Date class to represent a date using three integer numbers...

  • I would like to know how to fill in this sheet from these screen shots The...

    I would like to know how to fill in this sheet from these screen shots The one more requirement is the the ledger account. Snip & Sketch New 2 5 Problem 2-2A Preparing General Journal entries LO3,5,6 Bruce Ibach owns Biotech Fitness Centre, which showed the following selected transactions for the month ended May 31, 2021 May 2 1 Purchased new equipment, paying cash of $14,000 and signing a 90-clay note payable for the balance of $32,000. Prorchased 12 months...

  • (Please do not copy and paste from another question. I am new to this and need...

    (Please do not copy and paste from another question. I am new to this and need it to be simple) Draw an ERD for a “Hospital” with many departments and employees in each department. show things like (one to one, one to many, many to many). What attributes would you store regarding each objects/class/data entities? Thank you! (Example) FIGURE 4-10 An ERD for a bank with many branches Customer cust number-PK name bill address home phone office phone = Account...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT