Design a database, Design a database using the following

Design a database

Assignment Help Basic Computer Science

Reference no: EM132726753

Design a Database

Design a database using the following information. Using Microsoft Visio 2013, create a complete E-R Diagram in Crow's Foot notation (including entity names, attributes, primary keys and foreign keys) that can be implemented, and then implement it in Microsoft Access. Your completed assignment will have two files submitted: the Crow's Foot ER diagram and the Microsoft Access database file (an .accdb file).

My Closet is a small online company that sells dresses. All customer orders to My Closet are ordered from the dressmaker at the time of sale.

My Closet can order dresses from multiple dressmakers.

Every dressmaker produces one or more different styles of dresses.

Every style is produced by only one dressmaker.

Every style has one or more colors of dresses.

Every dress color made is belongs to only one style.

Every dressmaker is identified by a dressmaker code. The dressmaker name, address, email, phone number, and account number are kept for every dressmaker.

Every dress style is identified by a style code. The style name and price are kept for every style.

Every color is identified by a color code. The color name and the available sizes for that color are kept for every color.

Reference no: EM132726753

Questions Cloud

What is the increase or decrease to business income for tax : The only asset sold for $199,500, what is the increase or decrease to business income for tax purposes resulting from the above information?

Plot an exxonmobil yield curve on the same graph : As an approximation, plot an ExxonMobil yield curve on the same graph with the Treasury bond yield curve

Find and calculate the contribution margin per unit : The variable manufacturing costs will be $50 per unit and the fixed costs are estimated to be $5777. Calculate the contribution margin per unit.

What is the estimated net operating income for july : What is the estimated net operating income for July? Forty percent of credit sales are collected in the month of the sale and 60% in the following month.

Design a database : Design a database using the following information. Using Microsoft Visio 2013, create a complete E-R Diagram in Crow's Foot notation

What is the yield to maturity : The bonds may be called in 5 years at 109% of face value (call price 5 $1,090). What is the yield to maturity

Compute what is the estimated unit product cost : If the company always uses an estimated predetermined plant-wide overhead rate of $10 per direct labor-hour, what is the estimated unit product cost?

Create network for company that sells shoes : Create a network for a company that sells shoes. Describe the hardware needed and the size of the network (PAN, LAN, WAN)

At what price would the bonds sell : Two years after the bonds were issued, the going rate of interest on bonds such as these fell to 6%. At what price would the bonds sell

User Account

All Pages