Structuring system data requirements - including conceptual data models for the "as-is" system using E- R modeling tools.
Create a Entity-relationship (ERD) assignment (AS-IS) for Petrie Electronics.
Entity-relationship (ERD) assignment (AS-IS) for Petrie Electronics :
_____________________________________________________
Please up vote this answer. Thank you so much. Your up vote is so valuable to me.
Structuring system data requirements - including conceptual data models for the "as-is" system using E- R...
Designing improved processes for the "to-be" system through level 2 using data flow diagrams. Create a Data flow diagram (DFD) assignment (To-BE) for Petrie Electronics.
create a Data flow diagram (DFD) assignment (To-BE) for Petrie electronics system.
3. b) Construct an appropriate conceptual Entity Relationship Diagram (ERD) for the requirements specified below. The Chen notation should be used to create the diagram. An insurance company has customers and offers products. When a customer takes out insurance they buy a policy. The minimum amount of information on the policy is the type of insurance taken out, the annual premium and the full name of the insured. A so called insured person does not necessarily have to be a...
create three preliminary models for Credential Management System using modeling tools. For the preliminary models, since they are nonfunctional, you can use Lucid Chart, PowerPoint, or Visio. Each of the three preliminary models is worth 10 points. The models will be graded on: Clearly defined model title (1 pt) At least three subsystems identified (3 pts) The professionalism of design [the design appear ready for production] (3 pts) Shapes and elements are appropriate and professional (3 pts)
Project: Relational Modeling Note: This project must be unique in its design (E-R diagram) and implementation (SQL queries). You are not to copy or use any part of a database project that was previously submitted or appears on the Web, in a textbook, or otherwise made available via an external source. Contact your instructor if you have any questions regarding this requirement. Deliverables for Part 1: (1) Project Description. Provide an overview of your project identifying the major components as...
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...
First, draw an EER that models the given
requirements.
You will play with the Bank Database in this homework. Please download and execute the bank.sql from Canvas to create this database in your MySQL system. Please submit the results as a zip file with a name <yourname>-bank.zip. Consider modeling a bank: . The bank keeps personal information of each customer including name, sex, address, phone number, social security number, and date of birth. . Each customer owns one or more...
Sample data is provided for the database for the sales system. Using the sample data, you will determine the entities, key components of the entities, and business rules for the entities. Using the entities and business rules you will then create an ERD. Tasks: 1. For each entity provide the name, description, fields, data type, primary key, and foreign key. 2. For each direct entity type pair, provide the business rules. 3. Provide the ERD. Customer Table Customer ID, Last...
The Hudson Engineering Group (HEG) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company’s training program. The HEG administrator gives you the description (see below) of the training group’s operating environment. (Hint: Some of the following sentences identify the volume of data rather than cardinalities. Can you tell me which ones?) The HEG has 12 instructors and can handle up to 30 trainees per class. HEG offers five Advanced Technology...
Using your answer to Case Question 7-50, draw the relationships between entity types needed by the system. Remember, a relationship is needed only if the system wants data about associated entity instances. Give a meaningful name to each relationship. Specify cardinalities for each relationship and explain how you decided on each minimum and maximum cardinality at each end of each relationship. State any assumptions you made if the Petrie’s Electronics cases you have read so far and the answers to...