I am trying to create an EER model for a database, but I am unsure of how to go about it. I am currently learning out of a book and trying the end-of-chapter exercises and I am finding myself more and more confused.
The exercise I am trying to complete is the following:
Use MySQL Workbench to create an EER model for a database that stores information about the downloads that users make. Create the tables that are necessary to create this data structure:
Each user must have an email address, first name, and last name.
Each user can have one or more downloads.
Each download must have a filename and download date/time.
Each product can be related to one or more downloads.
Each product must have a name.
I guess you can say creating the table is my issue. I know how to create a table and open it for editing. I just don't know how I enter the information correctly. First time attempting and I am just super confused, so any tips would be great. I wish I could better explain my situation. I guess looking at all the data input fields in the table is overwhelming. Not sure how to properly name the table and how to store the information in each table.
question from:
https://stackoverflow.com/questions/65896382/mysql-eer-database-model-that-stores-download-information 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…