This project is dealing with the fundamentals of database design. I will need someone to be available “Friday May 3rd at 6pm Pacific?? time to answer some questions. I will have one question or set of questions that you will be given an hour to complete. The total time I will need you to assist me is two hours. I would like to use Microsoft Messenger to communicate although email would be just fine. The following is a list of terms and subjects I will be asking questions on. Database processing systems Hierarchy of data User data, metadata, application metadata, indexes DBMS Application programs Schema Domain Identifier Attributes=columns=fields Tuples=rows=records Relations=tables=files Entities, entity classes, instances, weak entities, strong entities, subtype and supertype entities Relationships, cardinality, degree of relationships Semantic Object, simple object, composite object, compound object, association object Key Functional dependency, determinant Modification anomalies Normalization, first normal form, second normal form, third normal form and DK/NF Converting Data Models to tables, both E-R diagrams and Semantic Object diagrams How we represent the relationships when converting the model to the tables: 1:1, 1:N, M:N The role of keys (aka. identifiers) Simple Object, Composite Object, Complex Object conversion to tables Recursive relationships Supertypes/subtypes Logical Key, physical key, index Understand and create an E-R diagram Understand an SOM diagram
Completely answer all question I send vial email or chat within the time allotted.