Question

In: Accounting

1. draw a UML diagram that describes the Tablet Store's purchases and payment process. 2. using...

1. draw a UML diagram that describes the Tablet Store's purchases and payment process.

2. using microsoft access implement a relational database from your UML class diagram. Identify at least three fields per table.

3. describe how you would use the relational database to determine the Tablet store's account payable

Solutions

Expert Solution

Answer:-

1-

.

2-

.

3-

In relational database, it’s easy to eliminate redundancy and inconsistencies. Both the sales and accounts payable departments may look up information about the customers. The information about the company such as Dells, Apple and Samsung are entered only once where both departments can access.
Relational database stores and retrieves data which is stored in tables. It stores interrelated data. This interrelationship therefore helps in querying the information about payments, invoices ,and receipts hence it helps in determining the accounts payable. The relational database therefore helps in query the information which includes the tax system. This system helps in determining the accounting phenomena as well as setting objects with similar properties.


Related Solutions

Draw a UML diagram that describes a class that will be used to describe a product...
Draw a UML diagram that describes a class that will be used to describe a product for sale on Glamazon.com. The product has a name, a description, a price, ratings by many customers (1 to 5 stars), and a group of customer comments. New products have no ratings or comments by customers, but do have a name, description and price. The price can be changed and more customer ratings and comments can be added. A global average rating of all...
create the UML Diagram to model a Movie/TV viewing site. Draw a complete UML class diagram...
create the UML Diagram to model a Movie/TV viewing site. Draw a complete UML class diagram which shows: Classes (Only the ones listed in bold below) Attributes in classes (remember to indicate privacy level, and type) No need to write methods Relationships between classes (has is, is a, ...) Use a program like Lucid Cart and then upload your diagram. Each movie has: name, description, length, list of actors, list of prequals and sequals Each TV Show has: name, description,...
Draw a UML diagram for the classes. Code for UML: // Date.java public class Date {...
Draw a UML diagram for the classes. Code for UML: // Date.java public class Date {       public int month;    public int day;    public int year;    public Date(int month, int day, int year) {    this.month = month;    this.day = day;    this.year = year;    }       public Date() {    this.month = 0;    this.day = 0;    this.year = 0;    } } //end of Date.java // Name.java public class Name...
Draw the diagram (ER / MR / UML) for a database containing the following characteristics: •...
Draw the diagram (ER / MR / UML) for a database containing the following characteristics: • Presence sensor that stores presence information with its timestamp and its location. • Distance sensor that saves distance information with its timestamp and its location. • An actuator of a switch that energizes a bulb, where the record of its been with your timestamp and your location. • An actuator of a motor that opens a door, where the record of its been with...
(Using Date Class) The following UML Class Diagram describes the java Date class: java.util.Date +Date() +Date(elapseTime:...
(Using Date Class) The following UML Class Diagram describes the java Date class: java.util.Date +Date() +Date(elapseTime: long) +toString(): String +getTime(): long +setTime(elapseTime: long): void Constructs a Date object for the current time. Constructs a Date object for a given time in milliseconds elapsed since January 1, 1970, GMT. Returns a string representing the date and time. Returns the number of milliseconds since January 1, 1970, GMT. Sets a new elapse time in the object. The + sign indicates public modifer...
(Using Random Class) The following UML Class Diagram describes the java Random class: java.util.Random +Random() +Random(seed:...
(Using Random Class) The following UML Class Diagram describes the java Random class: java.util.Random +Random() +Random(seed: long) +nextInt(): int +nextInt(n: int): int +nextLong(): long +nextDouble(): double +nextFloat(): float +nextBoolean(): boolean Constructs a Random object with the current time as its seed. Constructs a Random object with a specified seed. Returns a random int value. Returns a random int value between 0 and n (exclusive). Returns a random long value. Returns a random double value between 0.0 and 1.0 (exclusive). Returns...
(1) Draw the diagram showing the relationship between SAC and LAC. (2) Draw the diagram showing...
(1) Draw the diagram showing the relationship between SAC and LAC. (2) Draw the diagram showing the relationship between SMC and LMC.
Draw a detailed diagram of the TLC process
Draw a detailed diagram of the TLC process
1. Draw and label the band diagram for Carbon Monosulfide anion(CS^-) 2. Draw the MO diagram...
1. Draw and label the band diagram for Carbon Monosulfide anion(CS^-) 2. Draw the MO diagram for Carbon Monosulfide anion (Cs^-) and give bond order.
Pick any TWO of the following and draw a UML activity diagrams modeling: The process of...
Pick any TWO of the following and draw a UML activity diagrams modeling: The process of buying groceries, starting with making a shopping list. The process of making a sandwich. The process of making a schedule and registering for classes. The process you went through to apply for college. Your diagram should have concurrent flows. The process of two people washing a car. Include concurrent actions in your model. Please draw and explain clearly with good hand writing. Will upvote!...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT