Redo the Music store ERD from the previous lab assignment. This time, create a supertype of product and have four subtypes for product. These subtypes should be sheet music, instruments for sale, supplies, and lessons. Determine what fields these items all share in the supertype and then provide at least three attributes for each subtype that are particular to that type of product.

The 'type' and 'other attributes' of a variable, in addition to the variable's name, are required to be mentioned in the definition of the variable. To put it another way, in addition to being a data type, each and every variable also has a number of properties. In the future, it would be helpful if you could expound on the concept that would enable us to more correctly characterise the features of any variable.

What are the basic steps of the search for concept location? Draw the diagram.

. Below is a description of the business process of a hospital.After reading the business process below, provide an ERD showing the primary key, all attributes,relationships, and cardinalities as in the sample ERD.     When developing ERD, you must use a diagramming tool. Using an ERD tool is a part of diagramdrawing, so hand-drawn ERD will not be accepted. While various free ERD drawing tools areavailable on the web, some tools may require you to pay depending on the tool and the plan you select.You may refer to this list https://clickup.com/blog/erd-tools/ and select a tool you want. However, thetools you may select are not limited to the list in the link.Once you have completed your diagram, print it as a PDF file and submit it to CougarVIEW dropbox.If you need multiple pages to include all your tables, print it in multiple pages.Description of business processIn hospital, there are many departments like Orthopedic, Pathology, Emergency, Dental,Gynecology, Anesthetics, I.C.U.,…

Which among the following statements is false about verification and validation of use case diagram? O a. All relationships should be shown on use case diagram as per the use case description. O b. All diagram specific rules must be enforced. O c. There should be one and only one description for each use case. O d. The sequence of use case description need not match the sequence in the activity diagram.

Draw an ERD containing the Transaction and Item entities. When a transaction is made, the date (TransDate) and type (TransType) together with TransNo (primary key) must be recorded. For an item, add attributes of ItemNo (primary key), ItemType, and RawCost. A transaction may include multiple items and an item may be included in multiple transactions. When an item is included in a transaction, Quantity and TransPrice of the item must be recorded.

A candidate key is assigned to each of the qualities that make up a composite primary key. What kind of response would you have to this piece of information?

Discuss your database table possibilities for creating subtype relationships.Talk about what you would look for in a design and how it would affect your final selection.

Draw a Sequence Diagram to show the steps of viewing final grade of one course through edugate-Portal. please give me best correct answer

Please help me answer the following questions