This is not an academic assignment.
This question involves the logical design of a database (entities and attributes). Do you agree with the proposed model? Is the attribute for the text of the e-mail message body correct?
I am using the Oracle SQL Developer Data Modeler to learn how to create an ERD. The report is attached.
I am designing a database that will be used to track the emails that are contained in PDFs. Numerous emails are printed to a single PDF file. Each PDF contains numerous emails. The PDFs are not going to be stored in a database. Only the file path and file name will be tracked. This will be a single user database.
Sent e-mails. The following will be tracked:
1) The date and time the e-mails were sent.
2) The sender’s first and last name.
3) The text of the message body will be copied into a field.
E-mail Images. The following will be tracked:
1) An image of every e-mail. A multipage PDF will contain an image of every e-mail.
2) The e-mail image file path.
Here is a sample report:
Sender: Mary Smith
Time: 4:00 p.m.
Email Contents: .. text from e-mail...
Description: The particular email message that is being tracked.
The text of the message body will be copied into a field. Attributes:
Email ID --An arbitrary unique sequential number assigned to every email. arbitrary unique sequential number assigned to every email.
Date sent --The date on which the email was sent.
Time sent --The time that the email was sent.
Body Text --The text contained in the email message.
Description: A standard-format PDF file used to hold emails.
Numerous emails are printed to a single PDF file.
PDFs are currently not stored in a database; they are stored as standard PDF files.
File Id --arbitrary unique sequential number assigned to every file name. File names alone may not be unique, since the same file name could be stored in different paths.
File Name --Physical name of the file, excluding file extension.
Path Id --identifier that specifies the drive and path to the file.
File Type Id --Physical file type; typically this will correlate to the file extension, but that’s not actually required. For example, a ‘[.]txt’ file could actually [.]csv-format data and vice-versa.
Entity: File Types
Description: Type of file details. Will include the default extension and a brief description of the file type.
File Type Id --arbitrary unique sequential number assigned to each unique File Type
Default Extension --default extension for this type of file: ‘PDF’ for pdf files.
File Type --standardized description of the the file type: ‘PDF’.
Description: The path of a file. Example: c:\email\. This does NOT include the file name, which is part of the file data.
Path Id --arbitrary unique sequential number assigned to each unique path.
Path --the remainder of the physical path to the file
Drive --The “drive” name; may be a single letter, a share, a volume mount point, etc.
Here is the ERD