Question

Assignment 3.2 - Data Modeling in Action Develop a conceptual and logical model for a book...

  • Assignment 3.2 - Data Modeling in Action
    Develop a conceptual and logical model for a book tracking system with the following requirements:
  1. Use Microsoft Visio (available on the Sullivan VDI – https://desktop.sullivan.edu) or Lucidchart
  2. Create a conceptual data model
  3. Create a logical data model
  4. The data model is about a book tracking system with the following objects:
  • Book
  • Publisher
  • Author
  • Store
  1. Relationships:
  • A book can have one or many publisher
  • A book can have one or many author
  • A book can be sold at zero or many store
  1. Object attributes
  • You need to come up with 4 attributes for each object (book, publisher, author, and store)
  1. Document all these steps in an APA word document
  • Describe how you create each model
  • Describe tools you use for each model
  • Describe each model
  • Include your model diagrams as appendixes
0 0
Add a comment Improve this question Transcribed image text
Answer #1


PLEASE FIND THE ANSWER(S) and EXPLANATION BELOW.

Add a comment
Know the answer?
Add Answer to:
Assignment 3.2 - Data Modeling in Action Develop a conceptual and logical model for a book...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

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
  • home / study / engineering / computer science / computer science questions and answers / this...

    home / study / engineering / computer science / computer science questions and answers / this is a data modeling exercise i am assigned a project as a dba to design a data model to ... Question: This is a Data Modeling exercise I am assigned a project as a DBA to design a data model to suppo... This is a Data Modeling exercise I am assigned a project as a DBA to design a data model to support a...

  • create a database, and create tables with the following requirements: 1) The physical data model is...

    create a database, and create tables with the following requirements: 1) The physical data model is about the book tracking system with the following objects: Book Publisher Author Store 2) Relationship Different to last week assignment, the changes in the relationship are: Book and publisher have a many to many relationship Book and author have a many to many relationship 3) Change the physical data model of last to account to the many to many relationship using: Junction tables Foreign...

  • database management 4.6u Dental Office Data Model For each of the following problems, create a conceptual...

    database management 4.6u Dental Office Data Model For each of the following problems, create a conceptual data model, consisting of object sets, relationships, attributes, and so on, that can be used to answer questions similar to the questions given. Indicate cardinalities. PLEASE NOTE YOU WILL SUBMIT YOUR COPY USING ONE OF THE FOLLOWING METHODS Your Choice) to me USING THE UPLOAD LINK! Possible options include: 1. Hand drawn solutions can be a paper submission or scanned and uploaded as a...

  • Logical Data Modeling - Question 1: Normalize the logical data model step by step, i.e. 1st...

    Logical Data Modeling - Question 1: Normalize the logical data model step by step, i.e. 1st NF->2nd NF->3rd NF. (First Normal Form, Second Normal Form and Third Normal Form) Question 2: Draw the ERD (Entity Relationship Data) after you normalize the system to the 3rd NF The physician Master File from a DFD (Data Flow Diagram) contains the following data elements: Social Security # Physician ID Last_Name First_Name Mid_Init Hospital_Resident_ID Hospital_Resident_Name Hospital_Addr_Line1 Hospital_Addr_Line2 Hospital_State Hospital_City Hospital_ZIP Specialty_Type Specialty_Name Specialty_College Date_Graduated...

  • Consider an ABC digital library that manages technical books, the data requirements are summarized as follows:...

    Consider an ABC digital library that manages technical books, the data requirements are summarized as follows: A book is identified by its ISBN number, and it has a title, a price, and a date of publication. It is published by a publisher, which has its own ID number and a name. Each book has exactly one publisher, but one publisher typically publishes multiple books over time. A book is written by one or multiple authors. Each author is identified by...

  • Use MySQL Workbench to create a simple ER model and use the Forward Engineering functionality of...

    Use MySQL Workbench to create a simple ER model and use the Forward Engineering functionality of Workbench to create a simple DB (specs follow). This focuses on how MySQL Workbench is used to create a model and then a DB from it, rather than on ER modeling. The sample model you are to create is on books, authors, and publishers - a model that could be part of a larger ER model for a library. A book has an ISBN...

  • 1) Create Conceptual Schema Diagram 2) Create a fully attributed Loagical Data Model Diagram 3) Create...

    1) Create Conceptual Schema Diagram 2) Create a fully attributed Loagical Data Model Diagram 3) Create the SQL script that will generate the data model Develop an EER model for the following situation using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor: Wally Los Gatos and his partner Henry Chordate have formed a new limited partnership, Fin and Finicky Security Consultants. Fin and Finicky consults with corporations to determine their...

  • Your hypothetical employer, X University, is pleased with feedback you offered on suggestions about potential types...

    Your hypothetical employer, X University, is pleased with feedback you offered on suggestions about potential types of databases and is also please with your suggestions on various Systems Development Life Cycle methodologies. This would be a relational database model for a payroll system that will be standalone but will need to have ability to communicate with other ODBC and SQL Server databases. The overall purpose of the database will be to input employee data for 100-150 employees. The database will...

  • Please complete a high level conceptual model for Henry's Books. You need only show the entities,...

    Please complete a high level conceptual model for Henry's Books. You need only show the entities, relationships, cardinalities, and main attributes. All attributes are necessary. Walter Henry owns a chain of bookstores called Henry's Books. Henry gathers and organizes information about publishers, authors, and books. Each book has a unique code. The bookstore records the title, book description, style, price, and whether the book is a paperback. He also needs the number of units that reside in each of four...

  • For this assignment, you should create an Entity Relationship Diagram (ERD) in Visio that shows a...

    For this assignment, you should create an Entity Relationship Diagram (ERD) in Visio that shows a many-to-many relationship between DeVry University students and their classes. Since one student can have many classes and each class can have many students, you will need to create an associative entity to store the specific Student_Class data such as grade and attendance. Create the tables as well as the relationships. Don't forget to indicate the Primary Key and Foreign Key in each table. Tables...

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